Looking up general information on databases

1. Select the Backoffice > System menu and click on the tab of the database required, Administration or Logs.

2. In the SQL Server section, look up the following information:

Instance	Name of the SQL Server instance.
Version	SQL Server version used.
Last Connection	Number of seconds since the backend's last connection to the database.
Status	Green: All databases can be reached and less than 71% of the disk space is used. Saturation of the database is estimated in more than three months. Orange: On at least one database, between 71% and 80% of the disk space is used, or saturation is estimated in one to three months. Red: At least one database cannot be reached, or more than 80% of the disk space is used. Saturation of one of the databases is estimated in less than a month.
Database files. View under the table the detail of the log database files.	Usage: Percentage of the available space currently used by the file. Space used: Space currently allocated by SQL Server for the file. Capacity: Space available on the disk for the file.

The log database includes the following three files:

• EsLogs: contains the reference tables centralizing redundant data present in the logs; for example, the agents having issued the logs, the source and destination applications, the paths of the files and register keys. In particular, this information speeds up the search process.

• EsLogs_log: this is the SQL Server transaction log, which contains temporary technical data.

• EsLogs_Events which contains:

  • the logs of the agents, including the contexts associated with the events when they exist,

  • the system logs.