Buffer pool

The buffer pool manages in-memory buffers for the buffer cache. sp_iqsysmon generates main (Table A-5) and temporary (Table A-6) buffer cache statistics. Statistic names are sorted alphabetically.

**Table A-5: Buffer pool main statistics**
Dirty	FlushedBufferCount
Flushes	GetPageFrame
GetPageFrameFailure	GotEmptyFrame
InUse	MovedToMRU
MovedToWash	Pages
Pinned	RemovedFromLRU
RemovedFromWash	RemovedInScanMode
TimesSweepers Woken	Washed
washIntensity	WashMaxSize
washNActive Sweepers	washNBuffers
washNDirtyBuffers	washSignalThreshold
washTeamSize

**Table A-6: Buffer pool temporary statistics**
Dirty	FlushedBufferCount
Flushes	GetPageFrame
GetPageFrameFailure	GotEmptyFrame
InUse	MovedToMRU
MovedToWash	Pages
Pinned	RemovedFromLRU
RemovedFromWash	RemovedInScanMode
TimesSweepers Woken	Washed
washIntensity	WashMaxSize
washNActive Sweepers	washNBuffers
washNDirtyBuffers	washSignalThreshold
washTeamSize