ScaleArc

Improving Uptime and Performance of Legacy Apps on
Microsoft SQL Server

DOWNLOAD WHITE PAPER


Performance tuning inefficient legacy applications can be a tremendous drain on development resources in an organization. Handling availability of the database layer of these applications can be an even larger challenge. ScaleArc can help improve both challenges by improving the availability of the database layer and accelerating common repetitive database queries from the application.

The past five years or so has seen a shift in people’s expectations for application performance. As they’ve seen their personal apps deliver continuous uptime and high performance, they’ve grown more frustrated with the slower performers in business. Despite these business apps being critical to corporate performance, users have “just dealt with it” for years whenever they’re slow and unreliable. One challenge, of course, has been that these enterprise apps are much more complex than the personal apps, making it harder to update them. Plus, making the necessary changes to “update” the application might be out of the hands of an organization when they don’t control the source code, or are costly and time prohibitive to update when they do. A compelling alternative has emerged. Rather than recoding apps for improved uptime and performance in a database environment, consider the benefits of database load balancing software. A pioneer in this technology, ScaleArc has set out to make business application platforms more highly available and perform better by managing the traffic into the database servers. The ScaleArc software acts as an intermediary between the application and database layers. Sitting in between, it buffers database outages from impacting application availability and transparently accelerates the application’s performance, all without code or usability changes. This whitepaper explains the benefits of the ScaleArc software and shows benchmarking results of one feature set – app-transparent caching. In our tests, the ScaleArc software enabled a 5x improvement in the operations processed per minute and a drop in CPU consumption from a peak of 100% to a peak of 60%.

Our testing demonstrates that the ScaleArc software provides an easy way to improve application uptime and performance with no changes to the application code.

  


ABOUT THE AUTHOR David Klee is a Microsoft MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise are virtualization and performance, datacenter architecture, and risk mitigation through high availability and disaster recovery. David speaks at a number of national and regional technology related events, including the PASS Summit, VMware VMworld, IT/Dev Connections, SQL Saturday events, SQL Cruise, PASS virtual chapter webinars, and many SQL Server User Groups.

Demo on Demand

Next Steps...