Case Study: Leading Pipeline Logistics Information Portal Provider achieves performance improvements and cost reductions with DatAvail

Pipeline Logistics Information Portal Provider Looks to AWS for Performance Improvements & Cost Reductions

Leading Pipeline Logistics Information Portal Providing Company relied on its portal for critical shipment visibility but suffered frequent deadlocks, timeouts and rising infrastructure costs. They engaged DatAvail for a server assessment and tuning statement of work to establish a budget and plan addressing SQL Server performance, cost reductions, upgrades and deployment.

DatAvail implemented targeted fixes—resolving deadlocks/timeouts, eliminating the daily Procedure Cache flush, recommending pessimistic locking where appropriate, optimizing AWS IOPS, and designing an upgraded SQL Server 2017 environment with disaster recovery (RPO = 1 hour, RTO < 24 hours) and maintenance plans. The result was a dramatic improvement in system performance, measurable cost reductions, a successful SQL Server upgrade, and a smoother migration process via the Windows Rapid Migration Program.