The TFS administration tools will output error information should a command fail. There is an environmental setting that you can set before running the command that will cause our tools to output more detailed information. Simply set the following variable...

In TFS 2005 the SQL Server Reporting Services (SSRS) had to be on the Application Tier and SQL Server Analysis Services (SSAS) had to be on the Data Tier. With TFS 2008 you can deploy these on remote servers. This is documented in the TFS Installation...

We've updated the Team Foundation Server FAQ on the following MSDN forum. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2776169&SiteID=1 .

An old friend of mine has started a site called Computation Press at http://www.computationpress.com/ . Which has some good papers on SQL tuning tips.