ApexSQL Plan

Execution plans are used in SQL Server Management Studio to graphically display the execution of queries and statements, in the attempt to provide a better understanding of the performance of a query and give optimization suggestions. Attempting to add extra functionality to the execution plan options in SSMS, ApexSQL Plan features query editing and analysis features, as well as options to review and improve actual and estimated execution plans.

Deployed both as a standalone program and a SSMS add-in, ApexSQL Plan is an additional tool for the database administrator who is looking to detect issues that affect the database query speed and work to remove such deadlocks.

The application seamlessly integrates with SQL Server Management Studio 17, 2016, 2014, or 2012, providing support for various editions of SQL Server, namely 2017 CTP 2, 2016, 2014, 2012, 2008, and 2005.

The integrated query editor features syntax highlighting and line numbering, allowing you to easily spot potential errors in the query text. Once connected to a SQL Server database, you can view suggestive graphical representations of both the actual and the estimated execution plans, comparing them to analyze performance issues.

ApexSQL Plan enables you to explore the execution plans and manage the property details for all data flows and operations in a statement.

ApexSQL Plan can build an overview of the query performance and provide the necessary tools for you to analyze waiting times for executed queries, or check the costs of all operations in the execution plan.

ApexSQL Plan allows a convenient manipulation of entire execution plans, including tools that allow the cost review and optimization. Using graphical elements, it manages to help you understand the query mechanics, when and how each operation is executed, providing a starting point in optimizing the database querying speed.