Stores statistics for all stored procedures, triggers, and compiled plans currently stored in the procedure cache.
Enable the per object statistics active configuration
parameter for this monitoring table to collect data.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
ObjectID |
int |
Unique identifier for the procedure |
|
OwnerUID |
int |
Unique identifier for the object’s owner |
|
DBID |
int |
Unique identifier for the database in which the object exists |
|
PlanID |
int |
Unique identifier for the query plan for the object in the procedure cache |
|
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 |
Type of procedure (for example, stored procedure or trigger) |
OwnerName |
varchar(30) |
Null |
Name of the object owner |
DBName |
varchar(30) |
Null |
Name of the database |
