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
What you'll learn
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.
Table of contents
- Introduction 2m
- Plan Layout 3m
- Demo: Plan Layout 3m
- Performance Issue Identification 2m
- Demo: Performance Issue Identification (Cost and Cardinality) 4m
- Demo: Performance Issue Identification (Parallelism) 3m
- Missing Index Information 1m
- Demo: Missing Index Information 5m
- Large Execution Plans 2m
- Demo: Large Execution Plans 3m
- Summary 1m
- Introduction 1m
- Plan Explorer UI Overview 2m
- Demo: UI Overview 4m
- Opening an Execution Plan 2m
- Demo: Opening an Execution Plan 4m
- Statement Tree 1m
- Demo: Statement Tree 4m
- Plan Information Region 1m
- Demo: Plan Information Region 2m
- Plan Diagram 2m
- Demo: Plan Diagram 4m
- Plan Tree 1m
- Demo: Plan Tree 3m
- Top Operations 1m
- Demo: Top Operations 2m
- Query Columns 1m
- Demo: Query Columns 3m
- Join Diagram 1m
- Demo: Join Diagram 1m
- Parameters 1m
- Demo: Parameters 2m
- Expressions 1m
- Demo: Expressions 2m
- Table I/O 1m
- Demo: Table I/O 2m
- Post to SQLPerformance.com 2m
- Demo: Posting to SQLPerformance.com 4m
- Summary 1m
- Introduction 1m
- Multiple Tabs, Single Window 1m
- Demo: Multiple Tabs, Single Window 2m
- Session History Tracking 2m
- Demo: Session History Tracking 4m
- Collecting Wait Statistics 1m
- Demo: Collecting Wait Statistics 2m
- Full Query Call Stack 1m
- Demo: Full Query Call Stack 3m
- Customizing Plan Layout 1m
- Customizing Plan Layout (2) 2m
- Customizing Plan Layout (3) 3m
- Demo: Customizing Plan Layout 6m
- Graphical Deadlock Analysis 2m
- Demo: Graphical Deadlock Analysis 5m
- Summary 2m
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. 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 Se... more