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 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