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. 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.