This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.
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 seven-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