Running SQL Server workloads on Azure as IAAS (Infrastructure as a service) is becoming popular. With more SQL Servers running on Azure virtual machines, there has been a need to know how to effectively and efficiently one can run them with minimal bottlenecks.
Note: If you buy something from our links, we might earn a commission. See our disclosure statement.
In order to have the maximum performance out of your Azure VM’s, here are the list of steps to look out for:
Less than 10 ms – very good Between 10 – 20 ms – okay Between 20 – 50 ms – slow, needs attention Greater than 50 ms – Serious I/O bottleneck
Hope this covers the basics of what steps needs to be followed in order to run SQL Server more efficiently on Azure VM’s.
Comments are closed.