Trend Repository Overview - Metasys - LIT-12013243 - M4-OASMIN-0 - M4-OASSTD-0 - Server - Open Application Server - 13.0

Open Application Server (OAS) Commissioning Guide

Product name
Open Application Server
Document type
Commissioning Guide
Document number
Revision date
Product status

The Trend repository database resides on the OAS within the SQL Server software database.

The installation program places the Trend repository on the same computer where the OAS software resides. The default directory location is C:\Program Files\Microsoft SQL Server\MSSQL<version>.MSSQLSERVER\MSSQL\DATA.

If you want to change where the databases are loaded, you need to do so before you install OAS. For details, refer to the Open Application Server (OAS) Installation Instructions (LIT-12013222).

The OAS performance degrades as the number of Trend samples coming in to the 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 OAS computer. You can optimize the required storage size of the OAS Trend repository using the following methods:
  • configure larger sample intervals for individual trends
  • determine which trends to store long-term and transfer only these samples
  • configure the trends of non-critical objects to sample on large Change-of-Value (COV) increments

In addition, you can optimize the network communication performance for transferring trend samples from engines to the OAS repository by configuring the Transfer Setpoint on individual trends so they transfer their samples at intervals different from other trends.

Refer to the Trend Extensions topic in the Metasys SMP Help (LIT-1201793) for more information.