Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have a SQL server hosted on an Azure VM. One of our applications is very read\write intensive on the database and we're seeing poor disk performance. Disk queue lengths of 10 or greater.

I've been trying to find a way to increase disk performance. I found a technet video here that mentions a disk quota and spanning 4 storage accounts increases disk i/o. Can anyone confirm this disk limiter or recommend this spanning technique?

share|improve this question

1 Answer 1

Azure disks are stored as page blobs in Azure Storage. A storage account has specific scale targets. As you drive heavy disk I/O load through a VM, it's possible to push the limits of these storage targets. Locally-redundant storage accounts have a perf target of 10Gbps ingress/15Gbps egress, while geo-redundant accounts have a target of 5Gbps ingress/10Gbps egress. A specific blob (which holds a single disk) has a target of 60MBytes/sec.

This is why you will see suggestions (such as that TechNet video) for using multiple disks across multiple storage accounts, to go beyond account-specific storage scale targets.

Here's an article regarding VM sizes and related max IOPs. You'll see that each VM size has max. IOPs equivalent to 500 x #disks attached.

This article covers performance considerations for running SQL Server in a virtual machine, that covers many topics including disk IO.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.