Maintenance

What can I do about to much data in Centara Server

The main tables that are growing without transactions being performed are listed here below. Note that the data within these tables can be deleted at any time and only serve the purpose of adding information value to servicing the system. There is a built-in auto cleanup mechanism within Centara Server which is probably just not cleaning as fast as you like. But as I said before, you can delete the data at faster pace if you like but if you see any abnormalities in table growth, we would appreciate you letting us know.

1. POS monitoring – Centara server writes its own log to the file system, but it receives various log information from the workstations and persists that to the database.

   1. dbo.HBI_WORKSTATION_LOG - Contains the workstation log

   2. dbo.HBI_WORKSTATION_INFO - Contains information about workstation state

2. Transactions – Those are tables that grow for each sale transaction but also for some operations like login and logout. On top of that, there is an audit table that records activity about processing history.

   1. audit. HBI_POS_TRAN_PROCESSING

3. Alerts – The server persists data regularly regarding things to take into consideration if an alert needs to be raised. This data is collected about various things, disk size, warnings if workstations become offline and such.

   1. dbo.HBI_ALERTS_HISTORY