The Client
One of North America’s most diversified and successful private beverage companies focused on the alcohol beverage sector.
The Challenge
To provide 24*7*365 monitoring of database availability and setup of Disaster Recovery environment.
The Solution
Monitoring of database environment to eliminate performance issues, CPU, System Memory, backup and recovery was done round the clock. Database reconfiguration and reorganizations for performance improvement, database refresh, database Dump & Load and Index Rebuild were done as part of the ongoing maintenance of the system.
Disaster recovery scripts for monitoring the database extent to avoid database shutdown due reaching maximum, for monitoring file growth to check the long running transactions, for monitoring database log file growth which helps in analyzing errors in log file faster and maintain disk space.
The Benefits
Ensures round the clock production support for all your Progress / QAD and other interfaces to keep the business running with less downtime. Having processes in place to ensure smooth running of the system and fall back on a disaster recovery system in case of downtime.