The SQL History sub-page consists of two radio buttons (SQL Text and SQL Performance), each of which displays a grid. The data displayed on these grids is based on the process selected in the User Activity grid.
This grid shows details of active SQL statements.
The following table defines the fields on this grid:
|
Field |
Definition |
|
Start Time |
Time the SQL statement started |
|
DB Name |
Database name associated with the SQL statement |
|
SQL Text |
First line of SQL statement text |
This grid details the performance attributes of SQL statements that have run for accounts that are currently logged in.
The SQL statements shown are for the process selected in the User Activity grid.
The following table defines the columns on this grid:
|
Field |
Definition |
|
Run Time (sec) |
Duration of SQL statement run time |
|
Log Reads |
Number of logical reads |
|
Phys Reads |
Number of physical reads performed by the SQL statement |
|
Pgs Mod |
Number of pages modified by the SQL statement |
|
Mem Use (KB) |
Amount of memory used by the SQL statement (in kilobytes) |
|
Wait Time |
Amount of time the process waited for Adaptive Server resources to become available |
|
SQL Text |
First line of SQL statement text |
Note: Selecting a line on this grid displays the full text of the selected SQL Statement in the SQL Formatter text box on the bottom left.
If the current SQL statement indicates the execution of a stored procedure, the contents of the procedure will display in the SQL Formatter text box on the bottom right.
Select a SQL Text line from either the SQL Text grid or the SQL Performance grid.
Right-click on the line you selected, and then select "Launch SQL Tuning..." from the menu displayed.
Note: When you launch SQL Tuning, it connects to the database you're currently in, and the SQL Statement is loaded. You can then use SQL Tuning features.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
