top of page

SQL Server object with most latch contention

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;

5 views0 comments

Recent Posts

See All

コメント


bottom of page