The SQL Statements page lists all the SQL statements within the trace file selected in the Trace Files Page.
To open the SQL Statements page
Click SQL & Application Workload | Analyze Trace | Trace Files.
Select a Trace File.
If the trace file has not been analyzed yet, right-click its row in the Trace File Details table and select Analyze Trace File. Analyze Trace Settings Dialog
Click SQL Statements
SQL Statements Grid
Click a row to open SQL Statement Information.
Double-click the row to open the SQL Statement Details Page for the statement.
Note: Not all columns are visible by default. Use the Column Organizer to view hidden columns. Show, Hide & Order Columns
Column | Description |
---|---|
SQL ID |
The number allocated to the specified SQL statement within the trace file. |
Elapsed (ms) |
The total server execution time for the SQL statement (parse, execute and fetch). |
CPU (ms) |
The CPU time spent executing the SQL statement. |
Fetch Count |
The number of fetches performed for the SQL statement. |
Parse Count |
The number of parses performed for the SQL statement. |
Logical IO |
The number of logical I/O operations for the SQL statement. |
Total Rows |
The total number of rows processed for the SQL statement. |
Disk IO |
The number of disk I/O operations for the SQL statement. |
Execute Count |
The number of times the SQL statement was executed. |
% Total Elapsed |
The percentage of the total elapsed time spent executing the SQL statement. |
Logical IO/Exec |
The average number of logical I/O operations performed each time the SQL statement was executed. |
Logical IO/Row |
The average number of logical I/O operations performed for each row processed by the SQL statement. |
CPU/Exec |
The average number of CPU operations performed each time the SQL statement was executed. |
Disk/Exec |
The average number of disk I/O operations performed each time the SQL statement was executed. |
SQL Statement |
The text of the SQL statement. |
Address |
The address where data has been returned by the SQL statement. |
Formatted SQL |
The text of the SQL statement formatted for readability. |
Hash Value |
The hash value for the SQL statement in the library cache. |
SQL Statement Information shows the following information about the selected SQL statement. More information on the selected SQL statement is available from the SQL Statement Details Page.
Section |
Description |
---|---|
SQL Text | The full text of the selected SQL statement. |
SQL Statistics |
The SQL Statistics table displays statistical information about the selected SQL statement.
|
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center