Show Execution Plan Plug-in for Microsoft SQL Server Overview

The plug-in is optional component of the DTM DB Stress, database stress utility. Only Professional and Enterprise versions support Plug-ins.

This component enables user to optimize SQL statements by execution details analyzing. A query execution plan outlines how the Microsoft SQL Server query optimizer actually ran task's statement. This information is valuable when it comes time to find out why a specific SQL statement is running slow. The plugin is must have addition for developers who deal with query perfromance tuning and optimization.

Key Plug-in Features

• The plug-in adds new part into HTML execution report.
• Plug-in shows: statement text, physical and logical operation for each execution stage, estimations for row numbers, input/output operations and server's CPU usage.
• Supports all modern versions of the Microsoft SQL Server.
• Allows to create a set of reports after each performance tuning step and compare plans.

The plug-in can be ordered separately as well as with Enterprise edition of the db stress tool.

See also

• Performance Counters Plug-in.
• How a stress tool can help me?