ELM utilizes Microsoft SQL Server 2008 or newer (including the Express versions) to store event, log, and performance data efficiently and securely for both reporting and archiving purposes. Our advanced controls allow you to automate your data management policies while maintaining peak performance.

In a typical deployment at least two databases are required; a Primary Database and Failover Database. In large environments, it is recommended that the ELM Server and Primary Database be installed on separate systems. Also for data storage reliability, we recommend the Primary Database and Failover Databases be installed in different instances of SQL Server. Evaluation users can have both installed on the same instances to accelerate the time to value.

Archive Databases can also be configured to offload the Primary Database for efficient reporting and to reduce storage costs.

Databases

Primary

The Primary Database is used by the ELM Server for storing data received from monitored systems. ELM's insertion technology has been developed to handle millions of events per day.

Failover

The ELM Server has a built-in database protection mechanism to prevent data loss in the event the Primary Database or connectivity is unavailable. Once the ELM Server has reconfirmed the availability of the Primary Database, the temporary data in the Failover database is merged for a seamless transition.