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.
0:00 Show begins
0:40 Optimizing Storage Performance
2:46 Azure Virtual Machine and Storage
3:49 Disk IO Capping
6:46 Azure VM IO Capping
8:48 Host VM Caching and IO Limits
10:30 Enabling Host VM Caching
11:26 Benefits of Host Caching
12:40 Azure SQL VM Storage Best Practices
#azure #sql