You’re stuck with a database server that’s not going fast enough. You’ve got a hunch that the biggest bottleneck is inside the database server somewhere, but where? In this one-day class, you’ll learn how identify which queries are killing your server, what parts of the database server are holding you back, how to tackle indexing improvements, and how to identify query anti-patterns. You'll get your developers, sysadmins, and DBAs all on the same page, talking about the same metrics, and understanding whether the right fix is code, indexes, or hardware.
Microsoft Certified Master Brent Ozar will show you:
* How wait stats tell you where to focus your tuning
* How the plan cache shows you which queries are the worst
* How to make fast improvements by picking the right indexes
* How to identify and fix the most common query anti-patterns