Analyzing SQL Server Query Plans

Focused View

Pinal Dave

2:30:00

53 View

01 - Course Overview#

01 - Course Overview.mp4

01:25

02 - Capture Query Plans Using Extended Events and Traces#

02 - Introduction.mp4

00:39

03 - What Is a Query Plan.mp4

02:09

04 - Query Execution Plan Stages.mp4

03:00

05 - Why Analyze Query Plans.mp4

02:13

06 - Demo - Execution Plans.mp4

06:05

07 - How to Analyze Query Plans.mp4

01:47

08 - What Is SQL Profiler.mp4

02:18

09 - Demo - SQL Profiler.mp4

03:16

10 - Demo - SQL Trace.mp4

05:08

11 - What Are Extended Events.mp4

01:50

12 - Demo - Extended Events.mp4

08:42

13 - Summary.mp4

00:26

03 - Identify Poorly Performing Query Plan Operators

14 - Introduction.mp4

01:01

15 - What Is a Query Execution Plan.mp4

04:04

16 - Demo - Interpreting Execution Plan.mp4

07:15

17 - Slow Performing Operators.mp4

02:08

18 - Demo - Performing Operators - Scan.mp4

09:24

19 - Demo - Performing Operators - Parallelism.mp4

07:20

20 - Demo - Performing Operators - Implicit Conversation.mp4

06:06

21 - Summary.mp4

00:49

04 - Create Efficient Query Plans Using Query Store#

22 - Introduction.mp4

01:05

23 - What Is a Query Store.mp4

02:02

24 - Demo - Query Store Setup & Configuration.mp4

05:43

25 - 3 Important Query Stores.mp4

03:09

26 - Demo - Query Store Reports.mp4

08:05

27 - Demo - Resolving Parameter Sniffing with Query Store.mp4

09:35

28 - Summary.mp4

01:08

05 - Compare Estimated and Actual Query Plans and Related Metadata#

29 - Introduction.mp4

01:17

30 - What Is an Estimated Execution Plan.mp4

02:40

31 - What Is an Actual Execution Plan .mp4

01:16

32 - Demo - Estimated and Actual Execution Plan.mp4

07:26

33 - What Is Live Query Statistics.mp4

01:37

34 - Demo - Live Query Statistics.mp4

02:36

35 - Demo - Analyze Execution Plan.mp4

05:40

36 - Summary.mp4

01:15

06 - Configure Azure SQL Database Performance Insight#

37 - Introduction.mp4

01:02

38 - Query Performance Insight.mp4

03:23

39 - Demo - Query Performance Insight.mp4

08:34

40 - Going Beyond Query Plans on Azure.mp4

01:57

41 - Summary.mp4

01:00

07 - Summary

42 - Summary.mp4

02:25

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft SQL

Pinal Dave

Instructor's Courses

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 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 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.