2 個答案
- 最新
- 最多得票
- 最多評論
0
Hi there.
There are different elements affecting the storage in an RDS instance. I would recommend reviewing the following article [1] that discusses not just the database files but also other elements such as TempDB, Auditing, CDC, etc.
[1] https://repost.aws/knowledge-center/rds-sql-server-storage-optimization
I hope this helps.
-1
There has not been any autoscaling on your instance since your freeable storage is still very high relative to the allocated storage. Storage autoscaling only impacts the size of allocated storage when your freeable storage falls below some threshold.
The size of the snapshots is just a reflection of the size of the allocated storage of the instance. The actual size of the snapshots are much smaller.
相關內容
- 已提問 10 個月前
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
Thank you for this. Does not answer the question though.
What is using the storage?
I think you are asking about the size of the snapshots not the size of the instance or the used storage on your instance below 300g?
The 300 just refers to the size of the instance that the snapshot represents. It is very difficult to know exactly the size of the snapshots because they are incremental and rolling day by day as you take nightly system snapshots. In your case these are almost certainly a lot smaller than the 300gb.
Hi Phil Snapshots get stored on S3, so the size of the snapshots should be irrelevant in this scenario, not so?
At least that's what the AWS documentation says: https://aws.amazon.com/blogs/database/amazon-rds-snapshot-restore-and-recovery-demystified/#:~:text=Amazon%20RDS%20snapshots%20are%20stored,for%20copy%20and%20restore%20operations.
Here is my question: My allocated storage is 300GB, and my database and log files are 11GB. 300GB - 11GB = 289GB Why am I getting storage full errors when I should have 289GB of free storage? Where is my storage disappearing to?
Yeah, we must be missing something here. This is the first you've mentioned storage full errors.
The storage of the database snapshots is independent from the storage of the RDS instance. The RDS instance has a allocated storage of 300gb. You are only using a small bit of that, which is why your freeable storage metric is close to 300g. You are not running out of space.
The 300g next to the snapshot is not at all related to the free storage on the instance. It just represents the size of the volume were you to restore that snapshot. You cannot run out of space for backups.
I do not understand the storage full errors.