0

I need to move my Sql Server data from the existing Azure data disk to a new one. When I try and copy the existing files from the 'old' Disk over to the 'new' Disk it says it will take about 10 1/2 hours. URGH. That seriously hurts.

enter image description here

Yep - the picture does say that the total of these files is 860GB.

This is related to a previous question I had/have about VM's + disks ... so the destination disk (in this case) is a 2x 1TB attached disk which is dynamic + disk spanned == 1x 2TB disk.

Info on the two attached disks (which are spanned as one):

enter image description here

Both are the same as that.

Are there any other tricks I can try and leverage to increase performance for this copy?

EDIT:

  • The VM above is a (classic) Standard A4 (8 Cores, 14 GiB memory)
  • I'm also hoping to do the same on another VM which is a (classic) Standard D13 (8 Cores, 56 GiB memory).

Also trying to use Premium SSD but I can't :/

enter image description here

Here's an example of trying to create a Standard SSD (hint: there is no option):

enter image description here

2

I suspect your being limited by the disk throughput because you're using standard storage. The best solution would be to switch to using premium storage but I suspect you are running a VM SKU that does not support it. So next best thing would be to switch to using Standard SSD storage, which will work on any VM size and should up your throughput.

If you can't do that, then the other option would be to look at using larger standard disks to get more throughput, going to an S70 will get you 500 MB/s, however, then you are stuck with that size.

You also don't mention what VM size you are using. Disk performance can be throttled on some of the smaller VMs so you also want to check that.

  • Thank you @samcogan for the answer. I'll update my question with info about the VM size, etc. I'll also Try upgrading to Standard SSD storage and see if that helps (and by how much). I'll also check my other VM which I also need to do this too, and see if Premium is an option, there. – Pure.Krome Dec 1 at 1:16
  • Interestingly, I don't have an option to get Standard SSD ?? Attached is an image of trying to select Premium SSD. So then I'm on an Dev/Test pricing tier and I cannot upgrade to a DS or GS VM :/ – Pure.Krome Dec 3 at 2:33
  • If you select standard, do you not then have the option to use SSD? – Sam Cogan Dec 4 at 12:42
  • Updated OP with screenie. Looks like I cannot. Right now, I'm looking into updating my servers from Classic -> ARM and then this should allow me to resize the disk. I'll keep you posted with results. – Pure.Krome Dec 4 at 23:09
  • Yeah, I just realised you are using classic, which means you are going to be using unmanaged disk. Standard SSD is only available on Managed disks. I would recommend moving to ARM and managed disks. – Sam Cogan Dec 5 at 20:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.