I'm curious which wait types are included in the metric 'Avg Lock Wait Time'.

krshort

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?

squigley

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