DB pool settings

IEC utilizes a pool for its database connections. The database connections are used both for updating messages' metadata and for logging. If either of these consumers increase significantly then the number of database connections should also be increased, or you will create a bottleneck. It's not desirable to increase the number of database connections infinitely. Database connections are a limited resource and it will have an impact on the database server and possibly on other applications using the same database server.

Implement these installation settings for DB pool:

Recommended settings
Database.ConnectionPoolExt.MinIdle = Increase if messages arrive in bursts
Database.ConnectionPoolExt.InitialSize = Increase if messages arrive in bursts
Database.ConnectionPoolExt.MaxIdle= + Same percentage that the threads were increased with
Database.ConnectionPoolExt.MaxActive= + Same percentage that the threads were increased with