I was troubleshooting an issue sql related and ran across a good reference article. http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/TShootPerfProbs.doc