Detailed notes on reviewing existing DBCCDB for use with ‘check storage’ DBCCDB review First, find out what ASE recommends you set the minimum values to using > sp_plan_dbccdb <dbname> Then, we work through these values and we pay attention to the settings below. check size of dbccdb check size of dbccdb_cache check scan ws value […]
Why should different version of Sybase on a single Windows server be an issue? If you install multiple versions of Sybase ASE, the paths will become filled with contradictory references to both Sybase install locations. The Windows servers may or may not start but even if they do, you cannot be 100% sure which library […]
Our 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 […]