Field reference

Table A-1 identifies sp_iqsysmon statistics by section; Table A-2 provides links to field name definitions by statistic type.

Table A-1: Section names

Buffer manager

Buffer pool

Prefetch manager

IQ store free list

Buffer allocator

Memory manager

Thread manager

CPU time statistics

Transaction manager

Context Server statistics

Catalog, DB Log, and Repository statistics

Table A-2: Field name definitions

Statistics

Page Types

Lock Statistics

Buffer Allocator/Prefetch Client Types

NoteSee “System Stored Procedures” in Reference: Building Blocks, Tables, and Procedures for more information about sp_iqsysmon.