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 execution plan

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

Live execution plan

Monitor the query execution in real-time and observe the data flow during execution

See next feature

Execution plan comparison

Compare execution plans before and after the query optimization

See next feature

Customization panel

Customize execution plan diagram layout by zooming, 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

XML view

Display execution plans in XML format

See next feature

Execution plan history comparison

Display the history of different versions of query executions for current application tab. Select records to choose which version of the actual or live 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

Open Query Store

Get and review query execution data collected from the Query Store on SQL Server versions 2008 and higher. Learn more

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. Learn more

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

Visual themes

Customize the visual appearance with interface themes. Learn more

See next feature

    Tune your SQL right within SSMS Learn more

ApexSQL Plan 2018 – Screen shot tour

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

SQL execution plan analysis tool must have’s

This article provides information about SQL Server query plans and how to use them to tune and troubleshoot slow running queries

How to identify and solve SQL Server index scan problems

This article explains how to identify 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

What’s new in ApexSQL Plan 2017 R2

This article explains new features and major improvements related Query store support and Stored procedure analysis along with other minor features.

ApexSQL Microsoft® SentryOne®
SQL Server version
      SQL Server 2005
      SQL Server 2008 - 2019 CTP 2
SQL Server editions
      Express
      Standard
      Enterprise
Cloud
      Azure SQL Database
      Amazon RDS for SQL Server
Integration
      SQL Server Management Studio
      Visual Studio
Inputs
      3rd party execution plan
      Execution plan (SQLPLAN, XML)
      SQL deadlock graph
      SQL script
Outputs
      3rd party execution plan
      Execution plan (SQLPLAN, XML)
      SQL deadlock graph 2019 R2
      SQL script
Graphical execution plans
      Customized data flow properties
      Customized operation properties
      Dashboard intervals selection
      Data flow line thickness
      Layouts customization panel
      Live execution plan
      Manipulation with the execution plan graphical elements
      Operation property (actual time elapsed)
      Operation property (actual vs estimated rows)
      Query execution plan
      Transparency for skipped operations 2019
      Operation cost highlight
Query execution plan analysis
      Execution plan comparison
      Execution plan status bar
      I/O reads
      Join graph
      Line level statements analysis
      Missing index details
      Operations
      Operations tree
      Query columns
      Query parameters
      Query performance profiling and playback through history
      Results for actual execution plan
      Save and open XML plans
      Viewing execution plans in Query store and Query performance tabs
      Wait times
      XML plan node search
      XML view
      Actual plan recosting
      Index analysis
      Statistics analysis with histogram
      Execution plan history comparison
SQL deadlock graph
      Analysis
      Layout options 2019
      Playback 2019
Monitoring
      Query performance
      Query Store
      Query Store dashboard
      Open Query Store
Other
      Active Directory – Password, Integrated and Universal with MFA authentication support 2019 R2
      Execution plan history
      Grid and execution plan nodes search
      Highlighted warnings
      Keyboard shortcuts
      Missing index creation
      Multiple query tabs
      Query text errors tab
      Recently used file list
      Wait times descriptions
      Test parameters
      Export collected grid data to HTML/XML
      Resource cost profile bars
      Stored procedure analysis
Interface
      GUI themes
      High DPI and 4K resolution support
      Host aware theme adoption
      Microsoft standard iconography, colors and other visual effects
Price
Free Free Free

ApexSQL Plan 2018.08

Microsoft® SQL Server Management Studio 18.0

SentryOne® Plan Explorer® 19.0.2


Comparison was conducted on May 09, 2019

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

Testimonials

ApexSQL Plan is brilliant and free!

Bashir Magomedov

Senior Developer Consultant

BNP Paribas

Thank you for your prompt response and resolution to my problem. As always, the support and customer service I receive from ApexSQL is excellent. It's always a pleasure to deal with everyone there.

Tim Byng

Support Manager

Mission Systems Development Corp.

I greatly appreciate your assistance. I have to say all of my experiences with ApexSQL have been great. Thank you for the wonderful customer service.

Bryan Benton

Director of Information Technology

Wiginton Corporation

Other free tools

Comparison

Script, file and folder comparison

Learn more

Decryption

Database object decryption

Learn more

Discovery

SQL Server instance discovery

Learn more

Formatting

SQL formatting and refactors

Learn more

Modeling

SQL Server database modeling

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 DevOps

Continuous integration and delivery

Learn more

© 2019 Quest Software Inc. ALL RIGHTS RESERVED.   |   1-800-306-9329   |   sales@apexsql.com   |   GDPR   |   Terms of Use   |   Privacy