Niko Neugebauer 5/26/2020

SQL Server Backup Throttling in Azure VMs (and in other virtualised environments)

Read Original

This technical article details the unexpected problem of SQL Server backup throttling in Azure VMs and other virtualized environments. It explains how VM disk throughput limits can be far lower than the combined throughput of attached disks, causing backups to saturate IO and lead to severe operational issues like transaction rollbacks and Availability Group failovers. The author uses a specific Azure VM and disk configuration to illustrate the performance bottleneck.

SQL Server Backup Throttling in Azure VMs (and in other virtualised environments)

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
The Beautiful Web
Jens Oliver Meiert 2 votes
3
LLM Use in the Python Source Code
Miguel Grinberg 1 votes
4
Wagon’s algorithm in Python
John D. Cook 1 votes