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.


Alberto Morillo on Wed, 10 May 2017 16:48:51


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.

Here is a comparison article that can help you decide.

The following case study may be useful too:

Hope this helps.


Alberto Morillo