Is it possible to add a PaaS DB in Business Critical tier to a General Purpose elastic pool?

Question

Is it possible to add a PaaS DB in the Business Critical tier to an elastic pool in the General Purpose tier? When I try to do this I get an error message.

We are trying to add 2 General Purpose DB's and 2 Business Critical DB's into a single General Purpose elastic pool. Is this possible to have databases that are in different tiers to a General Purpose elastic pool?

Thanks

Answer 1

Hi anonymous user, welcome to Microsoft QnA forum.

Adding a Business Critical Database to General Purpose Elastic Pool is allowed as any other database but once you add, the business critical database will be scaled down to General Purpose Elastic Pool. That means storage limits and cost are applicable as per the General Purpose Elastic pool only.

After adding the database, if you go back and check the activity log of Business critical database, you can see the changes as below:
Yellow - Old values
Green - New values

Again if you try to scale up the database from General Purpose Elastic Pool to Business Critical, this database will be removed from the elastic pool.

Please let us know if this helps.

Answer 2

Please try to move those databases to the elastic pool by using the following T-SQL statement:

ALTER DATABASE db1   
MODIFY ( SERVICE_OBJECTIVE = ELASTIC_POOL ( name = pool1 ) ) ;