Jun 02 - 04 | 2020 Antwerp, Belgium
09:00 - 17:00

SQL Server Performance Tuning in a Day

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

brent-ozar.jpg
Brent Ozar

I make SQL Server faster and more reliable.

Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz® and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com. He holds a bunch of certifications and awards including the rare Microsoft Certified Master.