RDS Using More Space Than DB Size
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
I have autoscaling enabled, see the below
My Free Storage is over 200GB, see the below
I have daily backups running (over 60 snapshots, each one is 300GB), see the below
My Databases are less than 11GB in total, see below
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
- Newest
- Most votes
- Most comments
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).
Best
Didier
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
Thanks but does not help me find the issue
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/view-storage-rds-mysql-mariadb
https://repost.aws/knowledge-center/rds-mysql-storage-optimization
Let me know if you have any questions
Relevant content
- asked 2 months ago
- asked 2 years ago
- asked 2 months ago
AWS OFFICIALUpdated a year ago- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
Thanks but does not help me find the issue