The Trend repository database resides on the ADS/ADX /OAS within the SQL Server software database.
The installation program places the Trend 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 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 Trend samples coming in to the ADS/ADX /OAS Trend repository increases. In addition, the frequency of the trend samples to be stored in the Trend repository increases, depending on the hardware resources used for the ADS/ADX /OAS computer.