http://blogs.technet.com/reeds/archive/2006/09/12/455684.aspxIf you are having trouble performance tuning SQL Server 2000, there is one whitepaper you need. It’s called “SQL Performance Tuning using Waits and Queues” and it’s written by Tom Davidson. It takes the guesswork and voodoo out of tuning. The way it worken-USCommunityServer 2.1 SP1 (Build: 61025.2)