Attachments contribution to overall instance Storage

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2024 07:27 AM - edited 05-16-2024 07:29 AM
I have been looking at the Storage consumption on our instances and I realize that the biggest table in the instance is the sys_attachment_doc table which is nearly about 21% of the total production storage for us.
The local database storage for attachments is a very expensive storage to consume. So, I am wondering if there are options to
- Compress files before storing in the database before storing
- Store the attachments outside the instance in a cheaper storage location like an AWS S3 bucket and put a reference link to the attachment.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-19-2024 09:36 PM
Basically ServiceNow is not a document management system and due to the restricted database size not suitable for storing many/large attachments. Therefore it is the responsibility of a system admin to monitor the attachment growth and maintain the sys_attachment table. Please check the following posts which provide many tips and tricks for this topic: https://www.servicenow.com/community/forums/searchpage/tab/message?q=instance%20footprint%20attachme...
1) ServiceNow already tries to compress the data before storing it
2) Go to https://store.servicenow.com/sn_appstore_store.do#!/store/home . You will find there many solutions and spokes to connect to external document storages.