The metrics in this category provide a list of all procedures that are being executed by processes.
Collection frequency - Every 30 minutes
Table 3-43 Running Procedures Statistics Metrics
| Metric | Description |
|---|---|
|
Compile date |
Compile date of the procedure. |
|
Stack frame |
Stack frame of the procedure. |
|
DB Name |
Name of the database that contains the procedure. |
|
Memory Usage (KB) |
Number of kilobytes of memory used by the procedure. |
|
Procedure Name |
Name of the procedure. |
|
Procedure Type |
Type of the procedure. |
|
Owner Name |
Name of the owner. |
|
Query Plan ID |
Unique identifier for the query plan. |
|
DBID |
The identifier of the database that contains the procedure. |
|
KPID |
Kernel process identifier. |
|
Object ID |
Object identifier. |
|
Owner UID |
Owner user ID. |
|
SPID |
Session process identifier. |