My post on TFS updates a couple of weeks ago generated an internal discussion that resulted in the collection of all of the SQL and Windows updates we’ve had to apply to our Dogfood server to get it running well. Now, you have to remember that our dogfood server runs at incredibly high scale and many of the issues we’ve hit are unlikely to affect you. However, if you really want to be sure you are running your production server as optimally as we run ours, here’s some information that may be useful to you:
App Tier on Windows 2008 R2
http://support.microsoft.com/kb/981898 – There was an IIS race condition that would occasionally cause TFS file downloads to fail.
Data in SQL 2008 SP1
Data in SQL 2008 R2 (which is what we are currently running)