SQL Server: Using SQL Sentry Plan Explorer
Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Introduction- 5m 1s
—Introduction 2m 9s
—Setup Requirements and Installation 1m 35s
—Course Structure 1m 17sComparing Plan Explorer to SSMS- 29m 20s
—Introduction 1m 35s
—Plan Layout 2m 35s
—Demo: Plan Layout 2m 40s
—Performance Issue Identification 2m 11s
—Demo: Performance Issue Identification (Cost and Cardinality) 3m 58s
—Demo: Performance Issue Identification (Parallelism) 3m 10s
—Missing Index Information 1m 27s
—Demo: Missing Index Information 5m 25s
—Large Execution Plans 2m 29s
—Demo: Large Execution Plans 2m 35s
—Summary 1m 15sFree Edition Features- 52m 57sPlan Explorer Pro Features- 37m 34s