question

SijadMalik-1919 avatar image
0 Votes"
SijadMalik-1919 asked ·

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

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

azure-sql-database
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered ·

Hi @SijadMalik-1919, 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

73600-image.png

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.


image.png (38.1 KiB)
· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AnuragSharma-MSFT - Thank you for the diagram, this is exactly what I was trying to get confirmed. Much appreciated.

0 Votes 0 ·
AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered ·

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 ) ) ;  


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.