The metrics in this category provide statistics for all procedures currently stored in the procedure cache.
For every collection, only the top 10 rows sorted on Memory Usage are selected.
Collection frequency - Every 30 minutes
Table 3-6 Cached Procedures Statistics Metrics
| Metric | Description |
|---|---|
|
Procedure Compiled Date |
Date that the procedure was compiled. |
|
DB Name |
Name of the database. |
|
Memory Usage (KB) |
Number of kilobytes of memory used by the procedure. |
|
Procedure Name |
Name of the object. |
|
Procedure Type |
The type of procedure (stored procedure, trigger, and so on). |
|
Owner Name |
Name of the object owner. |
|
Procedure ID |
Unique identifier for the procedure. |
|
Owner UID |
Owner user ID. |
|
DBID |
Database identifier. |
|
Query Plan ID |
Unique identifier for the query plan. |