Performance | SQLOS | Latch Stats

All latch classes ordered with the total wait time at the top of the report. You can change the sort order by clicking the arrows at the top of each column. Click the + next to each latch class for more detail.

These figures are accurate from the last time the latch stats were cleared, which is either the last service restart or the last time they were manually cleared using DBCC SQLPERF.

What It ShowsComments
Latch classThe name of the latch class
Total wait time (ms)The cumulative wait time since the stats were last cleared
% of total
Average wait (ms)Total wait time divided by the waiting requests count
Waiting requests countThe number of times a wait has occurred on this class
Max wait (ms)
< Performance | SQLOS | Wait Stats Performance | SQLOS | Schedulers >