We've installed ProTop, and our databases are now being monitored. What's next?
Once the basic ProTop installation and configuration are complete and communication between your ProTop installation and your ProTop Portal has been established and confirmed, it's time to move on to the Advanced ProTop configuration steps.
Here is a comprehensive list of the advanced ProTop configuration procedures. You won't need all the optional procedures; please execute the ones that apply to you.
NOTE: Be sure you've executed these procedures before you attempt to copy your initial ProTop installation to other servers.
Advanced Configuration Procedures for All Installations:
- REMINDER: on Linux, add dbmonitor.sh to crontab of the user ID that runs ProTop
- REMINDER: be sure you have created at least the following localized versions of these default alert configuration files:
cd $PROTOP/etc
Please make changes to your local versions rather than the default versions. This will prevent your customizations from being overwritten during the next ProTop update
cp alert.cfg alert.[siteid].cfg
cp pt3agent.cfg pt3agent.[siteid].cfg
cp schedule.cfg schedule.[siteid].cfg - Adjust database table and index range parameters as recommended by ProTop RT
- Set up syncio in the scheduler - to measure and trend OE disk write performance
- Set up a user experience "client-server" monitor in the scheduler if you have remote users
- Set up a user experience "local host" in the scheduler
- schedule db analysis
- schedule automated health checks
- Add (df) disk space monitoring to your main db pt3agent.*.cfg
- Set up recurring outages in the ProTop Portal
- Set up alert responses and test/verify from the ProTop Portal
- Reduce alert noise, tune your alerts to your specific needs
- Set up Telegraf - for server metrics (not a ProTop tool; just on the most important server(s))
Optional Advanced Configuration Procedures:
- Configure secure comms with the ProTop Portal
- Set up OE Replication monitoring
- If OE Replication+ is used, install ProTop on the target server and configure database monitoring
- If using shared memory connections, set up zOldTRXDetails.sh from .shx
- Set up Pro2 monitoring
- Set up Classic App Server / Webspeed monitoring
- Enable the calculation of uptime (System Availability) for critical databases
- Set up PASOE monitoring
- Set up log monitoring
- Set up custom application monitoring
- Check for NUMA issues if you are sharing a virtual host
- Configure custom alerts sent from your application
- Configure automated script actions initiated by alerts
- Manage database log files
- Create User Defined Key Performance Indicator metrics