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. 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. For many of the tables, even if a required parameter is not enabled, some of the data in the monitoring table is valid.

**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	plan text pipe max messages	process wait events	SQL text pipe active	SQL text pipe max messages	statement pipe active	statement pipe max messages	statement statistics active	wait event timing	max SQL text monitored
monCachePool	X
monCachedObject
monCachedProcedures								X
monDataCache	X
monDeadLock	X		X	X
monDeviceIO	X
monEngine	X
monErrorLog	X				X	X
monIOQueue	X
monLicense
monLocks	X
monNetworkIO	X
monOpenDatabases	X
monOpenObjectActivity	X						X	X
monOpenPartitionActivity	X							X
monProcedureCache	X
monProcess	X																X
monProcessActivity	X						X										X
monProcessLookup
monProcessNetIO	X
monProcessObject	X							X
monProcessProcedures
monProcessSQLText	X	X																X
monProcessStatement	X															X	X
monProcessWaits	X										X						X
monProcessWorkerThread	X
monState
monSysPlanText	X								X	X
monSysSQLText	X											X	X
monSysStatement	X							X						X	X	X
monSysWaits	X																X
monSysWorkerThread	X
monTableColumns
monTableParameters
monTables
monWaitClassInfo
monWaitEventInfo