SQL SENTRY PLAN EXPLORER WHO IS SQL SENTRY

SQL SENTRY PLAN EXPLORER

WHO IS SQL SENTRY? • Developers of a suite of products to help you monitor and optimize Windows/SQL Server performance o Performance Advisor – awareness and control over Windows and SQL Server performance issues o Event Manager – Calendar, scheduling, alerting and response system o Fragmentation Manager – view and manage index fragmentation o Plan Explorer – Plan Analysis made easier! o Download a FULL evaluation @ http: //www. sqlsentry. com

PLANS AND DEMOS • Demo plans from can be obtained from: http: //bit. ly/PEDemo. Kit • Jonathan Kehayias Plan Explorer training on Pluralsight: http: //bit. ly/PETraining

PLAN LAYOUT • SSMS o Wasted space, more scrolling o Limited zooming options o Important attributes (object/index names) hidden in properties window • Plan Explorer o Optimized spacing, minimized scrolling o Dynamic zooming with Ctrl + mouse scroll wheel o Attributes fully displayed and easy-to-read

PERFORMANCE IDENTIFICATION • SSMS o Difficult to quickly find expensive operators o Useful information about potential problems hidden in tooltips o Runtime metrics not collected as part of execution plan • Plan Explorer o Provides color-highlights to quickly and easily find expensive operators o Plan Tree grid provides useful information on operators and highlights potential issues automatically o Runtime metrics collected for actual plans

MISSING INDEXES • SSMS o In a multi statement batch, missing index information is shown for each statement (which statement contains the missing index? ) • Plan Explorer o Missing index information shown for the appropriate statement o “Missing Indexes” column dynamically added to the Statement Tree for easy identification

LARGE PLANS • SSMS o Often becomes unresponsive/freezes o Becomes even more difficult to find expensive operators o Unable to view cumulative costs per branch • Plan Explorer o Optimized to handle large plans o Statement/Plan Tree/Color coding simplifies identification of expensive operators o Can show cumulative costs per branch to help identify the most expensive portion(s) of the plan

PLAN EXPLORER FREE • User friendly Interface o Command Text – contains T-SQL text for the plan o Results tab • Statement Tree – grid which simplifies navigation of multiple statements within the execution plan • Plan Information – Text Data, Plan XML • Plan Details - Plan Diagram, Parameters, Join Diagram, Plan Tree, Top Operations, Query Columns, Expressions, Table I/O o Post to SQLPerformance. com – get expert help with plan analysis! http: //answers. sqlperformance. com

PLAN EXPLORER PRO • • • All Plan Explorer Free features + … More Layout Customization Multiple tabs – open multiple plans within a single window History Tracking – track code/plan changes with comments Wait Stats – collected using Extended Events with (Actual Plan) Graphical Deadlock Analysis

IMPORTANT LINKS • Download: http: //www. sqlsentry. com • Plans used in the demo: http: //bit. ly/PEDemo. Kit • Comprehensive demo of Plan Explorer: Pluralsight • Our Community Team: community@sqlsentry. com

THANK YOU! • E-mail ebooks@sqlsentry. com for free copies of our e-books: o Just tell them where you met me