How do you use cloud databases? Take the survey.
Options
I'm curious which wait types are included in the metric 'Avg Lock Wait Time'.
krshort
Posts: 12 Bronze 1
This has proven to be a good 'canary in the coal mine' indicator on an old legacy system we have, and we would like to customize this for more specific purposes. Is this canned metric available for us to copy/create a custom metric?
Answers
This metric is ultimately calculated from the Lock wait time (ms) and Lock waits/sec counters in the SQL Server Locks object in perfmon. I don't think it would be possible to customize, though, as perfmon doesn't go into detail about wait types.
https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/sql-server-locks-object?view=sql-server-2017
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?