By default, Adaptive Server does not collect the monitoring information required by the monitoring tables. Use sp_configure to configure Adaptive Server to start collecting the monitoring information. There are a number of configuration options, listed below, that control the collection of monitoring data in various areas.
Many of the monitoring tables require that you enable one or more of the configuration options before Adaptive Server collects their data. Different tables require different options. Table 1-1 describes which configuration options are required for each monitoring table.
To configure Adaptive Server to collect general monitoring information:
By default, the enable cis configuration parameter is enabled (set to a value of 1) when you first configure Adaptive Server. Verify that this parameter is enabled.
The enable monitoring configuration parameter determines whether other monitoring options are enable; set enable monitoring to 1.
sp_configure “enable monitoring”, 1
Adaptive Server displays a full list of configuration parameters specifically for monitoring when you enter:
sp_configure Monitoring
The configuration parameters that control the collection of monitoring information are:
enable monitoring
deadlock pipe active
deadlock pipe max messages
errorlog pipe active
errorlog pipe max messages
max SQL text monitored
object lockwait timing
per object statistics active
plan text pipe active
process wait events
sql text pipe active
sql text pipe max messages
statement pipe active
statement pipe max messages
statement statistics active
SQL batch capture
wait event timing
See Chapter 5, “Setting Configuration Parameters,” in System Administration
Guide, Volume One for descriptions of the configuration parameters.
