2013
Pluralsight
Jonathan Kehayias
2h 4m
English

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.

01. Introduction
01. Introduction.wmv
02. Setup Requirements and Installation.wmv
03. Course Structure.wmv

02. Comparing Plan Explorer to SSMS
01. Introduction.wmv
02. Plan Layout.wmv
03. Demo Plan Layout.wmv
04. Performance Issue Identification.wmv
05. Demo Performance Issue Identification (Cost and Cardinality).wmv
06. Demo Performance Issue Identification (Parallelism).wmv
07. Missing Index Information.wmv
08. Demo Missing Index Information.wmv
09. Large Execution Plans.wmv
10. Demo Large Execution Plans.wmv
11. Summary.wmv

03. Free Edition Features
01. Introduction.wmv
02. Plan Explorer UI Overview.wmv
03. Demo UI Overview.wmv
04. Opening an Execution Plan.wmv
05. Demo Opening an Execution Plan.wmv
06. Statement Tree.wmv
07. Demo Statement Tree.wmv
08. Plan Information Region.wmv
09. Demo Plan Information Region.wmv
10. Plan Diagram.wmv
11. Demo Plan Diagram.wmv
12. Plan Tree.wmv
13. Demo Plan Tree.wmv
14. Top Operations.wmv
15. Demo Top Operations.wmv
16. Query Columns.wmv
17. Demo Query Columns.wmv
18. Join Diagram.wmv
19. Demo Join Diagram.wmv
20. Parameters.wmv
21. Demo Parameters.wmv
22. Expressions.wmv
23. Demo Expressions.wmv
24. Table I O.wmv
25. Demo Table I O.wmv
26. Post to SQLPerformance.com.wmv
27. Demo Posting to SQLPerformance.com.wmv
28. Summary.wmv

04. Plan Explorer Pro Features
01. Introduction.wmv
02. Multiple Tabs, Single Window.wmv
03. Demo Multiple Tabs, Single Window.wmv
04. Session History Tracking.wmv
05. Demo Session History Tracking.wmv
06. Collecting Wait Statistics.wmv
07. Demo Collecting Wait Statistics.wmv
08. Full Query Call Stack.wmv
09. Demo Full Query Call Stack.wmv
10. Customizing Plan Layout.wmv
11. Customizing Plan Layout (2).wmv
12. Customizing Plan Layout (3).wmv
13. Demo Customizing Plan Layout.wmv
14. Graphical Deadlock Analysis.wmv
15. Demo Graphical Deadlock Analysis.wmv
16. Summary.wmv

http://pluralsight.com/

Download File Size:396.7 MB

---