Link to home
Start Free TrialLog in
Avatar of Baber Amin
Baber AminFlag for Canada

asked on

lock escalation count since when

Hi,

I have a question that below query show the lock escalation count. That count is since when? Is it
- since database created?
- since database server restarted?


SELECT
db_name(dios.database_id) AS database_name,
object_name(dios.object_id, dios.database_id) AS
object_name,
i.name as index_name,
dios.partition_number,
dios.index_lock_promotion_attempt_count,
dios.index_lock_promotion_count,
(cast(dios.index_lock_promotion_count AS real) /
dios.index_lock_promotion_attempt_count) AS
percent_success
FROM
sys.dm_db_index_operational_stats(db_id(), null,
null, null) dios
INNER JOIN
sys.indexes i
on dios.object_id = i.object_id
and dios.index_id = i.index_id
WHERE dios.index_lock_promotion_count > 0
ORDER BY index_lock_promotion_count desc;
Avatar of PortletPaul
PortletPaul
Flag of Australia image

sys.dm_db_index_operational_stats (Transact-SQL)
How the Counters in the Metadata Cache Are Reset
and the cumulative counts may reflect activity since the instance of SQL Server was last started.
Avatar of Baber Amin

ASKER

can you please explain in few words for me?
ASKER CERTIFIED SOLUTION
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial