Analyzing SQL Server Query Plans

Course Overview
(Music playing) Hi everyone! My name is Pinal Dave, welcome to my new course, Analyzing Query Plans. I am a SQL Server Performance Tuning Expert at sqlauthority.com. To solve any problem, it is critical that we have the correct root cause of it. Similarly, if you have slow performing SQL Server queries, analyzing query plans is like finding root cause of your poorly performing queries. This course gives you a comprehensive view of major components of analyzing query plans. You just need a basic understanding of SQL Server for this course. Some of the major topics that we will cover are how to capture query plans using extended events and traces, identifying poorly performing query plan operators, how to create efficient query plans using query store, how to compare estimated and actual query plans, and configuring Azure SQL database performance insight. By the end of this course, you will have a solid foundation to get started with analyzing query plans. During the course, along with finding the root cause of slow performing queries, we will also learn how to resolve major performance bottleneck effects as well. I hope you will join me in this journey to learn Analyzing Query Plans at Pluralsight.