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

Features

Query plan graphical elements

Create and manipulate, with actual or estimated execution plans, or with individual parts of an execution plan (nodes and connectors)

See next feature

Customized operation properties

Manage property details for each operation (within statement) in an execution plan, which can be included/excluded from 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 and execute queriesy for creating the missing indexes from the graphical query execution plan view

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

Data flow line thickness

Tweak and represent high rows/data size usage with thicker lines of connector lines of varying thickness by setting preferred criteria; data size or rows count

See next feature

Layouts panel

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

See next feature

Wait times

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

See next feature

Query columns

Review all query parameters and respectivetheir 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, and allow implicit conversions within

See next feature

Query plan XML view

Display execution plans in XML format

See next feature

Multiple query tabs

Open multiple query tuning sessions in a single application instance

See next feature

Execution plan history and memos

Display history of different versions of query executions for current application tab, select records to choose which version of execution plan will be loaded, and include memos within particular version of the query

See next feature

Query performance

Get the slowest queries recently executed, by defined criteria, and collected from SQL Server including all important details

See next feature

Query store

Get and review query execution data collected from the SQL Server 2016 Query store

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 of a deadlock

See next feature

I/O reads

Get and 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

What’s new in ApexSQL Plan 2017

This blog article shows a brief look at ApexSQL Plan 2017 and its features

ApexSQL Plan 2017 – Screen shot tour

This article represents a screen shot tour of ApexSQL Plan features with a brief description

ApexSQL Microsoft®
SQL Server editions
      Express
      Standard
      Enterprise
Integration
      SQL Server Management Studio
Graphical execution plans
      Data flow line thickness
      Layouts panel
      Live query plans
      Manipulation with the query plan graphical elements
      Query execution plans
      Customized data flow properties
      Customized operation properties
      Operation cost highlight
      History chart for live query execution 2017 R2
Query execution plan analysis
      Join diagram
      Line level statements analysis
      Missing index details
      Query plan XML viewer
      Table IO
      Expressions
      Parameters
      Plan tree and top operations
      Query columns
      Wait stats
      Index analysis 2017 R2
Other
      Deadlock analysis
      Multiple query tabs
      Query performance
      Query store
      History and comments
      Export execution plans from SQL Server to disk 2017 R2
      Highlighted warnings 2017 R2
Price
Free Free

ApexSQL Plan 2017

Microsoft® SQL Server Management Studio 2016


Comparison was conducted on March 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

Highlighted query execution plan warnings

Highlight and review all query execution plan issues in one place

Index analysis

Determine the best index to support a given query

See our entire roadmap
ApexSQL Plan 2017 R1 Released ApexSQL Plan 2017 R2 Q3
Graphical execution plans
Data flow line thickness
Layouts panel
Live query plans
Manipulation with the query plan graphical elements
Query execution plans
Customized data flow properties
Customized operation properties
Operation cost highlight
History chart for live query execution
Query execution plan analysis
Join diagram
Line level statements analysis
Query plan XML viewer
Show missing index details
Table I/O
Expressions
Parameters
Plan tree and top operations
Query columns
Wait stats
Index analysis
Other
Deadlock analysis
GUI themes
Multiple query tabs
History and comments
Query performance
Query store
Support for SQL Server Management Studio 2012 integration and higher
Customizable shortcuts
Export execution plans from SQL Server to disk
Highlighted warnings
ApexSQL Plan 2017 R1 Released ApexSQL Plan 2017 R2 Q3

Sharky

See all of our other
Killer free tools

Decryption

SQL Server database object decryption

Formatting

SQL formatting and refactors

Productivity

SQL auto-complete, snippets and more

Script comparison

Compare SQL scripts and SQL Server objects

Script execution

Multi-database script execution

Search

Search SQL Server data and objects

Database lifecycle management (DLM)

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