Attachments contribution to overall instance Storage

creativecookie
Tera Contributor

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

  1. Compress files before storing in the database before storing
  2. Store the attachments outside the instance in a cheaper storage location like an AWS S3 bucket and put a reference link to the attachment.
1 REPLY 1

Maik Skoddow
Tera Patron
Tera Patron

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.