I am sitting here trying to figure out what the elastic pool in Auzre gives me. I have a customer that wants a guess on pricing if the move to Azure. They have 3 databases, on a server. The server has 96 GBs of RAM and a 3.4 Ghz processor. That is all i know. The three databases is sharing these specs, and each database has it own area of expertise:
- one database handles all the CMS data
- the second database handles all the commerce data
- the third database is a database that stores user info, etc – all data that doesnt fit the two others
I think the usage pattern is pretty diverse, so sometimes the commerce is using a lot of RAM and CPU, other times it is the CMS etc.
I dont think they fit well into a single database, because they are going to need three big databases then, and almost all of them is going to be under utilized all the time. So I thought about elastic pools.
The describtion of ealstic pools fits the above very well: all databases shares eDTUs. Perfect! But one thing the docs doesnt describe is: do i pay for the elastic pool AND pr database? Or do I just create databases on the fly, and all of them shares, that is: the databases is free, but you pay for the eDTU.
I have read this https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool – but they don’t describe it.
Hope someone can give me some more info.