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?
Comments
1 comment
-
Good Morning!
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
Add comment
Please sign in to leave a comment.