Cloud SQL for SQL Server editions is a tier-based pricing model where each edition provides different performance, availability, observability, and data protection characteristics to support your various business and application needs. Cloud SQL offers the following editions:
- Cloud SQL Enterprise Plus edition: provides the best performance, availability, and observability to run applications. These are in addition to the core capabilities of Cloud SQL.
- Cloud SQL Enterprise edition: provides all core capabilities of Cloud SQL and is suitable for applications requiring less stringent availability and performance requirements.
Cloud SQL editions features
The following table provides an overview of key features enhancements available for Cloud SQL Enterprise Plus edition when compared to Cloud SQL Enterprise edition:
| Cloud SQL Enterprise Plus edition | Cloud SQL Enterprise edition | |
|---|---|---|
| Database versions | SQL Server 2022 Enterprise SQL Server 2019 Enterprise |
SQL Server 2022 (Standard, Enterprise, Express, and Web) SQL Server 2019 (Standard, Enterprise, Express, and Web) SQL Server 2017 (Standard, Enterprise, Express, and Web) |
| Availability SLA | 99.99% (includes maintenance) | 99.95% (excludes maintenance) |
| Performance | ||
| Machine series | N2 Memory-optimized-N2 |
General purpose dedicated core N4 |
| Machine configuration limits | N2 machine series
Up to 128 vCPU Up to 864 GB RAM 1:8 core:memory ratio Memory-optimized-N machine series Up to 16 vCPU Up to 512 GB RAM 1:32 core:memory ratio |
General purpose dedicated core Up to 96 vCPU Up to 624 GB RAM 1:6.5 core:memory ratio N4 machine series Up to 80 vCPU Up to 624 GB RAM 1:8 core:memory ratio |
| Data cache |
Yes | No |
| Point-in-time log retention |
Up to 35 days | Up to 7 days |
| Availability | ||
| Maintenance downtime | < 1 second | < 120 seconds |
| Planned operations downtime |
Sub-second downtime | Few minutes |
| Advanced disaster recovery (DR) |
Yes | No |
| Write endpoint for advanced disaster recovery (DR) |
Yes | No |
| Write endpoint connectivity |
Yes | No |
| Observability | ||
| AI-assisted troubleshooting |
Yes | No |
| Query insights |
30 day metric retention 1 MB query length 200 query plan sample maximum Wait event analysis Index advisor recommendations |
7 day metric retention 4500 bytes query length 20 query plan sample maximum |
| Enhanced recommenders |
Yes | No |
Cloud SQL Enterprise Plus edition enhancements
Cloud SQL Enterprise Plus edition is ideal for applications that require the best performance, availability, and observability.
Performance
Cloud SQL Enterprise Plus edition offers the following performance enhancements:
- Improved read performance: delivers up to 4x improved read performance using the data cache, which leverages a fast, local SSD to storage data pages that are read frequently.
- Better performance with enhanced machine series options: high performance machine series availability that provides a balanced price-to-performance ratio, or memory-optimized machines that offer higher memory per vCPU for analytical workloads.
Availability
Cloud SQL Enterprise Plus edition provides the following availability enhancements:
- Near-zero downtime: sub-second downtime for maintenance and planned operations, including patching and scaling.
- Advanced disaster recovery (DR): configure disaster recovery with cross-regional replication for failover, and perform disaster recovery drills with zero data loss and minimal recovery time objective (RTO).
Observability
Cloud SQL Enterprise Plus edition provides the following observability enhancements:
- Query insights: advanced query performance diagnostics and filtering with up to 30-day metric retention, up to 1 MB query length limit, and a 200 query plan sample maximum.
- Enhanced metrics: fine-grained metrics such as wait events and granular query plan samples for faster root-cause analysis and intelligent index recommendations.
- AI-assisted troubleshooting: resolve complex database performance issues like slow queries and high database load with predictive and prescriptive troubleshooting.
How can I upgrade to the Cloud SQL Enterprise Plus edition?
You can upgrade your Cloud SQL instances to the Cloud SQL Enterprise Plus edition using in-place upgrade with sub-second downtime. After the upgrade is complete, your instance retains the configurations set prior to the upgrade.
Regional availability
For detailed information about available Cloud SQL regions, and what editions and machines series are supported in each region, see Region availability overview.
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.
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.
What if a Cloud SQL instance was created before the Cloud SQL editions launch?
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.