Optimizing Virtual Machine storage is one of the most critical areas to focus on when architecting for performance with SQL Server on Azure Virtual Machines (VM). Virtual machines have input/output operations per second (IOPS) and throughput performance limits based on the virtual machine type and size as well as storage. In part one of this eight-part VM series, we'll cover how capping occurs at the virtual machine and storage levels and how caching can help remove the impact of these performance limits.
Resources:
Checklist: Best practices for SQL Server on Azure VMs
VM size: Performance best practices for SQL Server on Azure VMs
Storage: Performance best practices for SQL Server on Azure VMs
How to get the biggest bang for your buck with SQL Server on Azure VMs
Deep Dive: Azure SQL Virtual Machine Sizing | Data Exposed Live
VM size: Performance best practices for SQL Server on Azure VMs
Storage: Performance best practices for SQL Server on Azure VMs
How to get the biggest bang for your buck with SQL Server on Azure VMs
Deep Dive: Azure SQL Virtual Machine Sizing | Data Exposed Live
