It's important to know which factors affect the performance of your server and the attached SQL database.
For example, a single ePO - On-prem server and database can manage up to 200,000 client systems with only the Trellix ENS product installed. But as you add more software products and clients, that same server hardware can no longer provide the performance you expect.
Consider these factors as your managed network grows and your security needs change.
ePO - On-prem server hardware
SQL Server — This server is the main engine within the ePO - On-prem infrastructure and affects the performance of the ePO - On-prem server, queries, dashboards, and ePO - On-prem console.
Number of software products installed — Each software product you install adds processing load on the ePO - On-prem server and the SQL database.
Number of managed clients and their Agent Handlers — These numbers are proportional to the ePO - On-prem server and database performance. Each Agent Handler places these fixed loads on the database server:
Heartbeat updates (every minute)
Work queue checks (every 10 seconds)
Pool of database connections held open to the database (two connections per CPU to the Event Parser service and four connections per CPU to the Apache service)