This page describes the machine series and machine types that you can choose from when you create a Cloud SQL for SQL Server instance.
Cloud SQL offers a range of machine series and machine types that let you tailor vCPU and memory for your instances, and optimize performance for different demands.
When you create a Cloud SQL instance, you select a specific machine type that determines the resources available for your instance. Each machine type belongs to a machine series, which is a curated set of processor and hardware configurations optimized for specific Cloud SQL workloads.
For example, the db-perf-optimized-N-2 machine type is part of
the N2 machine series.
Machine series availability for Cloud SQL Enterprise Plus edition instances
For Cloud SQL Enterprise Plus edition instances, you can choose one of the following machine series:
- N2: this machine series provides a balanced price-to-performance ratio for a variety of Cloud SQL workloads.
- Memory-optimized-N2: this machine series provides high memory-to-compute ratios for memory-intensive Cloud SQL workloads.
For Cloud SQL Enterprise Plus edition instances, each machine series offers predefined machine types with preset memory and vCPUs for your instances. Availability is dependent on your instance's Cloud SQL edition, region, and database version.
N2 machine series
N2 machine series provides a balanced price-performance for a wide variety of database workloads, with a memory-to-compute ratio of 1 vCPU:8GB RAM. N2 machine series uses the Performance Persistent Disk (PD-SSD) storage option. For more information about storage types, see Cloud SQL storage options overview.
N2 machine types
This following machine types are available for instances for the N2 machine series:
| Machine type | vCPUs | Memory (GB) | Optional Data Cache (GB) |
|---|---|---|---|
db-perf-optimized-N-2 |
2 | 16 | 375 |
db-perf-optimized-N-4 |
4 | 32 | 375 |
db-perf-optimized-N-8 |
8 | 64 | 375 |
db-perf-optimized-N-16 |
16 | 128 | 750 |
db-perf-optimized-N-32 |
32 | 256 | 1,500 |
db-perf-optimized-N-48 |
48 | 384 | 3,000 |
db-perf-optimized-N-64 |
64 | 512 | 6,000 |
db-perf-optimized-N-80 |
80 | 640 | 6,000 |
db-perf-optimized-N-96 |
96 | 728 | 6,000 |
db-perf-optimized-N-128 |
128 | 864 | 6,000 |
Memory-optimized-N2
The memory-optimized-N2 machine series provides high
memory-to-compute ratios for memory-intensive workloads.
The memory-optimized-N2 machine series uses the
Performance Persistent Disk (PD-SSD) storage option. PD-SSD is a Persistent Disk
volumes offering that provides Cloud SQL instances with
lower latency and more IOPS, and is backed by solid-state drives (SSD). For more
information, see About Persistent Disk.
Memory-optimized-N2 machine types
This following machine types are available for instances
for the memory-optimized-N machine series:
| Machine type | vCPUs | Memory (GB) | Optional Data Cache (GB) |
|---|---|---|---|
db-memory-optimized-N-4 |
4 | 128 | 750 |
db-memory-optimized-N-8 |
8 | 256 | 1,500 |
db-memory-optimized-N-16 |
16 | 512 | 3,000 |
Machine series availability for Cloud SQL Enterprise edition instances
For Cloud SQL Enterprise edition instances, Cloud SQL offers shared core or dedicated core machine series. Shared core offers machine types with predefined CPUs (cores) and amount of memory for your instances.
Dedicated cores are custom instance configurations that let you select the amount of memory and CPUs that your instance needs. This flexibility lets you choose the appropriate VM shape for your workload.
Custom machine type names use the following format: db-custom-{CPUs}-{Memory}.
When you select the number of CPUs and amount of memory, there are some
restrictions on the configurations that you can choose:
- vCPUs must be either 1 or an even number between 2 and 96.
- Memory must be:
- 0.9 to 6.5 GB per vCPU
- A multiple of 256 MB
- At least 3.75 GB (3840 MB)
Pricing
The machine series you select affects the cost of your instance. For more information, see Instance pricing. You can also use the pricing calculator to see pricing for various scenarios.