Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2005 reporting Services High Memory utilization Expand / Collapse
Author
Message
Posted Thursday, June 5, 2014 6:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, October 10, 2014 3:40 AM
Points: 40, Visits: 509
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
Post #1577750
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse