sp_whoisactive Documentation

Home ... Downloads

Want more tips and tricks? Sign up for the sp_whoisactive email list.

The sp_whoisactive documentation consists of the following articles. Please note that these articles were migrated from blog posts and are still being edited. Please excuse the occasional contextual oddity.

01: A Brief History of Activity Monitoring
02: Design Philosophy
03: The License
04: Installing sp_whoisactive
05: Less Data is More Data
06: Options
07: Default Columns
08: Active Request, Sleeping Session
09: Deciding What (Not) To See
10: Commands, Batches, and the Mysteries of Text
11: "Planning" for Success
12: The Almighty Transaction
13: How Queries Are Processed
14: Blocking, Blockers, and Other B Words
15: Seeing the Wait That Matters Most
16: Seeing All of the Waits
17: Is This Normal?
18: Getting More Information
19: Why Am I Blocked?
20: The Node Knows
21: Analyzing Tempdb Contention
22: The Key to Your Locks
23: Leader of the Block
24: The Output of Your Dreams
25: Capturing the Output
26: Delta Force
27: Who is Active's Hidden Gems
28: Access for All!