Azure SQL VM: Caching and Storage Capping (Ep. 1) | Data Exposed
Channel 9 - Podcast autorstwa Microsoft
Kategorie:
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. [00:40] Optimizing Storage Performance[02:46] Azure Virtual Machine and Storage[03:49] Disk IO Capping[06:46] Azure VM IO Capping Resources:Checklist: Best practices for SQL Server on Azure VMsVM size: Performance best practices for SQL Server on Azure VMsStorage: Performance best practices for SQL Server on Azure VMsHow to get the biggest bang for your buck with SQL Server on Azure VMsDeep Dive: Azure SQL Virtual Machine Sizing | Data Exposed LiveAzure SQL Virtual Machine Reimagined Series