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.

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.