Creating SQL databases on Azure Blob storage

• BLOB EATER

  SSChampion

  Points: 14609

  More actions

  September 17, 2015 at 12:00 am

  #321258

  Comments posted to this topic are about the item Creating SQL databases on Azure Blob storage

• ap-mode

  SSC Journeyman

  Points: 89

  More actions

  September 17, 2015 at 7:08 am

  #1827398

  Nice writeup. How are the IOPS compared to a database sitting on an Azure VM? Can we take advantage of premium storage?

• BLOB EATER

  SSChampion

  Points: 14609

  More actions

  September 17, 2015 at 7:34 am

  #1827417

  ap-mode (9/17/2015)

  ---

  Nice writeup. How are the IOPS compared to a database sitting on an Azure VM? Can we take advantage of premium storage?

  Thanks!

  Premium Storage supports only Azure page blobs and these containers are page blobs so I think you can take advantage of it. (But I haven't due to costs)

  In terms of IOPS I knew it wouldn't blow me away and it didn't, I think it was comparable to the 500 IOPS / VHD on a VM - really I would consider storage pooling / striping on the VM if I needed more performance.