Scale your business with ScaleArc
October 05, 2017
Scale your business with ScaleArc
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with ScaleArc for SQL Server
We are a 24/7 SaaS company that provides a CRM to automotive companies across the globe and our need to be highly available is mission critical. As in most SaaS platforms there is always a single point of failure and that was our design on how we direct customers to there corresponding servers; this is where we need to be able to provide the highest point of availability. Prior to implementing ScaleArc, we had a very unstable environment with quite a bit of global customer impact and with the introduction (Version 1) of Availability Groups in SQL Server 2012; there was a lot of instability in the number of failovers and bottlenecks.
Since implementing ScaleArc over a year ago; we have instantly brought our availability to 99.9999%. The ability to route reads to the secondary replicas without any application changes was a huge advantage in getting ScaleArc deployed rapidly. The strength in the product is the ability to cache connections during a failover (not inflight transactions) meaning the customer would never notice there was a problem whether planned or unplanned. We've already had occasions where we have had experienced failovers and not one customer call came in :) This opened the door for daytime maintenance if necessary which is a godsend if you are DBA; less nights having to be up late the better
Simply put; ScaleArc makes me look good :)
Since implementing ScaleArc over a year ago; we have instantly brought our availability to 99.9999%. The ability to route reads to the secondary replicas without any application changes was a huge advantage in getting ScaleArc deployed rapidly. The strength in the product is the ability to cache connections during a failover (not inflight transactions) meaning the customer would never notice there was a problem whether planned or unplanned. We've already had occasions where we have had experienced failovers and not one customer call came in :) This opened the door for daytime maintenance if necessary which is a godsend if you are DBA; less nights having to be up late the better
Simply put; ScaleArc makes me look good :)
- Caching connections to ensure a seamless failover.
- Automatically route reads to the secondary replicas without application changes.
- Ability to cache queries for better end-user experiences.
- Real-time analytics to determine where your bottlenecks are and any queries that could be candidates for caching.
- Ability to firewall (block) an incoming query to avoid further performance issues and vulnerabilities from attacks such as SQL injections.
- The fact that the analytics is included in the product; it really is hard to recommend this. However; I would recommend the analytics be a little more easier to use and more intuitive for drilling down to the source of the problem.
- Our ROI is provided simply by keeping the customer up and running; a happy customer is good for business.
Outside of Microsoft SQL Server 2016 introducing the ability to route reads across the entire availability group; there is no other solution on the market that even comes close, and that's even if they exist.