Adequately Configuring/Sizing the Database
- Choose the right hardware: Before starting your eG Enterprise installation, please ensure that the database server hardware is rightly sized in terms of memory, CPU & disk. Refer to “Sizing the Hardware and Database required by an eG Manager” document for more information on this. Also, ensure that sufficient database connection licenses are available to support the database connection pool required on the eG manager.
- Periodically analyze the hardware: As you add additional agents or users to the eG system, periodically recheck the workload being provided to the database to make sure that you are not running out of capacity on the database server. Check the server CPU, memory, disk activity, etc. to look for any bottlenecks.
- Use a separate database: For installations with 50 agents or less, the eG database can be hosted on the same server as the eG manager. However, if you plan to support more than 50 agents, it is preferable to host the eG database on a separate server, so that there is no resource contention between the eG manager and the eG database.
- Keep the database dedicated for the eG Enterprise system: Since the eG manager extensively uses the database – for real-time storage, analysis, and reporting – it is preferable to allocate a dedicated database server for the eG Enterprise system.