933
Chapter 39: Wait States
39
ignored, even if they are high on the waiting list. Later in this chapter you review some
common waits to watch if they represent a high percentage of wait time on your system.FIGURE 39-1
Querying sys.dm_exec_requests for any request that has a status of running, suspended, or
runnable. The query returns the current wait type of the request as well as the last wait type,
and the total elapsed time for the request.FIGURE 39-2
Returns all data from the sys.dm_wait_stats DMV ordered by the highest waits fi rst. This DMV
returns the number of waits by wait type, total elapsed time, highest wait time, and the total
signal wait time for that wait.c39.indd 933c39.indd 933 7/31/2012 10:04:44 AM7/31/2012 10:04:44 AM
http://www.it-ebooks.info