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.


Sponsored



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:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-implementation-daxko

Hope this helps.


Regards,

Alberto Morillo
SQLCoffee.com