CODEWITHSUNDEEP
azurevirtual-machinevirtualization
George Filippakos
George Filippakos

Reputation: 16569

Azure 500 IOPS equivalent HD speed?

In azure, each Virtual Machine can have a certain number of drives attached each with a maximum speed of 500 IOPS. See VM specifications

I am configuring a SQL server and trying to gauge what the equivalent drive speed would be in traditional hard drives sense for sizing a striped set?

Would a 500 IOPS VHD be the equivalent of:

  1. SATA II
  2. SCSI 10K
  3. SCSI 15K
  4. SSD

I understand that this is not going to be accurate, but it could prove useful as a simple guide for migration from traditional HDD setup.

Upvotes: 2

Views: 3823

Answers (1)

Neil Mackenzie
Neil Mackenzie

Reputation: 2812

There are a number of limits that impact VHDs - 500 IOPS, 60 MB/s - and the actual performance depends somewhat critically on the specific workload. There are a number of SQL Server on Azure performance whitepapers which you may find helpful:

Performance Guidance for SQL Server in Azure Virtual Machines

Azure SQL Database and SQL Server -- Performance and Scalability Compared and Contrasted

The following may also be of interest since it discusses how to use Azure Blob Storage directly in SQL Server 2014:

SQL Server 2014 and Azure Blob storage integration

Upvotes: 2

Related Questions