Keeping SQL tuned up helps performance of TFS. Checking the fragementation levels of indexs within the SQL database is straightforward and SQL includes useful defragment commands. Here is a link to a useful best practices document on defragmentation....

The Team System Rangers have released another technical article for TFS Operations which includes our recommended operational best practices. Please take a look at this and let us know what you think: http://msdn2.microsoft.com/en-us/library/bb663036...

Orcas Beta 2 refresh is now available for download. Please read the post by Brian that provides more information on Beta 2 refresh at http://blogs.msdn.com/bharry/archive/2007/09/28/updates-to-tfs-2008-beta-2.aspx You can download the refresh bits...