use ApplicationDatabase; select db_name(lckes.database_id) as database_name, object_name(lckes.object_id, lckes.database_id) as object_name, i.name as index_name, lckes.partition_number, lckes.index_lock_promotion_attempt_count, lckes.index_lock_promotion_count, (cast(lckes.index_lock_promotion_count as real) / lckes.index_lock_promotion_attempt_count) as percent_success from sys.dm_db_index_operational_stats(db_id(), null, null, null) lckes inner join sys.indexes i on lckes.object_id = i.object_id and lckes.index_id = i.index_id where lckes.index_lock_promotion_count > 0 order by index_lock_promotion_count desc;
Column | Description ---------------------------------- | ------------------------------------------ database_name | Database name. object_name | Object name. index_name | Index name. partition_number | Partition number within the index or heap. index_lock_promotion_attempt_count | Cumulative number of times the database engine tried to escalate locks. index_lock_promotion_count | Cumulative number of times the database engine escalated locks. percent_success | Percentage of successful lock escalations.
database name, object name, index name, partition number, and lock promotion statistics