The SQL Activity Page consists of a grid and a text box below the grid.
The SQL Activity grid is displayed when you select the SQL Activity Page on the Process Activity tab of the User Activity drilldown.
This grid shows the performance history of SQL statements that have run for accounts that are currently logged in.
Note: Only SQL Text is available for pre-12.5.03 servers.
The following columns are available:
|
Column |
Definition |
|
User Name |
Name of User who executed the SQL statement |
|
DB Name |
Database name associated with the SQL statement |
|
Start Time |
Time the SQL statement started |
|
Run Time (sec) |
Duration of SQL statement run time |
|
Log Reads |
Number of logical reads performed by the SQL statement |
|
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 (ms) |
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.
Note: SQL statements will not be shown for users who have logged off Adaptive Server before Spotlight connected. In addition, SQL statements for system processes will not be shown.
Select a SQL Text line on the SQL Activity grid.
Right-click anywhere on the SQL Activity grid, 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. Feedback Terms of Use Privacy Cookie Preference Center
