Document rules checking goes to a very long time

Symptoms

"Document rules checking" goes to a very long time when we verify on the Web Verification station.

Cause

Slow complex performance

Resolution

If the Database and File Storage are quite big, then it can slow down the performance. In that case, we recommend you to do the following on the server where DB and FileStorage are located:

1. Open Admininstration and Monitoring Console -> Setting s-> Cleanup -> Manually cleanup and select to delete data older than (let say 7 days) and checked options to delete Processed batches, Event log, and Report data that you may have. Please check if it helps.​

2. Shrink operation on the database and its files in SQL Management Studio. You can find this instruction online from Microsoft such as https://docs.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-database?view=sql-server-ver15

3. Rebuild the index of the database. There are several options online how to do that, this is one example: https://solutioncenter.apexsql.com/why-when-and-how-to-rebuild-and-reorganize-sql-server-indexes/

4. Now from the Project, what you can do to allow the FC to automatic delete the processed batches by open the project in the Server -> Project -> Project Properties -> Export tab -> change the value to 7 days for delete processed batch. Then from now, all new-coming batches will be deleted after 7 days since processed. For old processed batches, you will need to delete them from Cleanup as instructed above.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.