Querying SQL Server Wait Statistics
With the introduction of Dynamic Management Views (DMVs) in SQL Server 2005, viewing and analyzing Wait Statistics has become a lot easier and less tedious. In SQL Server versions prior to SQL Server 2005, we were limited to the DBCC SQLPERF('WAITSSTATS') command to view Wait Statistics. Presently there are a variety of DMVs that return Wait Statistics–related information, and in this chapter we will take a detailed look at three of the most useful DMVs: sys.dm_os_wait_stats, sys.dm_os_waiting_tasks, and sys.dm_exec_requests.
Viewing Wait Statistics information is not only limited to DMVs though. ...