Maintenance

Regular maintenance ensures optimal performance, stability, and security for your Nectari environment. This section outlines key tasks—such as backups, log monitoring, and routine system checks—that help you keep your deployment running smoothly.

For details about system log files, see Nectari Logs.

In this section:

Setup	Description
Data volume	Assesses and monitors the amount of data in your main sources to ensure ongoing performance.
Data model optimization	Improves reporting speed by optimizing how your data models are built and queried.
Excel Add-in optimization	Enhances the performance of Excel Add-in reports by refining queries and reducing the complexity or number of formulas.
Database engine performance	Examines and tunes SQL Server configuration, memory, and processing for best results.
Hardware performance	Reviews server/network infrastructure and ensures it meets application demands.
Backup strategy	Establishes and manages regular backup routines for databases and shared folders.
Admin user	Maintains admin accounts, including unlocking and password resets when needed..