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
(89)
Level
Intermediate
Updated
December 26, 2013
Duration
2h 4m
Table of contents
Introduction
5m 1s
Description
Course info
Rating
(89)
Level
Intermediate
Updated
December 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
27 Mar 2015
SQL Server: Maintenance Plans
Beginner
2h 39m
22 Nov 2013
More courses by Jonathan Kehayias