Sql database

Niren Adhikary (NAD) 146 Reputation points
2022-07-31T21:25:51.723+00:00

Hi,

How can we resolve Azure SQL database storage Used Space and Allocated Space issue.

Pricing tier : Standard S1: 20 DTUs
No Elastic pool

226499-image.png

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,886 Reputation points MVP
    2022-08-01T00:01:35.253+00:00

    Your allocated space will grow automatically, you don't have to worry about it, that is normal. You will always see used space close to allocated space. The key is when allocated space and used space are getting close to the maximum storage size.

    If you see the database size reaching the maximum size you may need to run the following statement to increase the maximum size or adjust the maximum size using Azure portal.

    ALTER DATABASE AzureDB2 MODIFY (EDITION='STANDARD', MAXSIZE= 50 GB)  
    
    1 person found this answer helpful.
    0 comments No comments