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.
Hope this helps.