monProcedureCacheMemoryUsage

Description

Has one row for each procedure cache allocator. An allocator is identified by an allocator ID, which is internal to Adaptive Server.

Columns

Table 21-2: monProcedureCacheMemoryUsage

Name

Datatype

Attributes

Description

Allocator ID

int

An allocator ID

ModuleID

int

A module ID (internal to Adaptive Server)

Active

int

Number of memory pages (2KB) currently allocated to this allocator

HWM

int

The maximum number of memory pages allocated since the server was started

ChunkHWM

int

The largest number of contiguous memory pages allocated since the server was started

AllocatorName

varchar(30)

Name of the allocator

NumReuseCaused

int

null

Number of times this allocator has caused replacement