RDS Using More Storage Space Than Used

Question

I need assistance with my RDS storage increasing daily. This is a SQL Server Standard Edition instance.

The allocated storage is 200GB, see the below
![Enter image description here](/media/postImages/original/IMnLow5fwBRgKY6PzUZ2a5DQ)

Autoscaling is enabled, see the below
![Enter image description here](/media/postImages/original/IMK1fqPg19T5-85nCPiMblfA)

Total DB and Log File Size is 14GB, see below 
![Enter image description here](/media/postImages/original/IMjTvB0bZCSom9TBBJHRoEHQ)

Storage Full Error, see below 
![Enter image description here](/media/postImages/original/IMY4-eo8o-QaG45D1BfCLoOA)

Free Storage space is over 60GB, see below 
![Enter image description here](/media/postImages/original/IMc1M5iTzLSLi72aGeh66eoQ)

I have daily backups running which get pushed to S3
![Enter image description here](/media/postImages/original/IMCxV7-9o-Re2p0Cl4D1NY-w)

How can my databases ad log files be 14GB, my allocated storage is 200GB, my free storage is 60GB, but i'm getting a storage nearing full warning.

200GB - 14GB = 186GB
I should have 186GB free storage, but i keep having to increase my storage because of the storage full error i keep getting.

Answer

Hi Thapelo.

It is difficult to see into RDS instances since they are managed by AWS but here is a document [1] that has some information to troubleshoot storage in RDS.

[1] https://repost.aws/knowledge-center/rds-sql-server-storage-optimization

I hope this is helpful.

RDS Using More Storage Space Than Used

相關內容