Get the Execution Plan for a SQL Server Query

A new macro has been added in Visual Expert 2019 to fetch a detailed view of the query execution process within SQL Server. This way, it won't be necessary to go back to your SQL Server management studio to review its execution plan.

  • The macro - ‘Execution Plan’ is now available under the ‘Performance’ section in the navigation bar, after selecting Select, Insert, Delete, Alter and Update statements in the treeview.

  • SQL Query query execution plan option from the Visual Expert navigation bar

  • You can also access this option from the ribbon menu in the ‘Performance’ Tab.

    View the execution plan of an SQL Server query from the Performance tab of Visual Expert

  • Visual Expert lists hierarchically the operations of the T-SQL query along with the time taken by each of them in milliseconds.


Examples of ‘Execution Plan’ results for Transact-SQL query statements below:

  1. Select statement

  2. Plan for executing an SQL Server query for Select statement

  3. Insert Statement

  4. Plan for executing an SQL Server query for Insert statement

  5. Update Statement

  6. Plan for executing an SQL Server query for Update statement


Pre-requisites:

  1. Your VE project should read database code via a database connection
    (as opposed to reading DB code from files),
  2. Activate VE performance monitoring,
  3. Wait for your database to execute SQL queries and log some execution statistics.

 

Visual Expert 2019, SQL Server, Execution Plan