SQL 2005 reporting Services High Memory utilization

• nikhil.desai1

  SSCommitted

  Points: 1948

  More actions

  June 5, 2014 at 6:49 am

  #286272

  Hi,

  Daily we are facing High memory utilization around 1 pm to 2 pm for reporting services. After restarting

  the Reporting Services the memory utilization becomes normal.

  Following are configuration details

  Windows OS : 2003R2-Enterprise Edition 64 bit SP2

  SQL Server 2005 Enterprise Edition 64bit SP4

  min and max memory settings for SQL Database Services are the default settings not changed

  min: 0

  Max: 2147483647

  RAM : 16 GB

  Reporting Service Memory setting details are as follows

  <Service>

  <IsSchedulingService>True</IsSchedulingService>

  <IsNotificationService>True</IsNotificationService>

  <IsEventService>True</IsEventService>

  <PollingInterval>10</PollingInterval>

  <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>

  <MemoryLimit>60</MemoryLimit>

  <RecycleTime>720</RecycleTime>

  <MaximumMemoryLimit>80</MaximumMemoryLimit>

  <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>

  Please let me know the best recommend memory settings for reporting services in above rsreportserver.config file.

  Thanks and Regards,

  Nikhil P Desai