Should I choose Azure Sql database, SQL Serveur in cloud VM or stay on-premise SQL.
Category: azure sqlazure
Question
Jo Bouillon on Wed, 10 May 2017 14:50:52
I try to evaluate the price of switching to SQL Azure but I'm not sure what I need.
On my SQL server I have 3 X 50 Go Database for Staging, Test and production environement. I have also 7 other small database less than 100 meg each.
I'm wondering if I should buy a single basic or standard plan by database or use the elastic pool option.
Also, I'm wondering if azure offer options for test, staging database that are less use.
I found that I could buy 3 standard plan around 20$/month for one database and 8 basic plans at 6$/month.
I'm wondering if I go with the standard elastic plan at ~$153.79/mo for all my database that will get really better for the money or I should separate by database.
Replies
Alberto Morillo on Wed, 10 May 2017 16:48:51
Hello,
I would like to recommend you elastic pools for your QA environment, you can have all your databases in a pool, and if one database
gets all the traffic during a specific test you can shift the overall power assigned to all other databases to that specific database.
https://msdn.microsoft.com/en-us/library/mt163596.aspx
Here is a comparison article that can help you decide.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-vs-sql-server-iaas
The following case study may be useful too:
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com