Introduction to Cloud SQL for SQL Server editions

MySQL   |  PostgreSQL   |  SQL Server

This page describes Cloud SQL editions and key features.

Cloud SQL offers the following editions to support your various business and application needs. Each edition provides different performance and availability characteristics to meet the needs of your applications.

• Cloud SQL Enterprise edition: provides all core capabilities of Cloud SQL and is suitable for applications requiring a balance of performance, availability, and cost.
• Cloud SQL Enterprise Plus edition: provides the best performance and availability to run applications requiring the highest level of availability and performance in addition to the capabilities of the Cloud SQL Enterprise edition.

Note: Cloud SQL Enterprise edition supports all existing capabilities of Cloud SQL available as of August 1, 2024, at the same price. All existing instances before the launch of Cloud SQL editions on August 1, 2024 are updated to a Cloud SQL Enterprise edition instance automatically.

Cloud SQL editions features

The following table provides an overview of the features available for each edition:

	Cloud SQL Enterprise edition	Cloud SQL Enterprise Plus edition
Pricing model	Cloud SQL Enterprise pricing	Cloud SQL Enterprise Plus pricing
Database versions	SQL Server 2022 (Standard, Enterprise, Express, and Web) SQL Server 2019 (Standard, Enterprise, Express, and Web) SQL Server 2017 (Standard, Enterprise, Express, and Web)	SQL Server 2022 Enterprise SQL Server 2019 Enterprise
Machine type	General-purpose machine family	Performance-optimized Memory-optimized
Machine configuration limits	Up to 96 vCPU Up to 624 GB RAM 1:6.5 core:memory ratio	Performance-optimized Up to 128 vCPU Up to 864 GB RAM 1:8 core:memory ratio Memory-optimized Up to 16 vCPU Up to 512 GB RAM 1:32 core:memory ratio
Availability SLA	99.95%	99.99%
Maintenance downtime	< 120 seconds	< 120 seconds
Data cache	No	Yes
Point-in-time log retention	Up to 7 days	Up to 35 days

Performance enhancements

Cloud SQL Enterprise Plus edition is ideal for applications that require maximum performance. This edition delivers up to 4x improved read performance compared to Cloud SQL Enterprise edition.

Cloud SQL Enterprise Plus edition offers the following performance enhancements:

• Improved read performance using data cache: Data cache leverages a fast, local SSD to store data pages that are read frequently. Data cache is an optional feature and can be enabled during instance creation or after the instance has been created.

• Better performance with two new machine families with higher memory per vCPU: to meet the needs of your demanding SQL Server workloads, choose between performance-optimized machines with 1 vCPU:8GB of RAM and memory-optimized machines with 1 vCPU:32GB of RAM.

Availability enhancements

Cloud SQL Enterprise Plus edition provides the following major availability enhancements:

• Advanced disaster recovery (DR): you can simplify recovery and fallback processes after you perform cross-region failover. With advanced DR, you can:

  • Choose a cross-region disaster recovery (DR) replica

  • Perform replica failover

  • Restore your original deployment by using zero data loss switchover

  For more information, see Advanced disaster recovery (DR) and Use advanced disaster recovery (DR).

Cloud SQL Enterprise Plus edition region support

The Cloud SQL Enterprise Plus edition supports the following regions:

• africa-south1 — Johannesburg
  
• asia-east1 — Taiwan
  
• asia-east2 — Hong Kong
  
• asia-northeast1 — Tokyo
  
• asia-northeast3 — Seoul
  
• asia-south1 — Mumbai
  
• asia-southeast1 — Singapore
  
• asia-southeast2 — Jakarta
  
• australia-southeast1 — Sydney
  
• australia-southeast2 — Melbourne
  
• europe-central2 — Warsaw
  
• europe-north1 — Finland
  
• europe-southwest1 — Madrid
  
• europe-west1 — Belgium
  
• europe-west2 — London
  
• europe-west3 — Frankfurt
  
• europe-west4 — Netherlands
  
• europe-west6 — Zürich
  
• europe-west8 — Milan
  
• europe-west9 — Paris
  
• europe-west10 — Berlin
  
• europe-west12 — Turin
  
• me-central1 — Doha
  
• me-west1 — Tel Aviv
  
• northamerica-northeast1 — Montréal
  
• northamerica-northeast2 — Toronto
  
• southamerica-east1 — San Paulo
  
• us-central1 — Iowa
  
• us-east1 — South Carolina
  
• us-east4 — Northern Virginia
  
• us-west1 — Oregon
  
• us-west2 — Los Angeles
  
• us-west3 — Salt Lake City
  
• us-west4 — Las Vegas
  

Pricing

For more information about Cloud SQL editions pricing, see Cloud SQL pricing.

Cloud SQL editions FAQs

This section provides answers to frequently asked questions about Cloud SQL editions.

Does Cloud SQL Enterprise Plus edition support all engines?

Yes. Cloud SQL Enterprise Plus edition is supported on Cloud SQL for MySQL, Cloud SQL for PostgreSQL, and Cloud SQL for SQL Server.

How is Cloud SQL pricing changing?

Cloud SQL instances that you created before August 1, 2024, have become Cloud SQL Enterprise edition instances with no change in features or pricing. Instances created after August 1, 2024 can be either Cloud SQL Enterprise edition or Cloud SQL Enterprise Plus edition.

Cloud SQL Enterprise Plus edition has a new pricing structure. For more information about Cloud SQL pricing, see Cloud SQL pricing.

What can I do to prepare for these changes?

You can create Cloud SQL Enterprise Plus edition and Cloud SQL Enterprise edition instances in regions where supported using Google Cloud console and gcloud CLI.

Can I mix and match editions?

Yes, you can. Cloud SQL Enterprise Plus edition and Cloud SQL Enterprise edition provide different levels of database performance availability and data protection capabilities. You can select the Cloud SQL editions that best meets your varying application needs.

Can I migrate between editions?

By using in-place upgrade, you can upgrade your instances to Cloud SQL Enterprise Plus edition or switch to Cloud SQL Enterprise edition.