Azure General Purpose V2 Table Storage

Question

I am looking to stand up an Azure General Purpose V2 storage account so that I can leverage the table storage for some reference tables for an application. I know there are IOPS limitations on disks but I can't find anywhere the IOPS limitations for table storage. Does anyone know if it depends on the size of the storage and if so where I might find the documentation so I can be sure this will work as a solution for what I am trying to do?

Thanks!

Answer 1

Hi,

I recommend you test with sample data/usage that is as close as possible to what you will use in your application. Your design and usage patterns will have great affect on performance. Below article outlines the limits and targets for Table:

Scalability and performance targets for Table storage

https://learn.microsoft.com/en-us/azure/storage/tables/scalability-targets

One thing you may want to consider is to design your application so that you may switch to Cosmos DB if needed. Please read below article, and initially take a look at the API for Table benefits chart where you have Storage Tables on left and Cosmos DB on right:

https://learn.microsoft.com/en-us/azure/cosmos-db/table/introduction

Design scalable and performant tables

https://learn.microsoft.com/en-us/azure/storage/tables/table-storage-design

Thanks.

-TP