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. Blindly trying to upgrade based on SQL Server hardware recommendations can make things more expensive than they need to be.
70 Minutes, Streamed