Question
sp_WhoIsActive default output versus @delta_interval output: when should each be used?
Answer
Default output is a point-in-time activity snapshot. @delta_interval takes two snapshots and returns interval deltas for eligible metrics. Use default for immediate triage; use a delta interval to identify sessions actively consuming CPU, reads, writes, or tempdb.