SQL Server DBA

sp_WhoIsActive

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.

This is 22 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples