SQL Server object with most latch contention
- Kunal Ranpura
- Jul 28, 2019
- 1 min read
SELECT TOP (5) a.database_id,
so.object_id,
so.name AS TableName,
a.page_latch_wait_count ,
a.page_latch_wait_in_ms,
a.page_lock_wait_count,
a.page_lock_wait_in_ms
FROM sys.dm_db_index_operational_stats(DB_ID(), NULL, NULL, NULL) a
INNER JOIN sys.objects AS so
ON a.object_id = so.object_id
WHERE so.type = 'U' AND a.page_io_latch_wait_count > 0
ORDER BY a.page_latch_wait_count DESC;
Comments