monProcedureCacheModuleUsage

Description

Has 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.

Columns

Table 21-3: monProcedureCacheModuleUsage

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 booted

ModuleName

int

Name of the module

NumPagesReuse

varchar(30)

null

Number of pages allocated to this module