Administration Server maintenance

The Administration Server maintenance allows you to free up space in the folder of the Administration Server and reduce the database volume by deleting objects that are no longer needed. This helps you to improve the performance and operational reliability of the application. We recommend that you perform maintenance on the Administration Server at least weekly.

Administration Server maintenance is performed by using the dedicated task. The application performs the following actions when maintaining the Administration Server:

• Deletes unnecessary folders and files from the storage folder.
• Deletes unnecessary records from tables (also known as "dangling pointers").
• Clears the cache.
• Maintains the database (if you use SQL Server or PostgreSQL as a DBMS):
  • Checks the database for errors (available only for SQL Server).
  • Re-organizes database indexes.
  • Updates the database statistics.
  • Shrinks the database (if necessary).

The Administration Server maintenance task supports MariaDB versions 10.3 and later. If you use MariaDB versions 10.2 or earlier, administrators have to maintain this DBMS on their own.

To create the Administration Server maintenance task:

1. In the console tree, select the node of the Administration Server for which you want to create the Administration Server maintenance task.
2. Select the Tasks folder.
3. Click the New task button in the workspace of the Tasks folder.

   The Add Task Wizard starts.

4. In the Select the task type window of the Wizard, select Administration Server maintenance as the task type and click Next.
5. If you have to shrink the Administration Server database during maintenance, in the Settings window of the Wizard, select the Shrink database check box.
6. Follow the rest of the Wizard instructions.

The newly created task is displayed in the list of tasks in the workspace of the Tasks folder. Only one Administration Server maintenance task can be running for a single Administration Server. If an Administration Server maintenance task has already been created for an Administration Server, no new Administration Server maintenance task can be created.

Page top