Follow-On Topics

Related Topics

# Running Maintenance

Maintenance is a process that optimises the King Task Centre internal store and is run based on a schedule defined in the Run Times and Maintenance tab of the Options dialog box. Maintenance can also be run by a System or Server Administrator at any time using the Tools, Maintenance option.

NOTE:

While the King Task Centre server is in maintenance mode, clients can still remain connected but are prevented from performing most operations by the server. Clients cannot log in whilst the server is in Maintenance mode.

By performing various operations on the store it ensures optimum performance from King Task Centre. The maintenance process performs the following:

|  | Event Log Purge — Purges Event Log entries according to the Event Log options

|  | Record Defragmentation — Purges deleted records from the store

|  | Binary Defragmentation — Purges unused binary space

|  | Reindexing — Recreates all indexes to ensure index integrity

|  | Integrity Check — Checks all entity relationships and other database rules

When maintenance activities are started for the first time, two folders are created — Backup and Maint — as sub-folders of the `C:\iwdb` folder and the current data files are copied into each of the folders. Maintenance activities are then carried out on the files in the Maint folder and on successful completion the files in the iwdb folder are then overwritten with the files in the Maint folder.

The files in the Backup folder are not overwritten and it is recommended that scheduled maintenance should be set to run daily to back up these files, thus ensuring that the data being backed up is up to date.

In the unlikely event that the Maintenance process detects any anomalies, errors or warnings will be created in the event log and subsequent notifications generated according to the Notifications options.

## SQL Store Maintenance

The SQL Store maintenance performs similarly to the King Task Centre Internal Store, except for de-fragmenting the store. This operation should be performed by the SQL Server DBA.

Copyright © 2018 Quadrant Software B.V. All rights reserved.