• Log In
  • Contact Brent
Product has been added to your cart.
  • Consulting
    • Performance Tuning
    • Remote DBA Services
    • Upgrades and Migrations
    • Consultant Toolkit
  • Training
    • My Videos and Downloads
    • My Account
    • Corporate Group SQL Server Training
    • Conferences
    • Training FAQ
  • Monitoring
  • Scripts
    • sp_Blitz – free health check
    • sp_BlitzCache – find queries to tune
    • sp_BlitzFirst – instant performance check
    • sp_BlitzIndex – design the right indexes
    • sp_BlitzWho – what’s happening right now
    • PasteThePlan – share query plans
  • Blog
    • T-SQL
    • Query Exercises
    • Execution Plans
    • Indexing
    • Videos
    • Architecture
    • Backup and Recovery
    • Cloud Computing
    • Development
    • First Responder Kit
    • High Availability
    • Humor
    • Locking, Blocking, and Isolation Levels
    • Parameter Sniffing
    • Production Database Administration
    • Professional Development
    • SQL ConstantCare

sp_BlitzWho

Home
First Responder Kit
sp_BlitzWho

How to Get Live Query Plans with sp_BlitzWho

Last Updated November 18, 2017
Brent Ozar
Execution Plans, First Responder Kit, sp_BlitzWho, SQL Server 2016
4 Comments
sp_BlitzWho is our open source replacement for sp_who and sp_who2. It has all kinds of really neat-o outputs like how many degrees of parallelism the query is using, how much memory it’s been granted, how long it’s been waiting for memory grants, and much more. If you’re on SQL Server 2016 SP1 or newer, it…
Read More

© Brent Ozar Unlimited®. All Rights Reserved.
Privacy Policy – Terms and Conditions

  • Consulting
  • Training
  • Monitoring
  • Scripts
  • Blog