Audit repository database overview - Metasys - LIT-12012115 - Server - Metasys UI - 11.0

Metasys UI Technical Bulletin

Brand
Metasys
Product name
Metasys UI
Document type
Technical Bulletin
Document number
LIT-12012115
Version
11.0
Revision date
2020-10-30
Product status
Active
Language
English

The Audit repository resides on the ADS/ADX /OAS within the SQL Server software database.

The installation program places the Audit repository on the same computer where the ADX software resides. The default directory location is C:\ProgramData\Johnson Controls\MetasysIII\SQLData (pre-Release 8.0) or C:\Program Files\Microsoft SQL Server\MSSQL<version>.MSSQLSERVER\MSSQL\DATA (Release 8.0 or later). For a split ADX, the directory location is on the database server computer on the same drive where the SQL Server software is installed. If you want to change where the databases are loaded (for example, E:\MyDatabases), you need to do so before you install the ADS/ADX/OAS software. For details, refer to the Metasys Server Installation and Upgrade Guide (LIT-12012162) or the Metasys Server Lite Installation and Upgrade Instructions (LIT-12012258) .

The ADS/ADX /OAS performance degrades as the number of audit samples coming in to the ADS/ADX /OAS Audit repository increases. In addition, the frequency of the audit samples to be stored in the Audit repository increases, depending on the hardware resources used for the ADS/ADX /OAS computer.