Feature Request

Opening a feature request kicks off a discussion.

Proposal:

To add Average Latch Wait Time (ms) latch counter + eventually [Page IO latch waits + Page latch waits + Non Page latch waits ] (Average wait time (ms)) to list of existing performance counters.

Current behavior:

Average Latch Wait Time (ms) is missing from the list of performance counters.

Desired behavior:

Having this performance counter to make correlation with other ones for performance troubleshooting and correlation with other counters and workload pattern changes over the time.

Use case:

To build a baseline of the latch average wait time over the time. Thus, we may may identify sudden or abnormal changes on this value and correlate with recent application changes to understand performance impact on the system for example . For reference: https://docs.microsoft.com/en-us/sql/relational-databases/diagnose-resolve-latch-contention?view=sql-server-ver15