|
You can get the structure of the Enterprise Server DB via the init.sql script, located in the etc subfolder of the Enterprise Server installation folder. |
To specify parameters of operating with the Database:
1.Select the Administration item in the main menu.
2.Click Dr.Web Enterprise Server Configuration in the control menu.
3.Go to the Database tab and select the type of DB in the Database drop-down list:
◆IntDB – internal DB (a component of Enterprise Server),
◆MS SQL CE – external DB, for Servers running under Windows OS,
|
The MS SQL CE is a low-production external DB and it is inferior to the internal DB in this parameter. It is not recommended to use this DB, if more than 30 stations are connected to the Server. But the MS SQL CE DB can be successfully used to create reports using API ADO.NET. If you do not need this feature, it is recommended to use an internal DB or any other external DB. |
◆ODBC (for Servers running under Windows OS) or PostgreSQL (for Servers operated by UNIX system-based OS) – external DB,
◆Oracle – external DB (for all platforms except FreeBSD).
|
If an Oracle external DBMS is used, it is necessary to install the latest version of the ODBC driver delivered with this DBMS. It is strongly recommended not to use the Oracle ODBC driver supplied by Microsoft. |
For an internal DB, if necessary, enter the full path to the database file into the Path entry field and specify the cache size and the data log mode.
The parameters of an external DB are described in detail in Appendix B. The Description of the DBMS Settings. The Parameters of the DBMS Driver.
Using an internal DBMS is selected by default. This mode considerably increases the load on the Server. It is recommended to use an external DBMS in large anti-virus networks.
|
An internal DB can be used, if at most 200-300 stations are connected to the Server. If the hardware configuration of the computer with Enterprise Server and the load level of other executing tasks are permissible, up to 1000 stations can be connected. Otherwise, you must use an external DB. If you use an external DB and more than 10 000 stations are connected to the Server, it is recommended to perform the following minimal requirements: ◆3 GHz processor CPU, ◆RAM at least 4 Gb for the Enterprise Server and at least 8 Gb for the DB server, ◆UNIX system-based OS. |
|
It is possible to perform transactions connected with clearing the database used by Enterprise Server, in particular to delete records of events and data about the workstations which have not visited the Server for a certain period of time. To clear the database, open the Server schedule and add a corresponding job. |