Setting Maximum connections in the Connection Pool

Make sure the “Max Connections” parameter on your connection pools are appropriately set (not too
low….not too high!).    If in doubt, you can use the following formula which assumes that no more
than 4% of your users will ever be logged on and running a report at any one moment:


Max Connections =   Total Users   *   0.04   *    Max Reports on a Dashboard


So if you have 1000 users and you have no more than 4 reports on any one dashboard, then your
“Max Connections” should be set to 160.

NOTE: it is easy to exaggerate the number of users who will be using the dashboards simultaneously


Thanks,
Sandeep

SHARE SHARE SHARE

About test