Which GCP instances are best for OLTP workloads?

Last edited on October 10, 2022

0 minute read

    Choosing the right instance type for your workload can be a tricky proposition. It’s not always clear how a particular configuration is going to perform for your workload, and running the tests to find out is time consuming and expensive.

    So here’s the good news: we did the tests, and in this article, we’re going to share the results.

    In the 2022 Cloud Report, we looked at the OLTP performance of 18 different GCP instance types and 36 total configurations across more than 3,000 total runs. Specifically, we tested OLTP performance and price-for-performance using a metric called Cockroach Labs TPC-C Derivative Nowait. We tested both small (8 vCPU) and large (~32 vCPU) instance types both separately and comparatively on a per-vCPU performance basis.

    In this article, we’ll take a closer look at some of the most important results for GCP customers with OLTP workloads – how each instance type fared in our OLTP tests.

    (The full report, which is free, contains additional OLTP results, as well as other benchmarks for CPU, storage, and networking for these GCP instances as well as dozens of comparable instances on AWS and Azure).

    Overall median TPMCopy Icon

    In terms of overall performance, the larger 32 vCPU nodes unsurprisingly outperformed the smaller nodes. For both large and small instance types, though, the overall category winner in terms of median TPM was the t2d instance, which uses AMD Milan (Epyc Gen 3) processors.


    The t2d instances were consistent high performers in our testing, and we saw instances running AMD’s Milan processors topping the results across all three clouds.

    Median TPM per vCPUCopy Icon

    When breaking down the performance on a per-vCPU basis, we found that the best-performing small nodes actually outperformed the larger nodes. The top four finishers all use latest-gen processors (the t2d instances use AMD Milan, the n2-icelake instances use Intel Ice Lake).


    Median TPM per vCPU with storageCopy Icon

    We tested each instance type with both general purpose (pd-ssd) and high-performance (pd-extreme) storage. However, we found that for the OLTP workloads we tested, the high-end storage didn’t confer much of a performance benefit.


    Price-for-performanceCopy Icon

    When looking at price-for-performance (measured in $/TPM, see the full report for details), we found that once again the t2d instances with AMD Milan processors led the pack for both large and small instances, followed closely by the n2-icelake instances.

    price-large-instances-gcp (1)

    Want to go even deeper?Copy Icon

    The 2022 Cloud Report and goes into more detail on how these GCP instances performed in OLTP testing, and also includes benchmarks for CPU, networking, and storage performance. It also includes results for these same tests on AWS and Azure.

    It’s also free, so check out the full report for all of the information you need to pick the best cloud and instance type for your OLTP workloads.

    cloud report