Reporting services consuming high amount of Memory

• jitendra.padhiyar

  SSCertifiable

  Points: 5824

  More actions

  May 15, 2014 at 5:48 am

  #285654

  Hello Master,

  I have one SQL Server 2008 R2 Reporting server. Machine has total 14GB RAM. My reporting services was consuming almost 80%-90% of memory so I modified reportserver config file and have added below parameters to set up Max memory limit for reporting services to 9GB:

  <WorkingSetMaximum>9000000</WorkingSetMaximum>

  <WorkingSetMinimum>2000000</WorkingSetMinimum>

  After that I restarted reporting services as well.

  But still reporting services consuming more memory almost 9.5GB to 10 GB. Anyone can guide me how can I lower down the memory usage of reporting services ?

• ninad.soman0

  Ten Centuries

  Points: 1111

  More actions

  May 19, 2014 at 4:36 am

  #1714571

  Hi,

  You will have to take a look at the type of reports running at a time in the queue.

  Also custom output rendered reports tend to consume more memory.

• ninad.soman0

  Ten Centuries

  Points: 1111

  More actions

  May 19, 2014 at 5:35 am

  #1714583

  Not sure if you would be able to deploy the solutions in the environment immediately or easily -

  a. Build a farm for RS

  b. keep the RS server seperate from the DB server.

  Also just curious on how you are calculating the memory used values after setting the max limit ?

  Regards