Whether you’re a developer or a DBA, you’re probably frustrated with query performance. Why is the app running slow? Why does query performance vary so much? Why can’t your queries run consistently fast?
You’ll learn the tricks of performance tuning in this three-hour session as we cover:
- How to find the worst queries on the server in 60 seconds
- What statistics are and how to tell if they’re causing problems
- How to think like the engine and build your own execution plan
- Why filters are cheap and sorts are expensive
- When you should throw indexes at the problem, and exactly when to stop
- Why temp tables might be the fastest way to fix a problem
- How to identify parameter sniffing problems
This session is for developers and DBAs with 1-4 years of experience who are comfortable writing queries and adding indexes, but aren’t happy with the results they’re getting.
For $195, you get DRM-free downloads in Windows Media, QuickTime MOV, iPhone, and iPad formats.
INTRODUCTORY SPECIAL: for May 7th to May 18th, the price is just $149!
Preview Video
You can use the four-arrows icon at the bottom left of the video to see it fullscreen:
About the Presenter – Brent Ozar
Brent has over a decade of hands-on experience with SQL Server, and he specializes in performance tuning for SQL Server, VMware, and storage. He co-authored Professional SQL Server 2008 Internals and Troubleshooting, and his training sessions have won awards around the world including Best of the PASS Summit for two years running. He was one of the first non-Microsoft folks to achieve the coveted Microsoft Certified Master of SQL Server.
