SQL elastic Pool storage

Question

Hello,

In my Azure SQL Server i go to SQL elastic pools and found the storage is 95% used.

but if i go to the elastic pools the usage is only 42%

Anyone know why?

Answer 1

Hi Handian Sudianto,

Thanks for reaching out to Microsoft Q&A.

• Elastic Pool (42% used): This shows the total space used by all databases in the elastic pool, compared to the total allocated storage for the pool. In this case, 42% of the total allocated storage (200 GB allocated out of 250 GB maximum) is being used, which is 105 GB.
• Storage Usage on the Specific Elastic Pool (95%): This figure represents the total percentage of used storage based on the configured maximum capacity or the storage quota per database or pool, depending on the pricing tier and configuration. It suggests that one or more databases in the pool might be near their individual storage limits, triggering the high usage warning.

reasons for the discrepancy may be due to...

• per DB Storage Quotas: Individual dbs within the elastic pool may have storage limits imposed even if the pool itself has unused capacity. For instance, one db might be nearing its quota within the pool causing the 95% warning.
• Retention and Logs: It’s also possible that unused logs or retention files could be temporarily inflating the reported storage usage even though actual data storage remains lower.

Go to the elastic pool and view the storage breakdown by individual databases. You may find that one or more databases are consuming significant space. If needed, consider increasing the allocated storage or resizing the pool to accommodate current and future growth.

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.