Advanced Server Options: Maintenance

This tab, in the Advanced Server Options, lets you configure if and when old workflow reporting data, instance details, and messages will be deleted from the Workflow database. Periodically deleting this data will help reduce the size your database.

Important: To configure the frequency of database maintenance, use the Database Maintenance Server Timer. The options below are also available in the Database Maintenance Server Timer.

To configure maintenance options

1. Select the Advanced Server Options node or any server details in the center Details Pane.
2. Click Properties in the Actions Pane, or right-click and select Properties.
3. Select the Maintenance tab of the Advanced Server Options dialog box.



4. Configure which database maintenance tasks will occur:

Warning: If you clear any of these options, the size of your SQL database will continue to grow as new reporting data is added but no data is deleted.

• Remove reporting data for completed workflows: This option deletes reporting data associated with completed workflow instances after a specified period of time. Any data older than the Lifetime specified will not be available to new Workflow Statistics Reports and business process details.
• Remove instance data for completed workflows: This option deletes data associated with completed workflow instances after the specified period of time. Any data older than the Lifetime specified will not be available to new search results.
• Remove unreferenced items from workflow message cache: This option deletes messages (such as condition traces; error, warning, and informational messages; and tokens) that are no longer referenced by workflow activities. Any unreferenced messages will not be available in the instance details.

Note: If this option is selected, messages will be removed as soon as they are no longer referenced. There is no Lifetime settings for this option.

5. Define the following by typing a number next to each option or using the scroll box (up-and-down arrows) to specify a number:
• Lifetime: Configure how long the data will be available to new search results, Workflow Statistics Reports, and/or business process details.
• Timeout: Configure how quickly, in seconds, the SQL query will time out when trying to remove data that is past its expiration date.
6. Click OK.
7. Use the Database Maintenance Server Timer to configure how frequently database maintenance will occur.