Updates To sp_HumanEvents, sp_QuickieStore, And More!

For Free!


Here’s some stuff I’ve been working on lately:

sp_HumanEvents:

  • Added the recompile_cause column to the output of the recompile event
  • Added the wait_resource column to the blocking event output
  • Fixed a bug around table creation
  • MsSQLServerDBA fixed an issue where GO statements were preventing deploying with DBA Tools
  • Remove a recompile hint that was leading to high tempdb allocations (more on that tomorrow)

sp_QuickieStore:

  • Fixed a bug where date filtering was messing up query results

Enjoy, and as always, please let me know if there’s anything I can do to improve the scripts usability, or any issues you encounter while using them.

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 performance problems quickly.



2 thoughts on “Updates To sp_HumanEvents, sp_QuickieStore, And More!

  1. Hey! About dbatools PS module – if Invoke-DbaQuery stumbles upon a “GO” word surrounded in a string by whitespaces only, then it splits the input script where GO was found and then it executes it part by part with some .net stuff. They don’t / can’t analyze it if GO is inside quotes or comments. Therefore truncation can happen so it’s kinda by design.

    https://github.com/sqlcollaborative/dbatools/blob/development/internal/functions/Invoke-DbaAsync.ps1#L163 (yeah I’m tryin’ to be a smartass)

Comments are closed.