Includes one row for each module that allocates memory from procedure cache. A module, which is identified with a module ID, is a functional area classification internal to Adaptive Server procedure cache management.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monProcedureCacheModuleUsage are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
InstanceID |
tinyint |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
ModuleID |
int |
A module ID |
|
Active |
int |
Number of memory pages (2KB) currently allocated to this module |
|
HWM |
int |
The maximum number of memory pages allocated since the server was started |
|
NumPagesReused |
int |
Null |
Number of pages allocated to this module |
ModuleName |
varchar(30) |
Name of the module |
