Updates to sp_PressureDetector, sp_HumanEvents, sp_QuickieStore, And More!


If you use any of my stored procedures, I’ve been doing a lot of work on them lately to improve performance, add features, and fix bugs.

There have been a lot of changes over the past few months, and the full list would be a little unwieldy.

  • sp_HumanEvents: Mostly adding useful columns the output and improving the XML processing
  • sp_HumanEventsBlockViewer: This is a newer procedure to examine a blocked process report extended event session, and not a lot of folks know about it. Try it out!
  • sp_PressureDetector: Added tempdb configuration and usage details, some more wait stats, additional CPU details, etc. A fan favorite.
  • sp_QuickieStore: Added the ability to analyze multiple databases, improve speed, and add more helpful details to the output
  • sp_WhoIsActive Logging: Added a procedure to create a view over all of the daily logging tables

If you use any of these, get those updates going. If you’re not using them: what are you waiting for? They’re free!

Thanks for reading!

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.

10 thoughts on “Updates to sp_PressureDetector, sp_HumanEvents, sp_QuickieStore, And More!

  1. you would probably want to update your copywrite, from ██╗ ██╗██╗ ██╗███╗ ███╗ █████╗ ███╗ ██╗
    ██║ ██║██║ ██║████╗ ████║██╔══██╗████╗ ██║
    ███████║██║ ██║██╔████╔██║███████║██╔██╗ ██║
    ██╔══██║██║ ██║██║╚██╔╝██║██╔══██║██║╚██╗██║
    ██║ ██║╚██████╔╝██║ ╚═╝ ██║██║ ██║██║ ╚████║
    ╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═╝╚═╝ ╚═╝╚═╝ ╚═══╝

    ███████╗██╗ ██╗███████╗███╗ ██╗████████╗███████╗
    ██╔════╝██║ ██║██╔════╝████╗ ██║╚══██╔══╝██╔════╝
    █████╗ ██║ ██║█████╗ ██╔██╗ ██║ ██║ ███████╗
    ██╔══╝ ╚██╗ ██╔╝██╔══╝ ██║╚██╗██║ ██║ ╚════██║
    ███████╗ ╚████╔╝ ███████╗██║ ╚████║ ██║ ███████║
    ╚══════╝ ╚═══╝ ╚══════╝╚═╝ ╚═══╝ ╚═╝ ╚══════╝

    Copyright 2022 Darling Data, LLC

      1. Apologies for not coming through clearly. I was just curious if the sp_WhoIsActive logging procedures and sp_HumanEventsBlockViewer will be included in the Install-DbaDarlingData command in the dbatools module.

          1. If there isn’t a local file set in the PS command, Install-DbaDarlingData will download the latest versions of sp_HumanEvents, sp_PressureDetector and sp_QuickieStore from your GitHub repository and install or update them on your specified database instance.

Comments are closed.