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