SQL Server Wait Types - Professional SQL Server 2005 Performance Tuning - page 75

Figure 4-5

SELECT session_id,cpu_time,total_elapsed_time
FROM sys.dm_exec_sessions
WHERE session_id = @@SPID

yielded the following results (with zero-valued results removed; (the columns' names have been edited
to make the results easier to read in print form):

waitType waitingTasks waitTimeMs maxWaitTimeMs signalWaitTimeMs

--------- ------------ ---------- ------------- ---------------

LAZYWRITER_SLEEP 2537 2538417 1232 1185

BROKER_TASK_STOP 508 2536779 5070 624

SQLTRACE_BUFFER_FLUSH 634 2533019 4056 46

CXPACKET 42045 605798 452 17362

WRITELOG 12883 68874 733 5694

PAGEIOLATCH_UP 2880 11419 156 312

SOS_SCHEDULER_YIELD 773663 11388 249 10904

LATCH_EX 35127 9516 109 5647

SLEEP_TASK 2948 2527 46 2527

SQLTRACE_LOCK 18 764 405 0

PAGELATCH_SH 79994 468 15 405