Slowest SQL Statements Report
Use this report to identify the slowest SQL statements that have been run on the current database server.
Prerequisite: SQL
tracing must be on to collect the information for this report. On
the page,
set the Trace State option to On.
For each SQL statement, the report displays a visual depiction of the query execution plan, information about the statement, the complete statement, and detailed statement statistics.
The reports of current data contain all the information available. The reports of the historical data contain the information available in the specified the date range.
The information in this report is also available on the page. Drill down on an SQL statement type to information about a specific SQL statement execution by repeatedly clicking the details icon.