Case Study: Financial Services Company achieves zero downtime and automated failover with ScaleArc for SQL Server

Financial Services Company Banks on ScaleArc to Ensure the Availability of its Online Credit Services

This financial services company provides innovative online credit solutions that reward borrowers for good financial behavior and relies on a SQL Server 2012 environment to power its customer-facing website and credit applications. The team faced persistent challenges around ensuring continuous availability and fast failover, automating system upgrades, optimizing SQL Server performance, and reducing time spent finding and fixing data issues—problems made harder by a complex AlwaysOn/log-shipping setup that made failover slow and error-prone.

The company deployed ScaleArc for SQL Server to add an abstraction layer between apps and databases, enabling automatic failover, a seamless migration path to SQL Server 2014 and multi‑data‑center DR, and real‑time analytics to identify and remediate query issues before they impact users. Results included automated failover that delivers zero downtime for applications, dramatic reduction of DR testing from roughly two weeks to a few hours, improved performance and visibility into queries, and a smoother upgrade and troubleshooting process that boosts customer satisfaction.