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

You know all those PAGEIOLATCH waits you're seeing? That's your SQL Server reading data from disk because you didn't love it enough. In this course, you'll learn why your SAN really isn't as fast as the brochure from your vendor says it is. You'll also learn what those "15 second I/O warnings" in your error log really mean, and the One Weird Trick™ a DBA needs to fix it. 30 Minutes, Streamed

RAM, Memory, that thing your VM Admin won't give you any more of. No matter what you call it, it's one of the most crucial design choices when a DBA is building or reviewing SQL Server hardware. This isn't another hour of staring at outdated metrics like PLE, this is a modern look at how your database uses memory, and your actual SQL Memory Requirements. 70 Minutes, Streamed

IO_COMPLETION, SLEEP_TASK, EXECSYNC, RESOURCE_SEMAPHORE_QUERY_COMPILE, MEMORY ALLOCATION, CMEMTHREAD, ASYNC_NETWORK_IO…? Let’s dive into some of the weirder waits you might see coming from SQL Server, how they can be part of performance problems, and how to solve them. If you have questions about any of these wacky waits or SQL Server hardware limits, look no further. 20 Minutes, Streamed