Solution
I. ESET PROTECT On-Prem database system requirements
- Specify the database server and connector you want to use when installing the ESET PROTECT Server and ensure you meet the ESET PROTECT On-Prem database server hardware and sizing instructions.
- Verify you meet the supported database servers and database connectors requirements. ESET PROTECT On-Prem supports two database servers: Microsoft SQL Server and MySQL.
Supported database server | Supported database versions | Supported database connectors |
---|---|---|
Microsoft SQL Server |
|
|
MySQL |
| MySQL ODBC driver versions:
|
*MySQL 5.6 reached the End of Life in February 2021. We recommend upgrading your MySQL database server to version 5.7 and later.
Performance Recommendations
You can decide whether to install an SQL database server on:
- The same machine as the ESET PROTECT Server
- The same machine as the ESET PROTECT Server but on a separate disk
- A dedicated server
We recommend using a dedicated machine with reserved resources to manage over 10,000 clients.
Database | SMB customer | Enterprise customer | Clients limit | Windows | Linux |
---|---|---|---|---|---|
Microsoft SQL Express | ✔ | (optional) | 5,000 | ✔ |
|
Microsoft SQL Server | ✔ | ✔ | None | ✔ |
|
MySQL | ✔ | ✔ | 10,000 | ✔ | ✔ |
Review Additional Information
- ESET PROTECT Server does not use an integrated backup. We strongly recommend backing up your database server to prevent data loss.
- Do not install SQL Server on a Domain Controller (for example, Windows SBS / Essentials). We recommend that you install ESET PROTECT On-Prem on a different server or do not select the SQL Server Express component during installation (this requires you to use your existing SQL or MySQL Server to run the ESET PROTECT On-Prem database).
- If you intend to use a dedicated database user account that will only have access to the ESET PROTECT On-Prem database, you must create a user account with specific privileges before installation. Additionally, you will need to create an empty database that will be used by ESET PROTECT On-Prem.
- See the instructions to install and configure MySQL for Windows and MySQL for Linux to work properly with ESET PROTECT On-Prem.
- Microsoft SQL Server on Linux is not supported. However, you can connect the ESET PROTECT Server on Linux to Microsoft SQL Server on Windows.
- If you install the ESET PROTECT Server and Microsoft SQL Server on separate computers, you can enable an encrypted connection to the database.
- The cluster setup of the database on Windows environments is supported only for the Microsoft SQL Server, not MySQL.
II. Determine your ESET Inspect On-Prem hardware requirements
Before installing the ESET Inspect Server
- Install the ESET Inspect Connector on at least three endpoints (ESET Inspect Connector is operable without ESET Inspect Server).
- Activate the product with a valid ESET Inspect On-Prem license. The activation is done via ESET PROTECT On-Prem by creating a Product activation task. To do this, contact your ESET PROTECT Administrator or create a Product Activation task.
- Wait for at least a day.
- Navigate to the folder where ESET Inspect Connector is installed (by default
C:\Program Files\ESET\Inspect Connector
) and run the commandEIConnector.exe --stats
. - From the output, use Average Events Per Day.
After the ESET Inspect Server is already installed and working
- Go to Dashboard → Events load tab, and in the Events processed and stored per computer chart, check the highest values of events received per 24h.
- To calculate the estimated CPU, RAM, and disk space requirements for ESET Inspect Server and MySQL on the same machine, use the calculator in the Online Help topic.
Minimum requirements | ||||||
| MS SQL Server | MySQL | ||||
Number of Endpoints | 500 | 1000 | 5000 | 500 | 1000 | 5000 |
Memory | 4 GB | 4 GB | 12 GB | 4 GB | 4 GB | 12 GB |
Disk space | 566 GB | 1.24 TB | 6.2 TB | 566 GB | 1.1 TB | 5.6 TB |
Disk IOPS | 1500 | 1500 | 3000 | 1000 | 2000 | 3000 |
Number of CPU cores | 2 | 2 | 10 | 2 | 2 | 8 |
III. Install ESET Inspect On-Prem
- Ensure the SQL database is on the same server as ESET Inspect On-Prem and the SQL instance is dedicated.
- Download and install the ESET Inspect server.
- Select the type of ESET Inspect On-Prem users managing ESET Inspect On-Prem Security Operations Center (SOC), Security-focused IT or IT Administrators. For more information on the difference between the options, see this Online Help topic.
- Select the appropriate data collection options.
- Configure ESET Inspect On-Prem to optimize database size. If you store all available data for data collection, it may be necessary to create event filters for executables that are sending extremely large amounts of events. If the option to store all available data was selected, see our Online Help topic for more information.
- After the initial installation of ESET Inspect On-Prem, it will be required to create exclusions to minimize the number of benign detections. This can be accomplished in the following ways:
- Manually create exclusions.
- Enable Learning mode so the Rule learning mode automatically suggests exclusions. The exclusions will appear in Questions for you to review. This can be enabled during the initial prompt after the first login to the ESET Inspect Web Console or by going to More → Settings → Rule learning mode.
- Enable prebuilt exclusions.
IV. Optimize ESET Inspect On-Prem performance
Update | Description |
System Requirements | Ensure your ESET Inspect Server is up to specification and meets (or exceeds) software and hardware requirements. Having a dedicated machine with ample storage space to run the database system may further improve performance. This is not mandatory, you can run the ESET Inspect in a single server environment. |
MySQL | If you have the option, choose MySQL to run the ESET Inspect Database. It currently outperforms the Microsoft SQL Server when running the ESET Inspect Database. |
Number of threads | This applies only when your ESET Inspect Database is running on a different server than the ESET Inspect Server. If your ESET Inspect Server and ESET Inspect Database runs on the same machine, this is configured automatically, you can skip this step. Set the number of cores to increase the performance, making your ESET Inspect Server more efficient. Click More → Settings → Database performance (available in the on-premises version only) and specify the Number of threads writing to database according to this formula: 1.5x the number of physical cores of your server running the ESET Inspect Database |
Performance check | We recommend you make sure your system is fit, capable, and performs well. Since ESET Inspect deals with a lot of data, you may experience performance issues. Generally, the database can be a bottleneck. Such performance issues are usually caused by undersized hardware specifications, especially insufficient disk space. However, the performance can also be hindered if there are too many events being collected by ESET Inspect. A healthy server processes a high number of Events per second but has a low Event Packet Queue Length. Perform a performance check of your server to see how it is doing. |
Minimize the number of events | The events processed and stored per computer (stored/received within 24 hours) have the biggest impact on performance. An event is an action done by a process, such as a file write, DNS lookup, new registry entry, etc. All these are individual events listed in the Raw Events view. An average workstation produces about 100,000 stored events per 24 hours (depending on the environment). Your goal is to lower the number of stored events. Some event filters (automatic exclusions) are proposed by ESET Inspect, click Questions to review the exclusions, then accept or reject. You can also customize or manually create exclusions to further optimize performance in Event Filters. Click Settings → Data collection to select what type of data should be collected from endpoint computers. Available in the on-premises version only. |
Events load | ESET Inspect collects event data, among which there are anomalies or outliers. Identify the outliers, for example, known executable events considered as safe and generate excessive occurrences. To reduce the number of events, create a filter for the executable:
Repeat this process until you have dealt with most of the outlier events. Also, follow the procedure for the other tables within the Events load. This optimization can have a significant impact on increasing performance. |
Change events frequency | If there are still too many events, you can decide to decrease the interval when events are sent by creating a new policy in ESET PROTECT On-Prem: Click Policies → New policy → Settings and select ESET Inspect Connector. In the Interval of sending events to the server, specify the desired time and frequency at which events are sent. |
False positive detections | Get rid of false positives to unload the database and prevent future flooding with unnecessary data. Create rule exclusions for False positive detections.
|
Tips |
|