I know, I know. Those CPUs are expensive, and your boss won't let you anywhere near the magic upgrade button until you can prove you need more.
In this course, you'll learn about wait stats like CXPACKET, CXCONSUMER, SOS_SCHEDULER_YIELD, THREADPOOL, and how to use them to figure out if your server is truly bottle-necked, or if you've made some bad decisions.
Don't make SQL Server more expensive than it needs to be.
70 Minutes, Streamed