Buffer allocator

The buffer allocator manages buffer pinning quotas for (temporary) data structures. sp_iqsysmon generates main (Table A-11) and temporary (Table A-12) statistics. Statistic names are sorted alphabetically.

Table A-11: Buffer allocator main statistics

BM

BTree

BufAllocAvailBufs

BufAllocAvailPF

BufAllocMaxBufs

BufAllocMutexLocks

BufAllocMutexWaits

BufAllocNPFUsers

BufAllocNPinUsers

BufAllocNPostedUsrs

BufAllocNPostEst

BufAllocNUnPostEst

BufAllocNUnpostUsrs

BufAllocPinQuota

BufAllocReserved

BufAllocSlots

BV

ClientCountOfPinners

DBCC

FP

Garray

Hash

LOB

NActiveCommands

NumClients

PfUserRegisters

PinUserQuota

PinUserRegisters

PrefetchUserQuota

Row

RowColumn

Sort

Store

Table A-12: Buffer allocator temporary statistics

BM

BTree

BufAllocAvailBufs

BufAllocAvailPF

BufAllocMaxBufs

BufAllocMutexLocks

BufAllocMutexWaits

BufAllocNPFUsers

BufAllocNPinUsers

BufAllocNPostedUsrs

BufAllocNPostEst

BufAllocNUnPostEst

BufAllocNUnpostUsrs

BufAllocPinQuota

BufAllocReserved

BufAllocSlots

BV

ClientCountOfPinners

DBCC

FP

Garray

Hash

LOB

NActiveCommands

NumClients

PfUserRegisters

PinUserQuota

PinUserRegisters

PrefetchUserQuota

Row

RowColumn

Sort

Store