Doubt on WorkingSetMinimum setting in SSRS 2008 configuration file
Hello All,
I have been reading about memory settings for SSRS 2008 for better performance in this link.
http://msdn.microsoft.com/en-us/library/ms159206.aspx WorkingSetMinimum definition here says that "Specifies a lower limit for resource consumption; the report server will not release
memory if overall memory use is below this limit."
Now, I have set the WorkingSetMinimum value as 2.4GB and when I am executing a report with 300K records, I observed in Perfmon that it has consumed around 1GB of available memory during report run time but the report server has not acquired the designated
memory of 2.4GB in WorkingSetMinimum as I can see more memory as available MB than the value supposed to be after dedicating minimum memory of 2.4 GB to report server.
My first question, has report server not acquired the minimum memory configured in WorkingSetMinimum because it didn't required that much memory to construct the report?
My second question is what does it means in the definition of WorkingSetMinimum "Specifies a lower limit for resource consumption; the report server will not release memory if overall memory use is below this limit?
The last question,, while I was observing the perfmon, during report execution, it acquired around 1GB of memory and once the report got rendered, I gave an idle time of 10 mins and after that it released the acquired memory automatically and
my available memory reached to default level. If this is the default behaviour then what is the point of setting WorkingSetMinimum?
Please provide some inputs as this concept is giving me sleepless nights from past week :-(
Regards.
September 27th, 2010 11:25pm
I think I might have responded on a similar thread just a second ago...
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/d98c99d1-9d32-4815-876a-af6665ab924b
The summary answer is as follows:
1) RS only uses memory when it is needed - so for your report it only needed 1GB so why waste memory? Also it is actually a good thing that SSRS is giving back the memory :)
2) The value of setting WorkingSetMinimum is for situations when there is resource contention on the box and you want to define how much memory SSRS considers 'belongs to it'. If it is set too low, then reports may not execute as quickly as possible
since the SSRS server will try to be nice to other applications running on the computer and it will restrict its memory usage above WorkingSetMinimum. If you want peak performance for huge reports or for many concurrent reports, increase WorkingSetMinimum.
Does that help?
-LukaszGot a bug or feature request? Tell me about it at http://connect.microsoft.com. This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
October 6th, 2010 5:48am
May I ask here ?
Does WorkingSetMinimum help in situation of OutOfMemoryException ?
What's the nature of this exception for Reporting services ?Alexander Yaremchuk
April 12th, 2011 2:24am