Tag-arkiv: escalation locks

Track down escalation locks

— You can use sys.dm_db_index_operational_stats to — track how many attempts were made to escalate — to table locks (index_lock_promotion_attempt_count), — as well as how many times escalations actually — succeeded (index_lock_promotion_count). — The following query shows the top 5 … Læs resten

Udgivet i SQL Server - scripts | Tagget , , | Kommentarer lukket til Track down escalation locks