How to check waits in SQL Server 2000? Leave a reply Today I got a comment, how to check the wait statistics in SQL Server 2000. You can query sysprocesses table and use the DBCC SQLPERF to get the wait statistics in SQL Server 2000. select top 5* from sysprocesses dbcc sqlperf(‘waitstats’) Share this:Click to share on Facebook (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Reddit (Opens in new window)Click to print (Opens in new window)Click to share on Twitter (Opens in new window)Click to email this to a friend (Opens in new window)Click to share on Pinterest (Opens in new window)Like this:Like Loading... Related