The Challenge
OPTIMIZE DATABASE ENVIRONMENT & REDUCE OPERATIONAL COSTS
The client is a pharmaceutical company that develops and manufactures both branded and generic drugs. The client’s SQL server database grew rapidly with diverse application uses and owners. Unfortunately, so did its operational costs. Management recognized the need to take greater steps to ensure the environment was secure and optimized. Faced with mandates to reduce costs, Aspect was brought in with the goal to reduce operational costs by 20%.
The Solution
CONDUCT DATABASE SERVER CONSOLIDATION EXERCISE
To begin the engagement, Aspect performed an in-depth assessment of the client’s SQL Server database environment. Aspect collected key metrics using the following steps:
- Detect Database Activity to free up space and reduce costs
- Detect Database Backup Level
- Collect Server Usage Statistics
The Advantage
OPERATIONAL COST REDUCTIONS & ENVIRONMENT STABILITY ACHIEVED
Reduced Operational costs
Aspect was able to retire databases and reduce the number of servers within the environment by approximately 25%, leveraging savings by reducing licensing costs and energy consumption.
Optimized Administration
Aspect closed all maintenance gaps, and comprehensive monitoring ensures that missed backups, downed servers, failed jobs, and out of range disk space or file size growth can no longer occur without alerting support staff.
Cost Efficiency
Services were less than the savings realized by reduced costs, and with Aspect maintaining and extending the monitoring system, the client’s existing staff was freed to address more mission critical projects.
FEATURES & BENEFITS
- Successfully Reduced Operational Costs by 20%
- Stabilized Database Environment
- Optimized SQL Server Databased by performing an in-depth assessment and consolidating servers