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

Question

Question

Attempting to reduce the size of Workflow Database MDF file

Workflow Version 10
Updated April 18, 2018
asked on September 17, 2016 • Show version history

Ran Workflow Cleanup Utility to cleanup the Business Process Data from Jan 01, 2000 to September 15th, 2016

Deleted Previous Versions of Workflow Definitions

Set the maintenance within the Workflow Admin to delete reporting data and instance data that is 1 day old.

Ran Management Plan that Reorg Index, Shrink Database, Reorg Pages, reindex, and update statistics

I have only been able to reduce the size of my database by 3 GB. 

What other suggestions does laserfiche have to reducing the size of the Workflow database?

Right now, the database is 333 GB. 

0 0

Replies

replied on September 19, 2016

Can you run a SQL report on the database so we can see where most of the data is?

Did you run a Workflow Statistics report to see if the number of running instances are not what you expect them to be?

0 0
replied on April 18, 2018

Mason,

Did you find a way to reduce your DB size at the end. I am interested in knowing as what have you done and what have you achieved.

Thanks

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

Sign in to reply to this post.

Details
Related Posts
Loading ...