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

SQL 2008 SP1 CU4 – includes fixes for http://support.microsoft.com/kb/970823/ (a performance issue) and http://support.microsoft.com/kb/970133/ (a backup hanging issue)

 

Data in SQL 2008 R2 (which is what we are currently running)

SQL 2008 R2 CU2 – includes a fix for http://support.microsoft.com/?id=982850 that can cause Excel date filters to not work.

Brian