Case Study: an airline data center client resolves SQL Server timeouts with XTIVIA Virtual-DBA

Airline Data Center Client fixes SQL Server timeouts in 2 hours with Xtivia

An airline data center client, an existing Virtual-DBA remote database administration services client of Xtivia, faced performance issues after a migration. While moving SQL Server databases to a virtual environment and adding a second application to a clustered service, users began experiencing timeouts and dropped connections.

Xtivia quickly diagnosed the core problem as severe memory starvation, along with missing and fragmented indexes and a suboptimal tempdb configuration. They recommended and the client implemented adding RAM, adding six performance-improving indexes, establishing index maintenance, and creating additional tempdb files. These measures, executed by Xtivia, resolved the timeouts and connection drops, restoring stable performance for the airline client's applications.