Do you struggle to understand why a query is running slowly, or why it runs quickly most of the time but occasionally takes much longer? Being able to review and interpret query execution plans is crucial for identifying bottlenecks in database performance. Not only must DBAs understand execution plans for proactive performance management, but developers also need to review these plans as queries and procedures are developed. In this session, you’ll learn how to gather and read execution plans, understand what query operators are and what actions they perform, and distinguish between different plan types. Finally, you’ll discover how to improve your code and enhance performance by leveraging the insights revealed in these plans.
Topics that will be discussed include:
- Gathering and reading SQL Server query execution plans
- Understanding query operators and their functions
- Differentiating between various execution plan types
- Improving code performance using execution plan data
Speaker:
- Monica Rathbun, Microsoft MVP for Data Platform, Microsoft Certified Solutions Expert, and VMware vExpert at Denny Cherry and Associates Consulting
Intervenants