Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Analyzing SQL Server Query Plans

via Pluralsight

Write review

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access


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.

Syllabus

  • Course Overview 1min
  • Capture Query Plans Using Extended Events and Traces 37mins
  • Identify Poorly Performing Query Plan Operators 38mins
  • Create Efficient Query Plans Using Query Store 30mins
  • Compare Estimated and Actual Query Plans and Related Metadata 23mins
  • Configure Azure SQL Database Performance Insight 15mins
  • Summary 2mins

Taught by

Pinal Dave

Reviews

4.5 rating at Pluralsight based on 101 ratings

Start your review of Analyzing SQL Server Query Plans

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.