Configuring the SQL Dialog

This tab of the configuration dialog is used to configure the size and archiving settings for the SQL database that is used by CommandCenter.

Maximum Database Size (MB)

This shows the total size that the SQL Express database will grow to given the settings of the Alarm, Audio and App sizes below. Note: The total size for this version of CommandCenter is limited to 4GB. The greyed out edit box to the right shows the current size of the database. The default size of the database for a new installation of CommandCenter is 1GB.

Maximum Alarm Log Size (MB) and Maximum Audit Log Size (MB) and App. and User Config Size (MB)

This shows the desired size of the different parts to the database. The greyed out edit boxes to the right shows the current size of each in the current database.

Enable Alarm Log Archiving

When the Alarm Log database reaches the Maximum given above the data can be archived to a file external to the application. This option will enable this feature. If this is not required then the non-active warning and alarm events will be deleted from the database.

Limit Alarm Log Archive Size and Maximum Alarm Log Archive Size (MB)

If archiving of the Alarm Log is enabled then optionally the application can check to make sure the total storage size of the archive files does not exceed the amount defined.

Enable Audit Trail Archiving

When the Audit trail database reaches the Maximum given above the data can be archived to a file external to the application. This option will enable this feature. If this is not required then the events will be deleted from the database.

Limit Audit Trail Archive Size and Maximum Audit Trail Archive Size (MB)

If archiving of the Audit Trail is enabled then optionally the application can check to make sure the total storage size of the archive files does not exceed the amount defined.

Archive Directory

The directory where the optional archive files are stored is defined here and altered using the browse button. Please note the files that will be created in this directory will be named according to the date of entries being archived. So it is likely when the first files are created they will be named with a date perhaps 3 months previous, as these are the oldest events are the ones that will be archived first.

Use Default Local Database

This option should normally be checked for a standard CommandCenter installation, however in the case that a remote or redundant SQL database being required this option should be unchecked to reveal further user options for the locations and login credentials of the database.