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