RSVP on the MeetUp site. The presentation will be in the Microsoft Store in Oakbrook Center Mall (next to Crate & Barrel)
49 Oak Brook Center, Oak Brook, IL 60523
Pizza will be served at 12:30 PM and the presentation will start at 1pm.
I’ve been asked in the past for advice on Team Foundation Server (TFS) migrations. As an ALM Ranger I included a section in the upgrade guidance that covered what you should plan for. Items that need to be considered in the environment for an upgrade:
Application tiers (AT)
- How many processors does the AT have? Minimally I recommend 4 processors.
- Do you have multiple ATs? Do they have the same number of resources? Migrations will run between multiple ATs and so they should have the same number of resources allocated to them.
- How many processors? Minimally I recommend 4 processors.
- Amount of RAM? If your TFS databases are more than 50GB you should have 8GB of RAM and adjust the RAM by 4GB for each increment of 50GB in database size.
- How many of TempDB data files on the SQL Server? There should be one per processor.
- What is the index fragmentation on the SQL Server for the TFS dbs? You should have less than 1% fragmentation on your table indexes.
- Workspaces older than 6 months? You should delete any workspaces that are older than six months.
- What is the MaxDoP on the SQL Server? I have seen that you can change it from the default of zero and could be set to half the number of processors in the SQL Server.
- Do you have your TFS dbs on mountpoints? What is the speed of the disk the dbs are on? You can use Perfmon to montior disk speed. You should have 25ms or less disk access.
- Is SQL Server memory pinned to 85% of memory in SQL Server? This should be standard on any SQL Server implementation.
These are just a few of my recommendations. I would be interested in hearing your experiences.
Brian Randell will be the speaker at this months ALM User Group meeting. Brian spends his time between teaching Microsoft technologies to developers, working with new and emerging technologies like Visual Studio and consulting for clients that that range from large Fortune 100 business to state governments to small businesses.
Meetings Details: Wednesday May 15th 2013
Location: Microsoft’s Downtown Chicago office: 200 E Randolph, 2nd Floor
Agenda: 6:30PM Dinner followed by a presentation and demo at 7pm
THIS IS IMPORTANT! You have to be registered by Tuesday evening to be able to attend. You need to be on the AON building’s security list to be able to get onto the Microsoft floor.
I was happy to have the opportunity to speak to the Chicago ALM User Group Wednesday on source controlling databases and at the Chicago Code Camp on a variety of TFS 2012 topics. As promised, here are my links.
Visual Studio ALM Rangers Guidance
Micorosoft’s Hosted TFS Service Signup
Red Gate products: specifically SQL Server Source Control, SQL Test, Oracle Tools and Deployment Manager
My TFS 2012 Presentation from Software Development Community
Brian Keller’s Downloadable TFS 2012 Virtual Machine and Labs
SQL Server Data Tools 2012
Visual Studio Virtual Labs
Chicago Code Camp is a yearly developer community event put on by the Lake County .NET User Group. This year I’ll be presenting on the new Application Lifecycle Management (ALM) features of Team Foundation Server (TFS) 2012.
If you haven’t registered already for the event you’re out of luck to attend since it is sold out. I’ll post my presentation and hopefully a recording of the event next week.
On Wednesday April 24th I’ll be presenting on source controlling databases with Visual Studio 2012 and Team Foundation Server 2012. You already use TFS for managing code, why not use it for database objects? In my presentation I’ll walk you through the options.
The meeting will be held at the Microsoft Office in Downers Grove. You need to RSVP so we know how much food to have and sescurity has to have your name on the list to let you into the office.
The office is located at 3025 Highland Pkwy, Suite 300 in Downers Grove. Dinner is @ 6:30pm and the presentation will start @ 7pm.
Hope to see you there!
Wednesday April 17th CNUG will be having the April meeting at the Microsoft Office in Downers Grove with a triple play:
- Deploying existing applications to Azure
- Windows 8 deep dive
- Introduction to WiX.
5:30PM – Chicago Azure Cloud Users Group – Deploying existing Applications to Cloud
6:30PM – Food and Beverages
7:00PM – Deep Dive into Windows 8
8:00PM – Introduction to WIX
The Microsoft Downers Grove office is located at 3025 Highland Parkway in Downers Grove, IL. You need to RSVP to give them a head count as well as be registered with security to get into the building.