sp_sysmon retrieves the information for the Cache Wizard from the monitoring tables and monitor counters.To install the monitoring tables:
Add the loopback server to sysservers:
sp_addserver loopback, NULL, <srvnetname>
Grant the mon_role role to sa_role:
sp_role 'grant', mon_role, sa_role
Install the monitoring tables with the installmontables script (located in $SYBASE/ASE-12_5/scripts):
$SYBASE/$SYBASE_OCS/bin/isql -Usa -P -i $SYBASE/$SYBASE_ASE/scripts/installmontables
The Cache Wizard requires the following configuration parameters to be enabled. If these configuration parameters are not enabled, sp_sysmon automatically enables them at the beginning of the interval and disables them at the end.
enable monitoring - set to 1. This option is dynamic.
per object statistics active - set to 1. This option is dynamic.
For more information about configuration parameters, see Chapter 5, "Setting Configuration Parameters" in the System Administration Guide.
