Output wait duration in a dedicated column

[ant-222]

Proposal

The current version of sp_whoisactive reports wait duration as part of the text value in the wait_info column, which is human-oriented and unamenable to sorting, filtering, or any other automated, machine-based analysis. This is a request for a dedicated numeric column to store this important metric—wait_duration or wait_duration_ms (for milliseconds)—that shall be usable in MSSQL predicates and operators and shall facilitate quantitative lock analysis and automated gathering of wait statistics.

Whereas the numeric value of lock duration is already used internally inside sp_whoisactive, this request should not be hard to implement.

Sample use

1. Monitor waits longer than 30 seconds.
2. Sort collected wait information by duraition.

[imajaydwivedi]

+1 for this enhancement. Is anyone working on this?
If not, I can take this one.