Overview
A leading UK confectionery company was struggling with high cloud costs and inefficient performance across more than 25 database servers. Tech Mahindra intervened with a targeted Proof of Concept (POC) using its proprietary Cloud BlazeTech framework. The solution delivered a 20% improvement in database performance, providing a clear, data-backed strategy to reduce monthly cloud costs, accelerate transactions, and improve user experience.
Client Background and Challenges
- Large-scale operations required high-performing, scalable, and cost-effective cloud infrastructure.
- Unoptimized database workloads were driving up monthly cloud spending.
- Slow transaction times and reporting delays affected system responsiveness and user productivity.
Our Approach and Solution
- Selected live production database servers to prove the solution against real-world workloads.
- Measured Transactions Per Minute (TPM) and New Orders Per Minute (NOPM) using HammerDB.
- Fine-tuned database parameters with Cloud BlazeTech, enhancing throughput and resource utilization.
- Re-tested the benchmarks post-optimization to provide a data-backed plan for scaling across 25+ databases.
Business and Community Impact
The successful POC delivered tangible, measurable improvements, validating the solution's potential for a full-scale rollout:
- Achieved a 20% increase in database performance, measured by a significant increase in TPM and NOPM.
- Improved performance indicated that fewer database servers could handle the same workload, providing a direct strategy to lower monthly cloud costs.
- The success of a single server enabled the client to implement a data-backed plan to scale these optimizations across 25+ databases for long-term efficiency.
- Faster transaction processing and system responsiveness led to a better user experience.