question

AndersonWavrik-2977 avatar image
0 Votes"
AndersonWavrik-2977 asked AmeliaGu-msft edited

How change Premium SSD from MSSQL to Standard SSD?

How can i change Premium SSD from my VM + MSSQL to Standard SSD?

azure-sql-virtual-machinesazure-disk-storage
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

It may be that if you want a VM with SQL Server + Standard HDD, you cannot use a marketplace image, but you will have to install SQL Server yourself.

Then again, are you really sure that you want standard HDD? I attended a class on Azure, the instructor - av MVP colleague that I highly respect - said that Standard HDD for SQL Server is not a good experience at all.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi AndersonWavrik-2977,
Welcome to Microsoft Q&A.
Are your using SQL Server on Azure VM? If so, I suggest you add a tag azure-sql-virtual-machines to the thread.
Please check this doc and this article which might be helpful:

144902-image.png

Best Regards,
Amelia


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




image.png (69.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AndersonWavrik-2977 avatar image
0 Votes"
AndersonWavrik-2977 answered AndersonWavrik-2977 edited

But i don't wanna change the VM, but my MSSQL disk.



145052-error-disk.png


This is the message when i try to change, the problem is that where i configurate. But when i'm creating the machine it gives me this.


145022-sql-server-config.png




When i click CHANGE CONFIGURATION, this is the image, they force to be PREMIUM SSD but i don't want that.




145042-storage-config.png





error-disk.png (12.5 KiB)
storage-config.png (41.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.