You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 
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

Features

Query plan graphical elements

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

See next feature

Customized operation properties

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

See next feature

Customized data flow properties

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

See next feature

Missing index details

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

See next feature

Operation cost highlight

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

See next feature

Element configuration

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

See next feature

Customization panel

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

See next feature

Wait times

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

See next feature

Query columns

Review all query parameters and their respective values

See next feature

Query parameters

Review all query parameters and their values

See next feature

Operations

Show simplified and expanded operations, that are used in the query

See next feature

Query plan XML view

Display execution plans in XML format

See next feature

Execution plan history comparison and memos

Display the history of different versions of query executions for current application tab. Select records to choose which version of the execution plan needs to be compared, and include memos within a particular version of the query

See next feature

Query performance

Get the slowest queries recently executed, by defined criteria, including all key details

See next feature

Extended Query store

Get and review query execution data collected from the Query store on SQL Server versions 2008 and higher

See next feature

Query store dashboard

Quickly review top queries based on average duration, execution count, executed rows etc. Easily drill down to review query details and export desired diagrams

See next feature

Join graph

Graphically display relationships between database tables involved in the execution plan

See next feature

Deadlock analysis

Analyze deadlock diagrams to identify the cause

See next feature

Stored procedure analysis

Analyze stored procedure profiling information and review parameter summary, details and history

See next feature

Lazy profiling

Generate lazy profiling reports of selected stored procedures

See next feature

I/O reads

Review the number of logical reads including LOB, physical reads (including read-ahead and LOB), and how many times a database table was scanned

See next feature

An introduction to ApexSQL Plan

This video is a brief introduction to ApexSQL Plan – a tool used for execution plan viewing and SQL query optimization

How to identify and solve SQL Server index scan problems

This article expalins how to indentify SQL Server index scan problems and what strategies to use in order to resolve them

SQL query performance tuning with I/O statistics and execution plans

This article explains how to do performance tuning with I/O statistics and execution plans using ApexSQL Plan a SQL Server execution plan viewer and query optimization tool

ApexSQL SentryOneTM Microsoft®
SQL Server editions
      Express
      Standard
      Enterprise
Integration
      SQL Server Management Studio
Graphical execution plans
      Customized data flow properties
      Customized operation properties
      Data flow line thickness
      History chart for live query execution
      Layouts panel
      Live query plans
      Manipulation with the query plan graphical elements
      Operation cost highlight
      Query execution plans
      Visual interface themes
Query execution plan analysis
      Expressions
      Execution plan comparison
      History statistics comparison
      Join diagram
      Line level statements analysis
      Missing index details
      Parameters
      Plan tree and top operations
      Query columns
      Query plan XML viewer
      Save and open XML plans
      Showplan node search
      Table IO
      Wait stats
      Correcting bad cardinality estimation in execution plan
      Index analysis
      Statistics analysis with histogram
Other
      Deadlock analysis
      History and comments
      Multiple query tabs
      Query performance
      Query Store
      Customizable keyboard shortcuts
      Export execution plans from SQL Server to disk
      Highlighted warnings
      Open Query Store support
      Query Store dashboard
      Resource cost profile bars
      Stored procedure analysis
Price
Free Free Free

ApexSQL Plan 2017.01

SentryOne® Plan ExplorerTM 3.0

Microsoft® SQL Server Management Studio 17.2


Comparison was conducted on July 20, 2017

Disclaimer: All product and company names are trademarks or registered® trademarks of their respective holders.
ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliates

Roadmap

History chart for live query execution

See exactly how a query and its expensive operators are impacting CPU, I/O, and waits with integrated history charts

Execution plan comparison

Compare execution plans side by side and review differences

Customizable keyboard shortcuts

Add or remove keyboard shortcuts for commands or frequently used actions

See our entire roadmap
ApexSQL Plan 2017 R1 Released ApexSQL Plan 2017 R2 Released ApexSQL Plan 2018 R1 Released ApexSQL Plan 2018 R2 Q2
Graphical execution plans
Customized data flow properties
Customized operation properties
Data flow line thickness
Layouts panel
Live query plans
Manipulation with the query plan graphical elements
Operation cost highlight
Query execution plans
History chart for live query execution
Dashboard intervals selection
Query execution plan analysis
Expressions
Join diagram
Line level statements analysis
Parameters
Plan tree and top operations
Query columns
Query plan XML viewer
Show missing index details
Table I/O
Wait stats
History statistics comparison
Save and open XML plans
SQL Server execution plan comparison
SQL Server execution plan status bar
Results for SQL Server actual execution plan
Viewing execution plans in Query store and Query performance tabs
Other
Deadlock analysis
GUI themes
History and comments
Multiple query tabs
Query performance
Query Store
Support for SQL Server Management Studio 2012 integration and higher
Open Query Store support
Query store dashboard
Resource cost profile bars
Stored procedure analysis
Highlighted warnings
SQL Server 2017 execution plan full support
Grid and execution plan nodes search option
Keyboard shortcuts
Missing index creation
Query text errors tab
Recently used file list
Wait times descriptions
ApexSQL Plan 2017 R1 Released ApexSQL Plan 2017 R2 Released ApexSQL Plan 2018 R1 Released ApexSQL Plan 2018 R2 Q2

Other free tools

Comparison

Script, file and folder comparison

Learn more

Decryption

Database object decryption

Learn more

Formatting

SQL formatting and refactors

Learn more

Productivity

Improved SQL coding and productivity

Learn more

Propagation

Multi-database script execution

Learn more

Search

SQL text and object search

Learn more

Database lifecycle management (DLM)

SQL Server continuous integration (CI) and delivery (CD)

Learn more