Unlocking the Power of WhoIsActive
summary
WhoIsActive is shown with exact commands and repo links and the scripts are ready to download for immediate use. Examples use output_column_list (bracket separated with wildcards), Delta interval sampling to produce per‑second Delta columns, get_transaction_info=1 to reveal trans start time and per‑database log usage. Additional flags: get_plans (current or entire batch XML plans), get_memory_info (granted/requested/used), get_locks XML and fine_block_leaders to surface block_session_count. Built table capture plus a clustered index on collection_time and an agent job prove reliable for historical troubleshooting.
AI-written summary · about
chapters (13)
- 0:00Intro
- 1:34@filter_type and @filter
- 3:08@get_outer_command
- 3:46@get_plans
- 4:53What is REALLY going on now?
- 6:24What filled up the log?
- 7:35What filled up tempdb?
- 8:54What filled up memory?
- 10:14What is causing the blocking?
- 13:02Create a table
- 14:44Create an index
- 15:24Create a job
- 16:18Query the table
related talks
18mApparently, you can "debug" your SQL queries
24mDevOps. Monitoring Databases. On-Premise and Cloud environments
19mMariaDB Observability
29mThe osquery Agent. Performance Tuning @Scale
53mVisualizing Postgres I O Performance for Development
50mPostgreSQL Query Performance Insights
44mBenchmarking in the cloud
45mHello from the other side