We have set the following values for our WebI Processing Server parameters -
Memory Lower Threshold (MB): 3500
Memory Upper Threshold (MB): 4500
Memory Maximum Threshold (MB): 6000
Maximum Connections: 200
Our users experienced ‘Server Out of memory’ error. During this time we found that the WebiReportServer.exe has been using 17.8GB of Memory(as observed from the Windows task Manager). How is this possible when we had set the maximum memory this server can take is only 6GB(Memory Maximum Threshold parameter)??? Can someone help me understand this behaviour?
In my opinion, Maximum Connections set to 200 is way to much. Try changing it back to the original value 50 (I think 50 is the default). If that number of connection is not enough for your user base then clone the WebI processing server as Hayden already suggested above.
You really need to look at your useage etc for your scaling and read up on what is recommended, as in your original post here:- https://bobj-board.org/t/226553
To be honest it sounds like your machine(s) are severley under specced in the terms of hardware, but until you “size” it properly you won’t know.
What made you choose to change this value form 50 to 200, was it a shot in the dark, or did you have some rationale?
http://scn.sap.com/thread/3436543
Understanding the errors and why is one thing.
Preventing these errors by sizing and configuring your system correctly, is another :).
you must uncheck “Enable Memory Analysis” in the WPS (that creates more problems than it solves nowadays; the admin guide p 896 gives the feeling that it was a protection against leaking memory) ;
keep the 200 max connections (I suppose that it won’t make a difference if you have only 10 ; you’re supposed to add a new WPS, preferably on another server, if you have more than 200).