Level: Introductory to Intermediate
Query tuning can be complex. It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will share her secrets for determining the best approach for tuning queries by utilizing the performance schema (specifically instrumented wait types, query execution plans, SQL diagramming techniques and more). Regardless of the complexity of your database or your skill level, this systematic approach will lead you down the correct tuning path with no guessing, saving countless hours of tuning queries and optimizing performance of your SQL Server databases.
You will learn:
- How to effectively use wait types to quickly identify bottlenecks and get clues on the best tuning approach
- How to quickly identify inefficient operations through review of query execution plans
- How to use SQL diagramming techniques to find the best execution plan