SQL Server: Using SentryOne Plan Explorer

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.
Course info
Level
Intermediate
Updated
Nov 18, 2019
Duration
2h 44m
Table of contents
Course Overview
Introduction
Comparing Plan Explorer to SSMS
Using the Plan Explorer UI
Getting Execution Plans to Plan Explorer
Using Index and Statistics Analysis
Profiling Query Performance
Description
Course info
Level
Intermediate
Updated
Nov 18, 2019
Duration
2h 44m
Description

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.

About the author
About the author

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.

More from the author
More courses by Jonathan Kehayias
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hello, My name is Jonathan Coe Hias and welcome to my course sequel server using Century One Plant Explorer. I'm a sequel server consultant with sequel skills dot com and I've been working with Sequel Server since Version 65 have been fortunate enough to work in various industries as both the sequel, server developer and a database administrator prior to becoming a consultant and enjoy sharing my knowledge around the world in different conferences, events in person, training courses and online through Twitter in various forms. As a part of my work, I've often had to review execution plants for sequel queries, toe identify potential performance issues and optimization sze to queries and database schemers. And one of the tools that I've used daily over the last eight years for this has been Century one. Plant Explorer. This course will begin with an introduction to what Century One Plane Explorer is and why you might use it over sequel server management studio. Then we'll look at how to collect execution plans from sequel server and some of the differences and estimated in actual execution plans how to use plan, explore to capture statistics, profile information and store multiple executions in a Plan Explorer session format, and we'll compare the plan, layout, options and differences between management studio and Plant Explorer and focus specifically on the features of Plant Explorer that assist with rapid identification of performance issues. This course will demonstrate all of the new features in Century One Plant Explorer to include the index analysis and statistics. Sister Graham layout the live performance statistics playback and deadlock playback features. There will be demos along the way to show you how to become more efficient execution plan, analysis and where to find information fast. You can also download Sentry One Plane Explorer and follow along using your own execution plans to maybe find an interesting new nugget or two. I hope you'll join me as we explore sensual and plain explorer in this course.