Configuring Adaptive Server for Monitoring

On each server you plan to monitor, grant mon_role to the user account used to log in to the Adaptive Server and set monitoring options in the configuration file.

The Adaptive Server component of Sybase Control Center needs a user account to log in to Adaptive Server. To gather monitoring data, that account needs the role mon_role.

You can enable monitoring options using the sp_configure stored procedure or by editing the configuration file.

Create or select a login account for Sybase Control Center to use when it connects to Adaptive Server.
Use the sp_role stored procedure to grant mon_role to the login account, which in this example is called scc:
```
sp_role "grant", mon_role, scc
```
To enable monitoring, the values of monitor specific parameters must be set. In SCC 3.2.5 and higher, you are prompted with a Configuration Parameters Validation screen that displays the current values and the values needed to enable monitoring. Change the current values to the required value or, in the case of non-binary values, use values that are consistent with the the level of activity on the monitored Adaptive Server. You must have sa_role to change parameter values. In earlier versions, use one of these methods to set monitoring configuration options.
- Option 1: Use sp_configure to set the monitoring options to the values shown in the example below. (For information on using sp_configure, see the chapter on setting configuration parameters in the Adaptive Server System Administration Guide, Volume 1.)
- Option 2: Edit the Adaptive Server configuration file manually:
1. Shut down Adaptive Server.
2. In a text editor, open the server’s configuration file, found at:
  
  Windows: %SYBASE%\<Adaptive-Server-name>.cfg
  
  UNIX: $SYBASE/<Adaptive-Server-name>.cfg
3. Save a backup copy of the configuration file.
4. Search for the Monitoring section of the file.
5. Set the monitoring options to the values shown in the example below.
6. Save the file and exit.
7. Start Adaptive Server.

Example

Note: After adding mon_role, if a resource is open for monitoring before you make the suggested parameter changes, a configuration dialog will open allowing you to modify the parameter values.

This example shows the monitoring section of the configuration file. Set these options either using sp_configure, or by manually editing the file. The Adaptive Server Monitor uses all these parameters, and notifies you if any of these options is not enabled. You may have to increase the values of sql text pipe max messages and errorlog pipe max messages depending on the level of activity on the monitored Adaptive Server.

[Monitoring]
        enable monitoring = 1
        sql text pipe active = 1
        sql text pipe max messages = 2000
        plan text pipe active = DEFAULT
        plan text pipe max messages = DEFAULT
        statement pipe active = 1
        statement pipe max messages = 2000
        errorlog pipe active = DEFAULT
        errorlog pipe max messages = DEFAULT
        deadlock pipe active = 1
        deadlock pipe max messages = 200
        wait event timing = 1
        process wait events = 1
        object lockwait timing = 1
        SQL batch capture = 1
        statement statistics active = 1
        per object statistics active = 1
        max SQL text monitored = 4096
        performance monitoring option = DEFAULT

Next