Solved

sql2008 - How to limit memory usage in Reporting Services

Posted on 2014-11-19
1
1,668 Views
Last Modified: 2014-11-24
I read from teh mcsft website saying  as setting below in rsreportserver.config file will set the limit of memory usage in SSRS.

<MemorySafetyMargin>80</MemorySafetyMargin>
      <MemoryThreshold>90</MemoryThreshold>
      <WorkingSetMaximum>4000000</WorkingSetMaximum>
      <WorkingSetMinimum>2400000</WorkingSetMinimum>

But inside the rsreportserver.config where should I place this code setting ? I'm attach as well rsreportserver.config for  review.
rsreportserver.txt
0
Comment
Question by:motioneye
1 Comment
 
LVL 47

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40454825
In the <Service> section. There's already the following configuration items:
<MemorySafetyMargin>80</MemorySafetyMargin>
<MemoryThreshold>90</MemoryThreshold>

I suggest you to add the rest after those 2 lines so you keep the memory configuration together:
     <WorkingSetMaximum>4000000</WorkingSetMaximum>
       <WorkingSetMinimum>2400000</WorkingSetMinimum>
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sql server insert 13 28
sql server computed columns 11 30
Help creating a spatial object in SQL Server 4 20
SSRS Enable Remote Errors 4 24
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question