Every database server runs different workloads and queries, and it's important for a SQL Server Performance Tuning Expert to identify queries that are negatively impacting performance. In this course, Analyzing SQL Server Query Plans, you will gain the ability to identify performance bottlenecks on your database. First, you will learn to analyze query plans. Next, you will discover and understand query execution plans. Finally, you will explore how to resolve the performance bottleneck. When you are finished with this course, you will have the skills and knowledge of analyzing the query plans needed to troubleshoot SQL Server performance problems.
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.