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. ...

Get Pro SQL Server Wait Statistics now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.