Backup is slow in Azure SQL VM

  • I've a DB with size 3tb, Onpremise DB backup to disk is taking around 1.5 hr.

    On Azure SQL VM for same DB, when I backup it takes up more than 5.5 hr to complete (to both Storage account and to disk).

    There was no CPU/Memory issue when the backup is running. I've monitored using performance counters, there's disk latency on Data file disk and Backup disk when the backup is running(> 150 ms read latency on Data disk and >80 ms write latency on Backup disk).

    It is SQL server 2017 Enterprise edition in both environments, compression is enabled and we are using SQL Agent Job to backup in both cases.

    Can anyone please help reduce the backup time here.

  • The backup probably hits the iops limit of your storage account during backup https://docs.microsoft.com/en-us/azure/virtual-machines/disks-performance.

    http://2forward.eu/azure-vm-and-disk-throttling-alerting/

    seems to have a way to generate an alarm when your azure vm is being disk-throttled

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply