Updates!
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.
you would probably want to update your copywrite, from ██╗ ██╗██╗ ██╗███╗ ███╗ █████╗ ███╗ ██╗
██║ ██║██║ ██║████╗ ████║██╔══██╗████╗ ██║
███████║██║ ██║██╔████╔██║███████║██╔██╗ ██║
██╔══██║██║ ██║██║╚██╔╝██║██╔══██║██║╚██╗██║
██║ ██║╚██████╔╝██║ ╚═╝ ██║██║ ██║██║ ╚████║
╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═╝╚═╝ ╚═╝╚═╝ ╚═══╝
███████╗██╗ ██╗███████╗███╗ ██╗████████╗███████╗
██╔════╝██║ ██║██╔════╝████╗ ██║╚══██╔══╝██╔════╝
█████╗ ██║ ██║█████╗ ██╔██╗ ██║ ██║ ███████╗
██╔══╝ ╚██╗ ██╔╝██╔══╝ ██║╚██╗██║ ██║ ╚════██║
███████╗ ╚████╔╝ ███████╗██║ ╚████║ ██║ ███████║
╚══════╝ ╚═══╝ ╚══════╝╚═╝ ╚═══╝ ╚═╝ ╚══════╝
Copyright 2022 Darling Data, LLC
This is the worst comment ever written in the history of the internet.
BTW, love your very useful blog posts and stored procs, thank you!
This is the best comment ever written in the history of the internet.
You can write “A Tale of Two Comments”, just like Charles Dickens 😉
Will these changes be updated in Install-DbaDarlingData?
I’m not following you here — what needs to get updated?
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.
I didn’t create that module, and I don’t really use it, so I don’t know.
What happens when you run the command?
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.