The metrics in this category provide information for currently executing statements.
Table 3-9 Currently Executing Queries Metrics
| Metric | Description |
|---|---|
|
Procedure stack frame ID |
Stack frame of the procedure, if a procedure. |
|
CPU Usage (ms) by Query |
Number of milliseconds of CPU used by the statement. |
|
Line number of the statement in SQL batch |
Line number of the statement in SQL batch. |
|
Number of buffers read from cache |
Number of buffers read from cache. |
|
Procedure Memory Usage (KB) |
Number of kilobytes of memory used for execution of the statement. |
|
Network packets size (bytes) |
Size (in bytes) of the network packet currently configured for the session. |
|
Number of network packets received by Adaptive Server |
Number of network packets received by Adaptive Server. |
|
Number of network packets sent by Adaptive Server |
Number of network packets sent by Adaptive Server. |
|
Number of pages modified by the statement |
Number of pages modified by the statement. |
|
Number of buffers read from disk |
Number of buffers read from disk. |
|
Stored plan ID |
Unique identifier for the stored plan for the procedure. |
|
Number of altered plans |
The number of plans altered at execution time. |
|
Procedure ID |
Unique identifier for the procedure. |
|
Execution start time |
Date when the statement began execution. |
|
Total Waited time during execution (ms) |
Number of milliseconds the task has waited during execution of the statement. |
|
SPID |
Session process identifier. |
|
KPID |
Kernel process identifier. |
|
DBID |
Database identifier. |
|
Batch ID |
Batch identifier. |
|
Key Value |
Unique identifier for the current executing query. |