The Annotation repository resides on the ADS/ADX within the SQL Server software database. The Annotation repository contains all optional annotations entered manually for items in the All Items tree.
The installation program places the Annotation 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 software. For details, refer to the Custom Locations for Metasys Server Application and Databases section in the Metasys Server Installation and Upgrade Instructions (LIT-12012162).
The ADS/ADX performance degrades as the number of annotations coming in to the ADS/ADX Annotation repository increases and the frequency of the annotation samples to be stored in the Annotation repository increases, depending on the hardware resources used for the ADS/ADX computer. The Annotation repository requires no special optimization because the repository only grows in size as the number of annotations increases.