The Launch of SQL Server 2017

With SQL Server 2017, Microsoft is advancing the capabilities of its flagship OLTP database software, including support for Linux. The company is also ratcheting up the pressure on Oracle, leveraging this latest release to aggressively target enterprise customers for displacing their Oracle deployments.

ScaleArc is excited to partner with Microsoft in these initiatives - and to be named a 2016 Data Platform Partner of the Year. With ScaleArc's database load balancing software, enterprises can leverage the scaled out capabilities of SQL Server 2017 without writing a single line of code. Then, our software goes on to augment the capabilities of SQL Server 2017 - together, we offer better application uptime than Oracle RAC can deliver, and at a fraction of the cost.

Check out how ScaleArc simplifies your SQL Server upgrade and see how our software augments the native capabilities of SQL Server 2017.

SQL Server 2017 Features SQL Server Native Capability ScaleArc Augmentation
Readable Secondaries
  • Read-intent connections require application changes
  • Automatic support for read/write split
Availability Group Load Balancing
  • Can load balance read-intent connections in round-robin fashion
  • Supports dynamic, response time-based cross-geo load balancing of all queries
  • Load balancing automatically adapts to failover and role changes within AlwaysOn
  • ScaleArc monitors response time from each server node and automatically throttles workload to deliver optimal performance
Replication Monitoring
  • Monitors replication and synchronization state but not replication lag
  • Will send SQL traffic to servers lagging in replication, risking that it will serve stale data
  • Monitors replication lag and will not send queries to servers whose lag time exceeds a customer-defined threshold
  • Detects orphaned servers with broken replication links and automatically migrates connections away from that server, maintaining data consistency and zero data loss
Distributed AlwaysOn Groups
  • Improves DR by supporting multiple primary servers across different locations, but only one Primary can process transactional traffic
  • Supports one-way replication to other primaries
  • Supports active/active operations for better failover, with cross-geo and AlwaysOn-aware load balancing
Cluster-less Availability Groups support
  • No need for a clustering solution to accompany AlwaysOn Availability Groups (e.g., WSFC)
  • Provides app-transparent failover for a true zero downtime HA solution
  • Can help avoid data loss possible with Cluster-less Availability Groups
Upgrade to SQL Server 2017
  • Users will see application disruption
  • No application disruption during upgrade

Next Steps...