Monday, February 27, 2012

Report Server engines configuration best practices, the 'maxEngine' parameter configuration

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Report Server engines configuration best practices, the 'maxEngine' parameter configuration


Solution:

As per Oracle's recommendation, in a server where the Reports Server(s) is / are running, there should be maximum 2 to 3 engines per CPU for optimum performance. This is a cummulative figure irrespective of the number of Reports Server(s) running in that server. Thus, it is recommended to optimally set the "maxEngine" parameter (corresponding to the engine id "rwEng") for each of the Reports Server(s) as follows :

Recommended number of maximum Total number of
'maxEngine' for engines (2 or 3) per CPU x CPU(s) in the server
each Reports Server = -------------------------------------------------------
Total number of Reports Server(s) running in the server

For example, in case of a server having 4 CPUs and 2 Reports Servers running in that server, it is recommended to set the 'maxEngine' parameter for each of the Reports Servers to "4" based on the following calculation :

2 x 4
'maxEngine' of each Reports Server = ----- = 4



Hence, at any point of time, the maximum number of engines that can be active simultaneously for both the Reports Servers running in that server is 4 x 2 = 8.

However, if the utilisation of any of the Reports Server(s) is less compared to the other Reports Server(s) running in that server, then the 'maxEngine' parameter setting for the Reports Server(s) needs to be tuned appropriately. In case of the above example, the 'maxEngine' parameter for the less utilised Reports Server can be decreased from 4 to 2 and that for the mostly utilised Reports Server can be increased from 4 to 6. The point that needs to be kept in mind is that, even with the modified 'maxEngine' parameter settings, the maximum number of engines that can be active simultaneously for both the Reports Servers running in that server is 2 + 6 = 8.



Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: