DiscoverChannel 9Azure SQL VM: Caching and Storage Capping (Ep. 1) | Data Exposed
Azure SQL VM: Caching and Storage Capping (Ep. 1) | Data Exposed

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

Update: 2021-07-29
Share

Description

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:
Comments 
In Channel
loading
Download from Google Play
Download from App Store
00:00
00:00
x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

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

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

Anna Hoffman, Marisa Brasile