Working with the Database

In order to keep the Atlas Copco Data Communication database up and running with good performance and reliability, the following maintenance activities are recommended:

  • Make regular backups of the database to secure the data in case of hardware failure and to keep the transaction log from growing in size.

  • Rebuild and reorganize the indexes in the database regularly, to keep the transactions and searches fast and optimized.

  • Delete old results that are no longer needed. This reduces the required disk space and improves report creation speed. After a Delete maintenance job it is also recommended to reorganize the indexes.

  • To run the maintenance job, setup and start the job scheduler manager for required database type.

A

AtlasCopcoDataCommunication Service

B

AtlasCopcoDataCommunication_WebAPI service

C

AtlasCopcoDataCommunication_ProtocolServerStore Service

D

AtlasCopcoDataCommunication_PowerMacsProgramManager service

E

AtlasCopcoDataCommunication Database

F

PSS Database