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.
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