I'm still new to Azure and am looking at setting up a SQL Server. I want to use premium storage except I don't need 1TB of space. The databases themselves are relatively small and I can put backups on an HDD if necessary.
The 1TB puts me at the P30 pricing ($164/mo) when I really only need P10 ($24/mo).
I tried clicking on SQL Server settings and selecting "Storage configuration", but the sliders are already all the way to the left and won't let me put in anything less than 5000 for IOPS, 96MBps for Throughput or 1TB for storage. (This is on a DS2 v2 VM)
Is there an easy/recommended way to do what I want? An extra $24/mo for an SSD isn't a big deal even if it's not strictly necessary, but $164/mo is a bit too much.
So far I've looked at resizing the disk through the API, but it seems like you can only increase the size of a disk and not reduce it. I've also looked at just creating another disk, attaching it, moving all the SQL stuff to the new drive and removing the old one, but would I lose any of the storage optimization stuff that's mentioned in the setup tooltip?
Best Answer
I talked to Azure support and walked through the creation of the VM over a remote session. They eventually confirmed that this is the intentional design.
If you want to deploy a SQL Server with premium storage then you're getting (and paying for) a P30. Their reasoning for this was the performance and optimization benefits.
Edit: I opened another ticket directly with the SQL Support team and they were able to provide this walkthrough on accomplishing what we had asked for:
FYI this is also something that they said they were looking at changing in the future.