The Annotation repository resides on the ADS/ADX within the SQL Server software database. The Annotation repository contains all optional annotations entered manually through SMP for items in the All Items tree.
The installation program places the Annotation repository on the same computer where the ADS/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 Annotation repository requires no special optimization because the repository only grows in size as the number of annotations increases.