When you check out a file from a server that is running Microsoft Visual Studio Team System 2008 Team Foundation Server Service Pack 1, it takes more than a minute to complete the checkout.
This problem occurs because the Prc_ichecklockstatsus stored procedure runs very slowly in the Team Foundation Server data tier.
Important If you are running Team Explorer, Team Build or the TFS Proxy on the same computer as the TFS Application Tier, you will also need to install the hotfix that is described in the following Knowledge Base article:
974596 The size of the TfsVersionControl database is not reduced as much as expected when you run the "tf destroy" command in Microsoft Visual Studio 2008 Team Foundation Server
A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.
To resolve this problem immediately, contact Microsoft Customer Support Services to obtain the hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft website:
Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.
To download this hotfix from the MSDN Code Gallery, visit the following Microsoft website:
Note The MSDN Code Gallery displays the languages for which the hotfix is available. If you do not see your language listed, it is because the Code Gallery resource page is not available for that language.
Alternatively, you can download this hotfix from the following Microsoft Connect website:
To apply this hotfix, you must have Visual Studio Team System 2008 Team Foundation Server Service Pack 1 installed.
You may have to restart the computer after you apply this hotfix.
Hotfix replacement information
This hotfix does not replace a previously released hotfix.
The English (United States) version of this hotfix installs files that have the attributes that are listed in the following tables. The dates and the times for these files are listed in Coordinated Universal Time (UTC). The dates and the times for these files on your local computer are displayed in your local time together with your current daylight saving time (DST) bias. Additionally, the dates and the times may change when you perform certain operations on the files.