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 info
Level
Advanced
Updated
Oct 17, 2019
Duration
2h 30m
Table of contents
Description
Course info
Level
Advanced
Updated
Oct 17, 2019
Duration
2h 30m
Description

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.

About the author
About the author

Pinal Dave is a Pluralsight Developer Evangelist.

More from the author
MariaDB Functions Playbook
Advanced
1h 42m
Nov 13, 2019
MariaDB Data Manipulation Playbook
Intermediate
1h 35m
Nov 12, 2019
More courses by Pinal Dave
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is Donald Away. Welcome to my new course analyzing credit plants. I'm a sequel server performance shooting expert at sequel atari dot com. To solve any problem, it is critical that we have recruit goes off it. Similarly, if you have a slow performing secrets reliquaries, analyzing very plants is like finding good goes off your poorly performing queries. This course gives you a comprehensive you off major components off analyzing credit plants. You just need a basic understanding off secrets. About 40 scores some of the major topics that we will cover, sir, how to capture query plants using extended events and places. I didn't define poorly performing very plant operators. How to create efficient query plants using query store. How to compare estimated and actual query plants and configuring azure sequel databases. Performance inside. By the end of this course, you will have a solid foundation to get started with analyzing credit plants during the course. Along with finding the root cause off slow performing queries, we will also learn how to resolve major performance bottlenecks off it as well. I hope you will join me in this journey to learn analyzing query plants at little side