SQL Data max Size

Handian Sudianto 4,076 Reputation points
2024-03-18T01:55:37.82+00:00

Hello,

I have one SQL server with elastic pool enabled.

On the elastic pool the Data Max Size set to 200GB and this SQL contains of 22 database.

Current elastic pool datas storage is 78% used space and this mean I still have around 44 GB.

User's image

Also today i have DB with data used 100GB

User's image

So with this condition i have 2 questions:

  • Can i expand the DB from 100GB to 140GB (with assumption i still have 44GB free space)
  • If i need expand this DB to 200GB, this mean the Data Max Size on the elastic pool should be expanded also?
  • Can the DB inside the elastic pool have max size more than max size on the elastic pool?
Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Vahid Ghafarpour 17,700 Reputation points
    2024-03-18T02:02:44.47+00:00

    Thanks for posting your question in the Microsoft Q&A forum.

    you can expand the database from 100GB to 140GB if you still have around 44GB of free space in your elastic pool. This should not be an issue.

    The maximum size of a database inside an elastic pool cannot exceed the maximum size set for the elastic pool itself. If the elastic pool has a maximum size of 200GB, no single database inside the pool can exceed this limit.

    ** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **