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. |