Show Execution Plan for Microsoft SQL Server and Oracle feature Overview

The show plan module is a part of Enterprise version of DTM DB Stress, database benchmarking utility.

This component enables the user to optimize SQL statements by execution details analyzing. A query execution plan outlines how the Microsoft SQL Server or Oracle 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 module is a useful addition for developers who deal with query performance tuning and optimization.

Key Features

• The 'Execution Plan' module adds a new section into HTML execution report.
• It shows, depends on database type: statement text, the 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 and Oracle.
• Allows to create a set of reports after each performance tuning step and compare plans.

See Also

• Performance Counters support feature.
• How a stress tool can help me?