We have quite a few customers using NitroAccelerator to improve SQL Server Replication performance. I have seen multiple uses for SQL Server Replication including:
- Moving data from a centralized publishing database to a remote database so that the data is closer to the application users
- Like above but using, for example, SQL Server Express, as a local cache on the end-user system to speed up the application
- Moving data from remote locations into a central database
Kendra Little has a good blog entry, Performance Tuning SQL Server Transactional Replication: A Checklist, that addresses several things to consider around replication, including the network. When the database servers are in physically separate locations – whether across town or across continents (as the case with our customer, Dynatrace) – then the network will become the central issue. The farther apart the servers, the more likely latency will become a factor. Additionally, when the servers are in other countries or remote regions, you can’t always control the level of bandwidth, or it might be impractically expensive to upgrade it. Argenis Fernandez’ blog entry on Transactional Replication and WAN links is a good reference for the further tuning of replication across the WAN and the perils of using WAN accelerators.
Yet the network connection can still constrain performance and cause unacceptably high replication latency. That’s when NitroAccelerator comes into the picture. According to Pinal Dave, in SQL Server – When to Use a Sledgehammer and When to use a Screwdriver:
“A common issue when using replication over long distances is that it can fall hopelessly behind. I have seen many companies leverage NitroAccelerator from Nitrosphere to mitigate this issue by attaining near gigabit LAN speeds over these high-latency connections. As a result, they outperform the Always On feature at a fraction of the price.”
Real-time replication across even the slowest connections is a simple reality with NitroAccelerator. Maybe it’s time to start leveraging NitroAccelerator in your environment!
Wow! I can’t believe January is already almost over. We hit the ground running this year with honing our focus as a company, taking care of our existing customers, and onboarding new ones. In 2016, we made major inroads in stabilizing and adding some key new features to NitroAccelerator such as intelligent protocol detection and HyperCache which significantly speeds up client-server applications. We also announced support for SQL Server Analysis Services (SSAS) which is our first foray into accelerating applications purely at the TCP/IP level. In 2017 you will see new capabilities put into NitroAccelerator which will further broaden our market appeal in the SQL Server space and you will also see a new product that takes what we learned with SSAS and brings acceleration and security to ALL Windows-based applications.
In 2016 we won back several customers who decided that, indeed, we are mission critical to their operation, and we also expanded our customer base significantly. In the last few months, we have won customers in Europe, Asia, and Africa (as well as the USA) and are now working opportunities that will put us on EVERY continent in the world.
So, we have been busy! This week we are returning to our bread and butter in putting a focus on SQL Server Replication. Many of our original customers are using NitroAccelerator to speed up replication between geographically dispersed locations and we believe that replication is a good way to co-locate data with the applications to improve performance at those locations. Pinal Dave wrote a nice piece this week about this use for replication, as well as other replication scenarios in his latest nicely title blog, When to Use a Sledgehammer and When to use a Screwdriver.
I’m also looking forward to my first video blog where I interview a Nitrosphere customer about the before and after relating to NitroAccelerator. It’s a great interview and I hope you watch it. I’ll be doing this on a regular basis with customers and other people in our industry.
With that, a belated but excited Happy 2017!