Memory

<< Click to Display Table of Contents >>

Navigation:  Index Size >

Memory

The Memory tab shows size of indexes stored in RAM.

 

Note Allocated and Used columns size is in KB

 

 

inmemorysize

 

 

Column

Description

Memory Consumer Type

VARHEAP - Database heap. Allocate users data for database (rows)

HASH- Hash index.

DB page pool- Database page pool for runtime operations. eg. table variables. There is 1 memory consumer per database

Memory Consumer Description

Description of memory consumer type.

Allocation Count

Number of Allocations

Allocated

Allocated memory by consumer, size in KB.

Used

Used KB by consumer (only for varheap)