RDS Using More Space Than DB Size

Question

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

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

I have autoscaling enabled, see the below 
![Enter image description here](/media/postImages/original/IM0vMYeQPaTmy_cR5zSIa5Xw)

My Free Storage is over 200GB, see the below
![Enter image description here](/media/postImages/original/IMmeavakdRSHypcAKmUKcXKA)

I have daily backups running (over 60 snapshots, each one is 300GB), see the below 
![Enter image description here](/media/postImages/original/IMp0DGbA7bSP6aT4m3Gxu5sw)

My Databases are less than 11GB in total, see below
![Enter image description here](/media/postImages/original/IMK1ekGH-sTP-6_ZixUNv2Mg)

My allocated storage is 300GB
My databases are less than 11GB in total
My backups are running daily but they are stored to S3, each snapshot is 300GB
My free storage is over 250GB
I don't know what is using the storage

Answer

Hi,

This post is a bit old with nonetheless very valid to help you understand the storage use by MS SQL Server (under RDS or not) and find solutions to reduce it (with performance improvements in many occasions).

See https://aboutsqlserver.com/2014/12/02/size-does-matter-10-ways-to-reduce-the-database-size-and-improve-performance-in-sql-server/

Best

Didier

Answer

You may find one of the transaction logs has taken up all the space.

There’s a couple of useful t-sql scripts to obtain information about databases in the SO answer.

https://stackoverflow.com/questions/18014392/select-sql-server-database-size

Answer

Hi,

Below link will help you to determine your RDS storage usage & issues(telling that you haven't mentioned your RDS engine)

[https://repost.aws/knowledge-center/diskfull-error-rds-postgresql](https://repost.aws/knowledge-center/diskfull-error-rds-postgresql)

[https://repost.aws/knowledge-center/view-storage-rds-mysql-mariadb](https://repost.aws/knowledge-center/view-storage-rds-mysql-mariadb)

[https://repost.aws/knowledge-center/rds-mysql-storage-optimization](https://repost.aws/knowledge-center/rds-mysql-storage-optimization)

Let me know if you have any questions

RDS Using More Space Than DB Size

相關內容