Data Exposed  - Channel 9

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


Listen Later

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
...more
View all episodesView all episodes
Download on the App Store

Data Exposed  - Channel 9By Microsoft