Database | Indexes | Latch Stats

Knowledge of which indexes have the most page latch requests and latch waits can be useful when tuning database design and queries, and can also help with identifying I/O latency and the tables most affected.

Warning: This uses sys.dm_db_index_operational_stats, which gets its data from the cached metadata for each object. This is lost when the service restarts, and also at other times - for example if there is memory pressure or an index is rebuilt. Heavily used indexes are likely to remain cached, and so the information in this report should be accurate for the recent past for these indexes.

What It ShowsComments
Object Name
Index Name
Page I/O latchesThe cumulative number of page I/O latches requested
Page latchesThe cumulative number of page latches requested
Average page I/O latch waitA high value here may indicate I/O issues
Average page latch waitA high value here may suggest that a table or group of pages is a hot-spot, with high contention for those pages in the buffer cache
< Database | Indexes | Lock Stats Database | Indexes | Scans and Lookups >