Provides statistics for all procedures currently stored in the procedure cache. monCachedProcedures does not require any configuration parameters.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
ObjectID |
int |
Unique identifier for the procedure |
|
OwnerUID |
int |
Unique identifier for the database owner |
|
DBID |
int |
Unique identifier for the database |
|
PlanID |
int |
Unique identifier for the query plan |
|
MemUsageKB |
int |
Number of kilobytes of memory used by the procedure |
|
CompileDate |
datetime |
Date that the procedure was compiled |
|
ObjectName |
varchar(30) |
null |
Name of the procedure |
ObjectType |
varchar(32) |
null |
The type of procedure (stored procedure, trigger, and so on) |
OwnerName |
varchar(30) |
null |
Number of the object owner |
DBName |
varchar(30) |
null |
Name of the database |
