FlexiCapture 12 - Database maintenance. Slow performance. It takes a long time to open and close tasks.

Symptoms

It may happen that it takes a long time to open and close tasks in the Verification Station and the overall performance of the FlexiCapture complex is too slow. 

Cause

After a long time of work or because of high workloads the FlexiCapture database requires maintenance.

Resolution

Rebuild indexes for the tables Session, SessionTask, and Task tables. 

To rebuild all indexes on a table in a Microsoft SQL Server Management Studio do the following: 

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance. 
  2. Expand Databases, expand the database that contains the table with the specified indexes, and then expand Tables. 
  3. Expand the table in which the indexes belong. 
  4. Right-click Indexes and then click Rebuild All. 
  5. To start the rebuild operation, click OK. 

It is good practice to make this process to be automatic and schedule an execution at least once a day. 

Was this article helpful?

1 out of 1 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.

Recently viewed