You are viewing limited content. For full access, please sign in.

Question

Question

SQL tables related instance data storage

asked on October 12, 2016

We are on Workflow 10 and are considering increasing the lifetime number from 30 to 60 or 90 days for the "Remove instance data for completed workflow" in workflow administration.

We'd like to estimate how much more database space this may take up. Does anyone know which tables are affected when instance data is removed?

Thanks!

0 0

Replies

replied on October 12, 2016

It's tables with names in the "search_<something>_log" format.

0 0
replied on October 12, 2016

Thanks Miruna.

I did some looking around in the meantime, and found the following tables appear to have records related to the instance history:

dbo.search_activity_messages

dbo.search_activity_messages_log

dbo.search_activity

dbo.search_activity_log

dbo.search_entry

dbo.search_entry_log

dbo.search_instance

dbo.search_instance_log

Are you saying that the tables without the *_log above in the name are not included in maintaining history for the instances.

 

Thanks!

0 0
replied on October 12, 2016

That's correct. The ones without _Log contain info on running instances. As an instance is completed, its history gets moved from the "live" table to their corresponding _Log equivalent and kept there for 30 days (or however long the lifetime specified is).

0 0
replied on October 12, 2016

Awesome! Thanks so much for clarifying that!

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.