Current executing statements
Comments
Commands to ASE are submitted as batches, such as several SQL statements in a script (if you are using isql, for example, then anything
before the go command is grouped together as a batch).
ASE executes individual statements in the batch. Individual statements can be anything from large SQL
to just if conditions.
This view provides two ways of looking at what is executing: by statement (the lowest level) and by batch (the high level).
By Statements - Columns
| Name |
Description |
| Inst ID |
Instance ID; 0 = non-CE |
| SPID |
Session process ID |
| Elapsed Time |
Elapsed time |
| CPU % (one engine) |
CPU % Used (1 CPU) |
| SQL Text |
SQL text preview |
| Database |
Database name |
| Start Time |
Start time of statement |
| Line # |
Line number in the batch |
| CPU Time |
CPU time |
| Wait Time |
Wait time |
| Memory |
Memory usage |
| Physical Reads |
Number of physical reads |
| Logical Reads |
Number of logical reads |
| Packets Sent |
Number of network packets sent |
| Bytes Sent |
Network bytes sent |
| Packets Received |
Number of network packets received |
| Bytes Received |
Network bytes received |
| Procedure |
Procedure name, if applicable |
| Login |
User login name |
| SQLID |
SQL ID; created by Surveillance |
| Batch ID |
Batch ID |
| KPID |
Kernel process ID |
By Batches - Columns
| Name |
Description |
| Inst ID |
Instance ID; 0 = non-CE |
| SPID |
Session process ID |
| Batch ID |
Batch ID |
| Elapsed Time |
Elapsed time of the batch |
| Start Time |
Start time of the batch |
| Cur Line # |
Line number in the batch |
| Cur Proc DB |
Database name of the current procedure, if applicable |
| Cur Procedure |
Name of the current procedure, if applicable |
| Cur Temp DB |
TempDB name |
| KPID |
Kernel process ID |
SQL Plan Details - Columns
| Name |
Description |
| ID |
ID of this node in the plan |
| Parent ID |
ID of parent of this node in the plan; 0 = this node is the root node in the plan |
| Operation |
Name of operation for this node |
| Options |
Options for the operation for this node |
| Object |
Target object of this operation |
| Object2 |
Second target object of this operation |
| IO Size Data Pages |
I/O size used for data pages for this node |
| BRS Data Pages |
Buffer Replacement Strategy used for data pages for this node |
| IO Size Index Leaf Pages |
I/O size used for index leaf pages for this node |
| BRS Index Leaves |
Buffer Replacement Strategy used for index leaf pages for this node |
Procedure Stack - Columns
| Name |
Description |
| Inst ID |
Instance ID; 0 = non-CE |
| SPID |
Session process ID |
| Context ID |
Current context ID of the procedure |
| Stmt # |
Current statement number (unique in a batch) of the procedure |
| Type |
Type of procedure (stored procedure, etc.) in the stack |
| Object |
Name of the procedure in the stack |
| Line # |
Current line number of the procedure |
| Compile Time |
Compile date of the procedure |
| Owner |
Name of the owner of the procedure |
| Database |
Name of the database that contains the procedure |
| Memory |
Memory usage |
Entity Requirements
| Attributes: |
MDA |
| Minimum database version: |
12.5.0.3 |