Turbocharging Insurance: NCS Slashes Batch Processing from 14 Hours to 3
Services offered:
Overview
Imagine your critical insurance reports stuck in a 14-hour processing jam, derailing your day before it even starts. This was the reality for a global insurance leader using their DQPro application on Azure. With costly server upgrades looming and delays crippling efficiency, NCS stepped in with a smarter plan: precision database tuning. In one move, we cut processing time from 14 hours to 3 and reduced costs by 50%, a true game-changer.
The Challenge
The client was battling a triple threat, not just slow, but a productivity killer that hurt decisions and eroded trust.
Slow System Performance:
Massive tables lacked proper indexing, and tangled queries led to erratic execution plans, dragging the batch process to 14 hours.
Resource Drain:
Inefficient queries consumed excessive CPU, hinting at a costly solution: doubling server cores and inflating Azure spend.
Operational Disruption:
Starting at 5 AM, the process bled into office hours, delaying critical reports and disrupting downstream applications.
The Objective
Accelerate Batch Processing
Cut processing time to 3 hours, freeing up time for critical analysis.
Optimise Costs
Reduce Azure resource usage without sacrificing performance.
Ensure Scalability
Build a solution that is future-proof, stable, and scalable.
Tools & Methodology: The NCS Edge
We utilised the best tools to solve this challenge:
Query Store
Gave real-time insights into query performance.
First Responder Kit
Streamlined diagnostics to pinpoint issues quickly.
SQL Monitoring
Ensured the system remained stable post-deployment.
The Approach
Our team engineered a tailored solution to meet the unique needs of this engagement.
We used AI-powered tools like Query Store and First Responder Kit to analyse queries and workflows, pinpointing inefficiencies.
The Payoff: Rock-Solid Results
Here's what they walked away with:
466% Faster batch processing
Faster batch processing, from 14 hours to 3.
50% Reduction in Azure costs each month
Reduction in Azure costs each month.
0 Query timeouts
Query timeouts, with a system built to scale.
Conclusion
The insurer's DQPro team now starts each day with reports ready to go, focusing on analysis and client priorities. By slashing their Azure bill by 50%, NCS didn't just fix a slow process, we turned it into a competitive edge. Smart SQL tuning, not more servers, saved both time and budget. As data volumes grow, NCS is keeping this client ahead with regular assessments and predictive tuning.
Facing slow batch processing and rising Azure costs?
Contact NCS for a performance and cost optimisation assessment, and start every day with your critical reports ready, not stuck in a 14-hour jam.
Talk to NCS