- Course
Analyzing SQL Server Query Plans
Every database server runs different workloads and queries. You will learn how to analyze query plans and troubleshoot SQL Server performance problems.
- Course
Analyzing SQL Server Query Plans
Every database server runs different workloads and queries. You will learn how to analyze query plans and troubleshoot SQL Server performance problems.
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
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.
Analyzing SQL Server Query Plans
-
Version Check | 15s
-
Introduction | 39s
-
What Is a Query Plan? | 2m 9s
-
Query Execution Plan Stages | 3m
-
Why Analyze Query Plans? | 2m 13s
-
Demo: Execution Plans | 6m 5s
-
How to Analyze Query Plans? | 1m 47s
-
What Is SQL Profiler? | 2m 18s
-
Demo: SQL Profiler | 3m 16s
-
Demo: SQL Trace | 5m 8s
-
What Are Extended Events? | 1m 50s
-
Demo: Extended Events | 8m 42s
-
Summary | 26s