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