GCP – Cloud SQL Enterprise Plus delivers enhanced performance, availability and disaster recovery for SQL Server
Organizations running business-critical SQL Server workloads need a managed database service that is performant, highly available, flexible, and reliable. Today, we’re pleased to announce the general availability of Cloud SQL Enterprise Plus edition for SQL Server. With this launch, Cloud SQL Enterprise Plus for SQL Server delivers new innovations that meet the needs of your most demanding SQL Server workloads, while building on the core foundation of Cloud SQL. These include:
Two new machine families for enhanced performance and higher memory per vCPU
A data cache for improved read performance
Advanced disaster recovery (DR) capabilities and 99.99% availability SLA for business continuity
The existing version of Cloud SQL for SQL Server will continue with no changes to features or pricing, but will now be known as the Cloud SQL Enterprise edition for SQL Server.
Let’s take a deeper look at the capabilities in Cloud SQL Enterprise Plus for SQL Server.
Enhanced performance and caching
Cloud SQL Enterprise Plus delivers enhanced performance with two new machine families, Performance-optimized and Memory-optimized, that offer improved performance and higher memory per vCPU (up to 32GiB RAM per vCPU). Cloud SQL Enterprise Plus offers larger machines with up to 128 vCPUs in the Performance optimized machine family. The new machine families let you run business-critical SQL Server workloads that need higher memory configurations without necessarily increasing vCPUs, and helps optimize SQL Server licensing costs.
For read-intensive workloads, Cloud SQL Enterprise Plus provides a configurable data cache that delivers higher read performance. Data cache leverages server-side SSD as a way to persist the most frequently accessed data, lowering read latency and improving throughput. In fact, Cloud SQL Enterprise Plus for SQL Server delivers up to 4x improved read performance compared to Cloud SQL Enterprise edition.
Advanced disaster recovery and availability
Cloud SQL Enterprise Plus for SQL Server helps maintain business continuity by protecting disruptions caused by regional failures. Advanced DR capabilities include failing over to a secondary region, switching back to the primary region with zero data loss, and minimizing changes to your application code with a single write endpoint (DNS name) that always points to the active primary instance.
Lastly, increased availability in Cloud SQL Enterprise Plus edition helps ensure your SQL Server workloads have the highest uptime. To that end, we’re increasing the Cloud SQL Enterprise Plus availability SLA to 99.99%.
“As a real-estate rental management service, we require better performance and availability for our database workloads, especially during peak business season. We will use the new Performance-optimized machine in Cloud SQL Enterprise Plus edition for SQL Server to run our high-throughput workload and to benefit from the higher memory available per vCPU. Cloud SQL Enterprise Plus edition for SQL Server delivers the price-performance we need to run our rental management service that delights our customers.” – Shun Watanabe, CTO, Visual Research
Getting started
You can create a new instance of Cloud SQL Enterprise Plus using the Google Cloud console, CLI or API. You can upgrade your existing Cloud SQL for SQL Server instance in-place to the new Cloud SQL Enterprise Plus edition, incurring minimum downtime.
To get started with Cloud SQL Enterprise Plus for SQL Server, visit the Cloud SQL console. To learn more about Enterprise Plus edition, see the documentation.
Read More for the details.