Creating a SQL DB in Azure using the SSMS results in higher performance tier

Question

We frequently delete and recreate SQL databases in Azure using SSMS. However, this process often results in the databases being provisioned at a higher performance tier, which increase costs... Is there a way to prevent this in SSMS, or is there a more cost-effective approach within SSMS?

Answer 1

Hi Abraham,

When creating a new database using SSMS, are you making sure to specify the tier and options you want via the Configure SLO tab? Please see screenshot below:

Or if creating the database via SQL:

CREATE DATABASE [mydatabasename]  (EDITION = 'Standard', SERVICE_OBJECTIVE = 'S2', MAXSIZE = 250 GB) WITH LEDGER = OFF;

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP