Configuration parameters for the monitoring tables

Adaptive Server uses configuration parameters to control what data is collected for the monitoring tables. Many of the monitoring tables require you to enable configuration parameters before Adaptive Server collects data. You must grant the mon_role to users before they can query some monitoring tables.

If you are not using a monitoring table, disable the associated configuration parameters, reducing the load on the Adaptive Server caused by collecting monitoring data.

Table 1-1 lists all of the monitoring tables and the configuration parameters that apply to them.

**Table 1-1: Configuration parameters required for some monitoring tables**
	enable monitoring	SQL batch capture	deadlock pipe active	deadlock pipe max messages	errorlog pipe active	errorlog pipe max messages	object lockwait timing	per object statistics active	plan text pipe active	lock timeout pipe active	lock timeout pipe max messages	plan text pipe max messages	process wait events	SQL text pipe active	SQL text pipe max messages	statement cache size	statement pipe active	statement pipe max messages	statement statistics active	wait event timing	max SQL text monitored	enable stmt cache monitoring	capture compression statistics
monCachePool	X
monCachedObject
monCachedProcedures	X																		X
monCachedStatement	X															X						X
monCIPC
monCIPCEndpoints
monCIPCLinks
monCIPCMesh
monCLMObjectActivity	X
monClusterCacheManager
monCMSFailover
monDataCache	X
monDBRecovery
monDBRecoveryLRTypes
monDeadLock	X		X	X
monDeviceIO	X
monDeviceSpaceUsage
monEngine	X
monErrorLog	X				X	X
monFailoverRecovery
monInmemoryStorage
monIOController
monIOQueue	X
monLicense
monLocks	X
monLockTimeout	X									X	X
monLogicalCluster
monLogicalClusterAction
monLogicalClusterInstance
monLogicalClusterRoute
monNetworkIO	X
monOpenDatabases	X
monOpenObjectActivity	X						X	X
monOpenPartitionActivity	X							X
monPCIBridge
monPCIEngine
monPCISlots
monPCM
monProcedureCache	X
monProcedureCacheMemoryUsage
monProcedureCacheModuleUsage
monProcess	X																			X
monProcessActivity	X																			X
monProcessLookup
monProcessMigration
monProcessNetIO	X
monProcessObject	X							X
monProcessProcedures	X																		X
monProcessSQLText	X	X																			X
monProcessStatement	X
monProcessWaits	X												X							X
monProcessWorkerThread	X
monRepLogActivity
monRepScanners
monRepScannersTotalTime
monRepSenders
monSQLRepActivity	X							X
monSQLRepMisses	X							X
monState
monStatementCache	X															X						X
monSysLoad
monSysPlanText	X								X			X
monSysSQLText	X	X												X	X						X
monSysStatement	X							X									X	X	X
monSysWaits	X																			X
monSysWorkerThread	X
monTableColumns
monTableCompression	X							X															X
monTableParameters
monTables
monTableTransfer
monTask
monTempdbActivity	X						X	X
monThread
monThreadPool
monWaitClassInfo
monWaitEventInfo
monWorkload
monWorkloadPreview
monWorkloadProfile
monWorkloadRaw
monWorkQueue