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.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
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 |
|
ModuleName |
int |
Name of the module |
|
NumPagesReuse |
varchar(30) |
Null |
Number of pages allocated to this module |
