Help Center/
Relational Database Service_RDS for SQL Server/
FAQs/
Resource and Disk Management/
Which Types of Logs and Files Occupy RDS for SQL Server Storage Space?
Updated on 2025-06-30 GMT+08:00
Which Types of Logs and Files Occupy RDS for SQL Server Storage Space?
The following logs and files occupy RDS for SQL Server storage space.
DB Engine |
File Type |
---|---|
Microsoft SQL Server |
Log files: database error log, transaction log, and trace files |
Data files: database content files |
Solution
- If the original storage space is insufficient as your services grow, scale up storage space of your DB instance.
- If data occupies too much storage space, run DROP or TRUNCATE to delete useless historical table data to release storage space. If no historical data can be deleted, scale up your storage space.
- If temporary files generated by sorting queries occupy too much storage space, optimize your SQL query statements.
- A large number of temporary files are generated if there are a large number of sorting queries executed by applications.
- A large number of incremental backups are generated and occupy space if there are large amounts of insert, delete, and update operations in a short period.
- Use Cloud Eye to monitor the size, usage, and utilization of storage space of your DB instance and set alarm policies.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot