Maximum Connections in Connection Pool

Setting up Maximum Connection in Connection Pool is one of the main parameter which affect performance.

The default value of 10 is usually too low (it will cause queuing) but setting it too high will eat up memory and the BI Server process may not even start (1024 kb of server memory is consumed per connection ) .

So a general rule is to follow the below formula to set up Maximum Connections.

Maximum number of connections =   Total  number of reports per dashboard *  20% of concurrent users 

Point to note: It 20% of concurrent users .NOT 20% of total users.  Generally, In any given time at-least 25% of user will be accessing dashboard.