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.
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.