Operations

XML view

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

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

ApexSQL

Microsoft®

SentryOneTM

SQL Server editions

Express

Standard

Enterprise

Integration

SQL Server Management Studio

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

Query execution plan

Visual interface themes

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

Results for actual execution plan

Save and open XML plans

Showplan node search

Viewing execution plans in Query store and Query performance tabs

Wait times

XML View

Actual Plan Recosting

Index analysis

Statistics analysis with histogram

Execution plan history comparison

Other

Deadlock analysis

Execution plan history

Grid and execution plan nodes search option

Highlighted warnings

Keyboard shortcuts

Missing index creation

Multiple query tabs

Query performance

Query Store

Query Store dashboard

Query text errors tab

Recently used file list

Wait times descriptions

Test Parameters

Open Query Store

Resource cost profile bars

Stored procedure analysis

Price

Free

Free

Free

ApexSQL Plan 2018.02

Microsoft® SQL Server Management Studio 17.4

SentryOne® Plan Explorer 3.0

Comparison was conducted on March 08, 2018

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