Maintenance

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

For details about system log files, see SEI Logs.

In this section:

Setup	Description
Data volume	Monitor the amount of data in your main sources to ensure ongoing performance.
Data model optimization	Optimize reporting speed by refining how your data models are built and queried.
Excel Add-in optimization	Enhance Excel Add-in report performance by refining queries and reducing formula complexity.
Database engine performance	Tune SQL Server configuration, memory, and processing for best results.
Hardware performance	Review server and network infrastructure to ensure it meets application demands.
Backup strategy	Establish and manage regular backup routines for databases and shared folders.
Admin user	Maintain admin accounts, including unlocking and resetting passwords as needed.