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.
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.
Table of contents
- Version Check 0m
- Introduction 1m
- What Is a Query Plan? 2m
- Query Execution Plan Stages 3m
- Why Analyze Query Plans? 2m
- Demo: Execution Plans 6m
- How to Analyze Query Plans? 2m
- What Is SQL Profiler? 2m
- Demo: SQL Profiler 3m
- Demo: SQL Trace 5m
- What Are Extended Events? 2m
- Demo: Extended Events 9m
- Summary 0m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 81 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.