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​ 

Azure SQL VM: Caching and Storage Capping (Ep. 1)
7.80 GEEK