SQL Server: Using SentryOne Plan Explorer
Course info
Course info
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
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
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.