SQL Server: Using SentryOne Plan Explorer

Focused View

Jonathan Kehayias

2:43:12

30 View

01 - Course Overview

01 - Course Overview.mp4

02:06

02 - Introduction

02 - Introduction and Why Use Plan Explorer.mp4

02:17

03 - Course Objective - Collecting Plans.mp4

01:10

04 - Course Objective - Comparing Plan Explorer to SSMS.mp4

01:22

05 - Course Objective - Plan Explorer UI.mp4

02:15

06 - Course Objective - Getting Plans to Plan Explorer.mp4

02:31

07 - Course Objective - Index Analysis.mp4

02:20

08 - Course Objective - Query Performance Profiling Recorder.mp4

01:30

09 - Course Structure and Module Summary.mp4

01:02

03 - Comparing Plan Explorer to SSMS

10 - Introduction.mp4

01:35

11 - Historical Problems Viewing Plans in Management Studio.mp4

03:53

12 - Demo - Plan Layout Differences.mp4

04:40

13 - Performance Issue Identification.mp4

03:14

14 - Demo - Performance Issue Identification Differences.mp4

06:33

15 - Missing Index Information.mp4

01:37

16 - Demo - Missing Index Information.mp4

03:21

17 - Large Execution Plans.mp4

04:27

18 - Demo - Large Execution Plans.mp4

05:13

19 - Demo - Operator Cost Fixes.mp4

02:13

20 - Demo - Scalar UDF Usage Highlighting.mp4

02:26

21 - Module Summary.mp4

01:04

04 - Using the Plan Explorer UI

22 - Introduction.mp4

02:23

23 - Plan Explorer UI Overview.mp4

02:53

24 - Demo - Results Tab Information.mp4

02:11

25 - Statement Tree.mp4

02:12

26 - Demo - Statement Tree.mp4

02:23

27 - Plan Information Region.mp4

01:56

28 - Demo - Plan Information Tabs.mp4

01:25

29 - Plan Diagram.mp4

04:55

30 - Demo - Plan Diagram.mp4

02:18

31 - Plan Tree.mp4

02:37

32 - Demo - Plan Tree Information.mp4

03:07

33 - Top Operations.mp4

01:29

34 - Demo - Top Operations.mp4

03:12

35 - Query Columns.mp4

02:25

36 - Demo - Query Columns.mp4

02:50

37 - Additional Tabs.mp4

03:32

38 - Demo - Additional Tabs.mp4

02:42

39 - Table I O.mp4

01:10

40 - Demo - Table I O.mp4

01:47

41 - Plan Anonymization.mp4

01:55

42 - Demo - Plan Anonymization.mp4

02:46

43 - Demo - Deadlock Analysis and Playback.mp4

02:31

44 - Module Summary.mp4

01:21

05 - Getting Execution Plans to Plan Explorer

45 - Introduction.mp4

01:57

46 - Opening Execution Plans.mp4

02:57

47 - Demo - Opening Execution Plans.mp4

01:46

48 - Transferring Plans from Management Studio.mp4

02:56

49 - Demo - Transferring Plans from Management Studio.mp4

02:22

50 - Generating a Plan from a Statement within Plan Explorer.mp4

02:55

51 - Demo - Generating a Plan from a Statement within Plan Explorer.mp4

02:07

52 - Module Summary.mp4

01:00

06 - Using Index and Statistics Analysis

53 - Introduction.mp4

01:12

54 - Demo - Introduction to the Index Analysis tab.mp4

03:39

55 - Demo - What-if Analysis of Index Changes and Benefits.mp4

05:26

56 - Demo - Using the Statistics Histogram to Find Potential Problems.mp4

06:48

57 - Demo - Updating Statistics and Parameter Values to Test Plan Changes.mp4

02:48

58 - Module Summary.mp4

01:27

07 - Profiling Query Performance

59 - Introduction.mp4

01:08

60 - Demo - Configuring Plan Explorer to Capture Live Performance Statistics .mp4

01:44

61 - Demo - Playing Back Live Query Profile Statistics.mp4

03:51

62 - Demo - Using Live Query Statistics to Understand Stop-and-Go Operators.mp4

02:32

63 - Module and Course Summaries.mp4

01:48

Description

Learn how to make the most out of the popular and free SentryOne Plan Explorer tool, applicable to anyone responsible for SQL Server performance tuning and query plan analysis, with any level of SQL Server experience.

What You'll Learn?

Query plan analysis is both a science and an art, and the best tool for the job is SentryOne Plan Explorer. In this course, SQL Server: Using SentryOne Plan Explorer, you will learn how to make the most of the tool to make query plan analysis and performance tuning much easier and more intuitive than using SQL Server Management Studio. First, you will gain an understanding of how Plan Explorer compares to Management Studio, demonstrating how Plan Explorer solves the problems and shortcomings that Management Studio has. Next, you will discover how to use the the Plan Explorer user interface, including how the various information displays can help with performance analysis and tuning, and the various methods for getting query plans into the tool. Finally, you will explore how to use the more advanced features of the tool like index and statistics analysis, and profiling query performance using live query statistics. When you are finished with this course, you will have the skills and knowledge to start using the powerful SentryOne Plan Explorer tool to greatly improve your query plan analysis and performance tuning capabilities.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Database Programming

Microsoft SQL

Jonathan Kehayias

Instructor's Courses

Jonathan Kehayias is a Principal Consultant with SQLskills. He is the youngest person ever to achieve the Microsoft Certified Master - SQL Server 2008 certification and has been a SQL Server MVP for many years. Jonathan is heavily involved in the SQL community; including being the top answerer on the MSDN Database Engine forum, writing deep technical content on his blog (plus his old blog, and answering questions as @SQLPoolBoy on Twitter. Jonathan is a performance tuning expert, both SQL Server and hardware, and has architected complex systems as a developer, business analyst, and DBA. This breadth of role experience, along with extensive development (T-SQL, C#, and ASP.Net), hardware and virtualization design expertise, Windows expertise, Active Directory experience, IIS administration, and other component knowledge makes Jonathan an incredible addition to our team. He has also presented at multiple conferences including PASS, SQLBits, and VMware Open Forum, and SQL Connections. Jonathan was ranked fourth overall from presenters at the first ever PASS SQL Rally in Spring 2011. In addition Jonathan teaches part of the SQLskills Immersion Events on Performance Tuning and on High Availability, as well as the SQL Server portion of the Microsoft Certified Master - SharePoint certification for Microsoft.

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.