IOPS in Azure SQL DB

I learned a bit of trivia regarding Azure SQL DB today. In the standard tier, IOPS are limited to 1-5 per DTU. That means at an S3, you get a max of 500 IOPS. DTU IOPS are counted by IO operations and not size. It doesn’t matter if you’re reading or writing a single row to a table with a single char(1) column or a single row to a table with 500 nvarchar(max) columns, 1 […]