Azure marketplace: SQL Server 2022 image embedded on VM

Question

Hello everyone,

the Windows Server 2022 images with embedded SQL comes with a Premium 1TB disk, I know that it is done intentionally by design, by MS, because they consider that this disk is the one that gives the appropriate performance. But if I would to change it and start with lower sizing, I understand that performance changed from 200Mb/s to 150Mb/s, but my question is: Can I start resizing it to P20 SSD disk (512Gb) then in future can we upgrade it to P30 (1024Gb) without any effort on SQL?

anyone had some experience about this process?

thanks

Answer 1

You just need to resize your disks with the steps outlined on this documentation.

From that documentation, you basically need to do the following steps to upgrade the disks of your Azure VM from P20 to P30:

• Stop the VM from the Azure portal by selecting Stop in the toolbar.
• Navigate to the Settings section and click Disks. You will see the list of attached disks to your VM.
• Click on the disk you want to upgrade and select Size + performance in the left menu.
• Select the new disk size you want from the drop-down list. For P30, you can choose up to 1024.
• Select Resize at the bottom of the page.
• Start the VM again from the Azure portal by selecting Start in the toolbar.

Here you will find an article explaining the steps too with some good illustrations.