Niagara R2 Enterprise Server – Maximum Trended Points and Performance Impact

[Product_Support]

Issue

What is the maximum number of trended points that can exist in a Niagara R2 Enterprise Server station?

Product Line

TAC IA Series

Environment

Niagara R2 Enterprise Server

Cause

There is no fixed limit for trended points in Niagara R2. Each trend sample is stored in the station’s application database. As the database grows, system performance can degrade.

Resolution

• There is no recommended maximum point count or trend interval for Niagara R2 Enterprise Server.
• Trend samples are stored in the app database located at:
  C:\niagara\stations\app
• When this folder becomes too large, the Enterprise Server performance will be affected.
• Workaround:
  • Periodically move or purge the contents of the app folder to maintain optimal performance.
  • Implement a regular maintenance schedule to prevent excessive database growth.

---

Best Practices for Trend Configuration

1. Set Appropriate Sampling Intervals

   • Avoid very short intervals (e.g., <1 minute) unless absolutely necessary.
   • Use intervals that align with operational needs (e.g., 5–15 minutes for HVAC points).

2. Limit Retention Periods

   • Configure trend logs to purge older data automatically after a defined period (e.g., 30–90 days).
   • Export historical data to external storage if long-term archiving is required.

3. Use Averaging or Summarization

   • For high-frequency data, consider logging averages or summaries instead of raw samples to reduce database size.

4. Monitor Database Growth

   • Regularly check the size of the app folder and set alerts for excessive growth.