ApexSQL Plan

Note: Email Delivery only

Execution plan viewing and query optimization
Review actual or estimated execution plans, analyze and optimize SQL queries

Compare
SKU: ApexSQL Plan Categories: , ,

Description

* Analyze and optimize SQL query execution plans
* Identify query performance issues and deadlocks
* Understand query performance characteristics
* Analyze query waits & review query execution plans
* Customize graphical query execution plan view
* See the actual relative cost of each plan operator
* Analyze query live performance statistics
* Compare estimated and actual query execution plans
* Profile stored procedure performance
* Generate lazy profiling reports

Query plan graphical elements

Create full execution plan diagrams that can be resized, rescaled and otherwise manipulated. Configure sub-elements like nodes and connectors

fancy

Customized operation properties

Manage property details for each operation in an execution plan, which can be included/excluded via tooltips

fancy

Customized data flow properties

Manage details for each data flow in an execution plan, and review them directly in the tooltip

fancy

Missing index details

Determine missing indexes and create queries for (re)creating them from the tooltip in the execution plan section

fancy

Operation cost highlight

Review the highest cost operations within the execution plan, and highlight them by CPU, I/O or show the total cost

fancy

Element configuration

Represent high rows/data size usage with connector lines of varying thickness, data size or rows count

fancy

Customization panel

Customize execution plan diagram layout by zooming, filtering, stretching, flattening, setting layout modes and link styles and rotating

fancy

Wait times

Analyze waits for executed queries, with a collection of all wait statistics, with correct wait and signal tim

fancy

 

Query columns

Review all query parameters and their respective values

fancy