SQL Server: Using SQL Sentry Plan Explorer

Learn how to make the most out of the Free and Pro Editions of the popular SQL Sentry 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
Rating
(96)
Level
Intermediate
Updated
Dec 26, 2013
Duration
2h 4m
Table of contents
Introduction
Comparing Plan Explorer to SSMS
Free Edition Features
Plan Explorer Pro Features
Description
Course info
Rating
(96)
Level
Intermediate
Updated
Dec 26, 2013
Duration
2h 4m
Description

Query plan analysis is both a science and an art, and the best tool for the job is SQL Sentry Plan Explorer. In this demo-heavy course, you'll learn how to make the most of the Free and Pro Editions of the tool to make query plan analysis and performance tuning much easier and more intuitive than using SQL Server Management Studio. The course starts by comparing the Management Studio with Plan Explorer, demonstrating how Plan Explorer solves the problems and shortcomings that Management Studio has. The course then describes and demonstrates all the features of both Editions of Plan Explorer, showing how to use them to best effect using practical examples. This course is perfect for anyone who is responsible for query tuning and query plan analysis, from SQL Server 2005 onward.

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
SQL Server: Change Data Capture
Intermediate
2h 10m
Mar 27, 2015
More courses by Jonathan Kehayias
Section Introduction Transcripts
Section Introduction Transcripts

Comparing Plan Explorer to SSMS
Hi, this Jonathan Kehayias from SQLskills. com and I'm recording this using SQL Sentry Plan Explorer course for Pluralsight. This is Module 2: Comparing Plan Explorer to Management Studio. So, as I covered in the introduction module, Management Studio does provide the ability to view execution plans, and it allows us to do it in two different formats. We can view the Showplan XML and look at the actual XML format of the execution plan information, or we can open the execution plan graphically within the UI for Management Studio. However, there are a number of limitations within Management Studio that make plan analysis difficult in a lot of different scenarios. There are very few options that are available to customize how you can actually view the plan information. Plan Explorer does a good job of addressing many of the common challenges that exist in SQL Server Management Studio when you're working with graphical execution plans, and it does this by providing an optimized layout for viewing the information that exists within the plan and a number of other features that make it easier to navigate to the most expensive operator held within a large complex plan. In this module, we're going to look at the plan layout for both Management Studio and Plan Explorer, and then how we will go about doing performance issue identification in Management Studio and Plan Explorer. Then, how both of the applications show missing index information that's contained within execution plans. And finally, how large execution plans look within both of the applications.

Free Edition Features
Hi, this is Jonathan Kehayias from SQLskills. com and I'm recording this using SQL Sentry Plan Explorer course for Pluralsight. This is module three, Free Edition Features. So, within the Free Edition of Plan Explorer, there are a number of enhancements and features that aren't available inside of Management Studio for Execution Plan analysis and most of these are gonna help simplify the analysis and identification of individual problems that are occurring within your Execution Plans. Understanding the different features that are available and then how to use those various windows that are presented by Plan Explorer will make plan analysis significantly faster. In this module, what we'll take a look at is an overview of the Plan Explorer UI then how you go about opening Execution Plans, how to use the Statement Tree within the Plan Explorer UI and then how to use each of the Plan Information and Details windows that exists when a Execution Plan is open.

Plan Explorer Pro Features
Hi, this is Jonathon Kehayias with SQL skills. com and I'm recording this using SQL Sentry Plan Explorer Course on plural site. This is module 4: Plan Explorer Pro Features. So, within plan explorer pro we get all the same features that existing in the free edition plus some compelling additions for upgrading to the paid version. In this module, we'll take a look at what those paid version features are and how they can simplify managing execution plan analysis for execution plans generated by SQL server. So, in this module we'll take a look at multiple tabs within a single window and how that reduces the clutter that exists for having multiple plans open in multiple copies of Plan Explorer. The session history tracking that's available inside of plan explorer pro. Collecting waste statistics when Plan Explorer is used to collect an actual or generate an actual execution plan. How do we view full query call stacks within Plan Explorer Pro. Customizing the plan layout. And finally, how to use Plan Explorer Pro to do graphical deadlock analysis.