Expert-level query tuning and performance analysis requires a deep understanding of both the query optimizer and the execution plans it produces.
This full-day workshop begins by covering the design and operation of the SQL Server Query Optimizer in depth. Starting with a clear overview of the basics, the session progresses rapidly to look at the detailed and often subtle behaviours that have real impacts on almost every query you write.
The second part of the workshop starts with an introduction to the Query Execution Engine, looks at query plan operators in detail, and covers the main things you need to check for in execution plans. We then move on to further develop the deep technical knowledge and practical skills you will need to start analyzing execution plans to an expert level.
Understand how the query optimizer works, become familiar with its strengths and weaknesses, and learn how to design databases and write queries to get the best from it.
Develop the skills necessary to accurately assess query plans, select targets for improvement, and make effective changes.
Acquire a comprehensive set of reference material and detailed T-SQL code examples that will be useful for years to come.
Attendee’s desired pre-requisites/profile
This workshop is suitable for intermediate to advanced level SQL Server users, developers, and database professionals that would like to improve their current understanding of SQL Server execution plans and query optimization.
Only basic knowledge of the T-SQL language is required, but previous exposure to working with execution plans at some level will be beneficial. At the other end of the scale, even advanced SQL Server professionals will find many new insights and internal details in the material presented.
Required/Suggested Materials and Software
None on the day. The code examples provided are targeted at SQL Server 2005 (or later).
About Paul White
Paul White is an international SQL Server technical consultant, specializing in performance tuning the SQL Server Core Engine. He lives in New Zealand and has worked with SQL Server for more than 15 years. Paul has been a SQL Server MVP since 2011, and regularly speaks at user groups, SQL Saturdays, the annual PASS Summit, and other international conferences.
Technical Articles: SQLperformance.com
Technical Blog: SQLblog.com
Public email: SQLKiwi@gmail.com
Tem dúvidas sobre Mastering Execution Plan Analysis – by Paul White?
Contacte Tuga Association