Nitrosphere accelerates Dynatrace’s
SQL Server Replication around the globe

Industry
Semiconductor & Telecommunications Equipment

Use Case
SQL Server Replication Acceleration

Stack
SQL Server
Windows Server OS

In Dynatrace’s Web Performance division, one of the keys to success was the ability to use NitroAccelerator’s network optimization to help provide real-time performance data to global customers over the internet. Thousands of companies worldwide rely on Dynatrace to optimize the performance, quality, and availability of their web and mobile applications.

Challenge
Scaled Replication Over Distance

With over 100,000 networked locations worldwide, Dynatrace faced a challenge providing real-time performance data that it promised its customers. Particularly many of its largest customers are distributed and require performance data to be collected from around the globe. In order to be a real-time solution, they had to improve the ability to push data around the world, no matter the network scenarios.

Dynatrace’s performance network relies on SQL Server to house their customers’ performance data. This data is stored geographically local to the websites they monitor and is replicated back to their headquarters using transactional replication. The replication from the remote sites occurs over WAN connections that vary in speed and reliability. These WAN connections in many cases are unable to maintain a real-time flow of performance data.

Solution
Replication Acceleration as Software

NitroAccelerator was installed to Dynatrace SQL Servers without user interruption. The replication agents were then restarted to show immediate improvements. A 15-minute tuning call with the team provided additional throughput advantage with CPU overhead of 1-3%.

Result
Real-time SQL Server Replication over the WAN

With NitroAccelerator, the Dynatrace team is able to maintain real-time replication across even their slowest WAN connections. NitroAccelerator provided an 80% reduction in TCP packets and between 80 to 90% reduction in latency.

“Prior to NitroAccelerator, our replication jobs for 175 servers around the world were taking 26 hours each to complete. It reduced that to 2 hours. We could not run our business without NitroAccelerator.”

Paul Wilson
Dynatrace

ABOUT NITROSPHERE

Nitrosphere is an Austin, TX company that designs and develops unprecedented solutions to the most common network performance issues. Their flagship acceleration software has been adopted by enterprises across all sectors. For more information, please visit nitrosphere.com and follow us on LinkedIn or Twitter.