Stores statistics for all stored procedures, triggers, and compiled plans currently stored in the procedure cache.
Enable the enable monitoring and statement statistics active configuration parameters for this monitoring table to collect data.
The columns for monCacheProcedures are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
ObjectID |
int |
Unique identifier for the procedure |
|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
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 |
RequestCnt |
int4 |
Number of times this procedure was requested from cache |
|
TempdbRemapCnt |
int4 |
Number of times this procedure was remapped for the temporary database’s ID. |
|
AvgTempdbRemapTime |
int4 |
Average time (in milliseconds) spent remapping the temporary databases’s ID. |
|
ExecutionCount |
int |
Counter |
Number of times Adaptive Server executed the stored procedure plan or tree since it was cached |
CPUTime |
int |
Counter |
Total number of milliseconds of CPU time used |
ExecutionTime |
int |
Counter |
Total amount of elapsed time, in milliseconds, Adaptive Server spent executing the stored procedure plan or tree |
PhysicalReads |
int |
Counter |
Number of physical reads performed |
LogicalReads |
int |
Counter |
Number of pages read |
PhysicalWrites |
int |
Counter |
Number of physical writes performed |
PagesWritten |
int |
Counter |
Number of pages written |
