When you wanna know which queries are running right now, sp_WhoIsActive is pretty much the world standard. However, there are some situations where you need to jump back in the past and troubleshoot complex issues like memory grants. I show how to use both sp_BlitzWho and sp_WhoIsActive for real time troubleshooting, plus set up an…
06 Check Which Queries Are Running with sp_BlitzWho and sp_WhoIsActive
When you wanna know which queries are running right now, sp_WhoIsActive is pretty much the world standard. However, there are some situations where you need to jump back in the past and troubleshoot complex issues like memory grants. I show how to use both sp_BlitzWho and sp_WhoIsActive for real time troubleshooting, plus set up an...
To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.
- 00 Prerequisites Before the Class
- 01 Doing a Server-Wide Health Check with sp_Blitz
- 02 Doing a Server-Wide Performance Check with sp_BlitzFirst
- 03 Using sp_BlitzCache to Find the Queries Causing Your Top Waits
- 04 Using sp_BlitzIndex to Diagnose the Most Urgent Index Issues
- 05 Analyzing Deadlocks with sp_BlitzLock
- 07 Check Your Data Risks with sp_BlitzBackup
- 08 Automate the Data-Gathering Process with the Consultant Toolkit
- 09 Recap and Writing Up Your Findings