Maximum number of connections in a connection pool

Recommended Approach:

 20% of concurrent users * number of reports per dashboard.

As each connection pool consumes 1MB of server memory please set the maximum connections to a reasonable level depending on your server configuration.

Note: I am assuming the report generates one Physical Sql.

In other words it was rewritten as

 20% of concurrent users * number of Max Physical Sql per dashboard.

No comments:

Post a Comment