Updates to sp_QuickieStore, sp_PressureDetector, and sp_HumanEvents

A Thing Of Things

sp_QuickieStore:

• Added the ability to search query store wait stats for queries that generated a large amount of a specific wait category.
• Noticed a couple TOP queries were missing DESC for the ordering
• Increased length of all_plan_ids column to max after someone said they hit a truncation error with a length of 1000
• Updated documentation to reflect more specific version support: 2016 SP2+, SQL Server 2017 CU3+, 2019+, and Probably Azure

sp_PressureDetector:

• Added a parameter to skip getting execution plans when server is really hammered
• Added database name to memory query
• Added a missing isolation level set
• Increased decimal length for servers with larger amounts of memory

sp_HumanEvents:

• Updated procedure to format queries to suit current formatting memes I enjoy
• Organized the procedure a little bit better, putting all the declared variables and temp table creation at the beginning
• Fixed some inevitable bugs that come with formatting and reorganizing really long stored procedures
• Cleaned up error handling
• Added a check for the signed query hash action; I found the procedure failed on some earlier builds of 2014 and 2012

So uh, go get those. Use’em. Have fun.

Do a SQL.

Thanks for reading!

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.