I am very much delighted that my 25th online video course with Pluralsight is released yesterday. After a long time, I got the opportunity to work on my favorite area of SQL Server Performance Tuning and I have built a video course on the topic of Analyzing SQL Server Query Plans.
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.
Here are the major topics which I will be covering in the course:
- Course Overview
- Capture Query Plans Using Extended Events and Traces
- Identify Poorly Performing Query Plan Operators
- Create Efficient Query Plans Using Query Store
- Compare Estimated and Actual Query Plans and Related Metadata
- Configure Azure SQL Database Performance Insight
- Summary
The course is of only 2 hours and 30 minutes and if you have a Pluralsight subscription, you can watch it for free. If you do not have a Pluralsight subscription, you can still watch the course for FREEÂ by signing up for a trial account.
I like to continuously improve myself so I have the following three questions for everyone who is willing to help me out.
- Out of all the demonstrations, which three are the most favorite demonstrations?
- Out of all the demonstrations, which is your least favorite demonstration and why?
- If you would love me to add one more topic to the course, what would have me covered in addition to what I have already covered in the course?
Your feedback will matter the most to me and I would be happy to improve based on your feedback. Please leave your feedback in the comments section.
Reference:Â Pinal Dave (https://blog.sqlauthority.com)
