Case Study: Credit Card Processing Company achieves sub-second transaction speeds with XTIVIA database health check and archival process

Credit Card Processing Company - Customer Case Study

The Credit Card Processing Company, a business-to-business payment processor, was seeing transaction times rise from under three seconds to as much as ten seconds as its database grew. It turned to XTIVIA for a SQL Server database health check and help building a custom archival process to reduce the load on active tables.

XTIVIA identified SQL Server configuration issues and fragmented indexes, then implemented best-practice maintenance and a custom T-SQL archiving workflow that moved records through a reporting database and into an archive database after 90 days. As a result, the company achieved sub-second transaction processing, kept only 90 days of active data in its primary table, and maintained near-100% database availability by rolling changes out during scheduled outages.