In Trunks
I’ve made a few changes and improvements to these scripts. Here’s the changelog:
- Improved introduction
- Added help section
- Changed column order to put DOP information next to thread usage information
- Added reserved threads to the CPU overview (2016+)
- Added a filter to the “maintenance” section to screen out automatic statistics updates (SELECT StatMan…)
A new function!
- I added an inline table valued function to strip characters from a string
You can grab updated versions and get support over on GitHub.
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.