Workitem is slow when doing a Save or Update in TFS2008

Recently we came across a unique issue while working with my customer that I would like to share.

It may come in handy for anyone else out there that may see the same symptom. When trying to save any workitem, you will notice the hour glass staying up about 8-10 seconds causing a delay. It occurs three out of four tries and consistent enough to be annoying. After much troubleshooting, we found it was due to the 64-bit edition of SQL Server 2005. Below is the article we used to resolve this problem:

How to reduce paging of buffer pool memory in the 64-bit version of SQL Server 2005

support.microsoft.com/kb/918483

The easiest way to determine if you are running into the same issue is to check the SQL Server error log for

the errors listed in article 918483.

You could also run performance monitor and add the following counter =>Process: Working Set: sqlserver. Reproduce the issue and check the Working Set values to see if it displaying any erratic numbers.

Also I found another helpful SQL tool that can help troubleshoot SQL related issue called SQLdiag utility.

You can run SQLdiag, then reproduce a problem, and then stop this tool. Once the SQLdiag is stopped, it will spit some very useful information that can be helpful.

Again, this problem is specific to 64-bit version of SQL Server 2005.

Have fun!

Manoj