Capturing and Analyzing Blocking with sp_HumanEvents
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.
Related Posts
- Why Read Committed Queries Can Still Return Bad Results In SQL Server
- Join Me And Kendra Little At PASS For Two Days Of SQL Server Performance Tuning Precons
- Updates To sp_QuickieStore, sp_HumanEventsBlockViewer, and sp_PressureDetector
- Join me In Boston May 10 For A Full Day Of SQL Server Performance Tuning Training
It’s freaking amazing and I love it.
I watched this and put it in a test system yesterday. I just wasn’t sure how this works when you’re reading form an *.xel file from the operating system in terms of how to specify the parameters. I’ll work it out but just in case someone else complains…I have a sample file from another procedure but I’m not sure if the format is the same. (It’s a Frankenstein merging of Kendra, Jeremiah and Ken Fisher’s work)
Hi Kevin — it may still work, but I’m not sure what the script(s) you’ve assembled look like.
Thanks!