23
Feb

dbsizechangeOur SAP Sybase Replication servers sometimes suddenly start using unexpectedly high amount of stable queue.  So I wrote this short script to check the size of the stable queue usage and send an alert if any the % usages is greater than the value of $ALERT_PERCENT.  Then when a user starts running a massive batch into the database that hits the replication server, we are aware and can start asking the right questions before anyone else.

 

The output looks like this:-

In this example, the stable queue exceeds 5% then an email will be sent out.  feel free to use the code. Obviously, there are parts where you need to adapt to your own environment.

 

Script: rs_queuespace.sh

 

Leave a Reply

Your email address will not be published. Required fields are marked *