CHAPTER 2

image

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.