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 Shows||Comments|
|Latch class||The 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 count||The number of times a wait has occurred on this class|
|Max wait (ms)|