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?