Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

SQL Server: Query Plan Analysis

Learn how to interpret and analyze SQL Server query plans, making performance problems easier to recognize and understand, applicable to developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onwards

Joe Sack - Pluralsight course - SQL Server: Query Plan Analysis
by Joe Sack

What you'll learn

SQL Server query plans contain a wealth of information that can be used to diagnose performance problems, but at first glance they appear complicated and difficult to understand. With more than 30 detailed demos, this course shows you how to easily understand and interpret query plans so you can pinpoint performance problems. The course starts by explaining the various methods of capturing query plans for later analysis, and how to recognize the basic elements of query plans along with their CPU, I/O, and memory costs and requirements. It then moves on to explaining all the common query plan operators and when they will be present in a query plan, along with notes on potential problems to watch out for. The final module explains common patterns to look for in query plans that indicate a performance problem that should be investigated and fixed. This course is perfect for developers, DBAs, and anyone responsible for SQL Server performance, from complete beginners through to those with more experience who want a definitive guide to SQL Server query plans. The information in the course applies to all versions from SQL Server 2005 onwards.

Table of contents

About the author

Joe Sack - Pluralsight course - SQL Server: Query Plan Analysis
Joe Sack

Joe Sack is a Principal Program Manager in the SQL Server and Azure SQL Database product team at Microsoft, with a focus on query processing. With over 19 years of experience in the industry, Joe is an author and speaker, specializing in performance tuning and optimization.

More Courses by Joe