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 with David Pless and Pam Lahoud, 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.
https://techcommunity.microsoft.com/t5/video-hub/azure-sql-vm-caching-and-storage-capping-ep-1-data-exposed/m-p/2595398#M1332 https://techcommunity.microsoft.com/t5/video-hub/azure-sql-vm-caching-and-storage-capping-ep-1-data-exposed/m-p/2595398#M1332 2021-07-29 19:29:38Z