Sybase Monitor complements Agileload by extending the range of data collection and monitoring options available, by adding the ability to monitor and record performance data from Sybase components of target systems. It enables the creation of Collectors that can include a number of monitoring and data collection options. Results data generated by Sybase Monitor Collectors can be displayed and analyzed to help to identify bottlenecks that occur on target Sybase Systems during Job-runs.
Only Sybase ASE Server 220.127.116.11 and above or ASE Server 15 can be monitored
A Sybase ASE (12.5 or 15) ODBC driver must be installed in order to make Agileload Sybase Monitor work.
tables must be installed on the ASE server. Monitoring tables are
not created by default when you configure Adaptive Server. The
tables are created using the install montables script which is
included in the Adaptive Server install and is located in the
$SYBASE/ASE-12_5/scripts directory. This script requires that a
server named "loopback" be included in sysservers.
If the monitoring tables are not installed in your Adaptive Server, follow these steps for
installing the tables.
Create a loopback server entry in ISQL
Logon to Adaptive Server with sa.
Execute: sp_addserver 'loopback', null, <ASE server name>
Execute the install montables script located in the $SYBASE/ASE-12_5/scripts directory (%SYBASE%/ASE-12_5/scripts for windows) using ISQL.
isql -Usa -P<sa password> -S<server name> -n -i%SYBASE%/%SYBASE_ASE%/scripts/installmontables
Agileload automatically adds the mon_role privilege. Logons does not have this role by default, so it needs to be added to the sa logon and any other user logon.
Agileload Sybase collector automatically sets the following configuration settings the first time it starts:
exec sp_configure "enable monitoring", 1
exec sp_configure "deadlock pipe active", 1
exec sp_configure "deadlock pipe max messages", 1000
exec sp_configure "wait event timing", 1
exec sp_configure "process wait events", 1
exec sp_configure "object lockwait timing", 1
exec sp_configure "statement statistics active", 1
exec sp_configure "per object statistics active", 1
Copyright © AgileLoad. All rights reserved.