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 12»»

Out of Memory in SSRS 2008 Expand / Collapse
Author
Message
Posted Wednesday, February 18, 2009 4:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 3:40 AM
Points: 2, Visits: 74
Hello,

I work with SSRS 2008

When i want to preview my report in SSRS 2008, i have this error message "Out of Memory". i know it's the problem of the memory

But, i don't understand: when i start with a simple Reports, i preview them in few secondes and when i add one parameter, i preview them too, when i add two other parameters, i have the error message.

i already worked with SSRS 2005, i didn't have this problem.

the DBA verify settings in my machie, it's not the problem

anyone has this problem?

Have you ideas to resolve this "out of memory"?

Thanks for your help

Post #659220
Posted Monday, August 24, 2009 3:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 25, 2011 8:33 PM
Points: 9, Visits: 84
I have same problem getting Outofmemory at SSRS2008.
Report Server at SQL2005 did work fine istead.
Post #775850
Posted Monday, August 24, 2009 5:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 24, 2014 6:56 AM
Points: 2,699, Visits: 1,144
There are some issues when running SSRS 2008. Have you looked at the logs that reporting services creates. or increasing the memory that report server uses.

Have a look at this blog and see if it helps.


http://blogs.msdn.com/lukaszp/archive/2007/01/31/how-to-diagnose-issues-when-running-reports-in-the-report-server.aspx


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #775918
Posted Wednesday, August 26, 2009 7:32 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, April 24, 2014 6:25 AM
Points: 673, Visits: 557
I faced a similar problem but when I deployed that report, it worked without throwing
any exceptions or errors.

http://support.microsoft.com/kb/909678
Post #777992
Posted Friday, August 28, 2009 9:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 17, 2014 9:16 AM
Points: 361, Visits: 1,542
I was getting out of memory errors even though there is 3.5GB of memory free on the server. After I applied SP1, the errors went away but now the performance is terrible because it's using the pagefile instead of the 3.5GB of free memory. You can watch the memory usage increase till it gets to about 1GB and then it drops suddenly to about 400MB and starts thrashing the pagefile.
Post #779217
Posted Tuesday, May 25, 2010 2:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 16, 2011 4:53 AM
Points: 3, Visits: 16
I am developing reports in sqlserver 2008. I am getting similar error i.e, 'System.outofmemory Exception'.

I tried setting MaxrequestLength as 2097151 in web.config of report server.

Could you please let me know what would be the possible solution?
Post #927282
Posted Friday, May 28, 2010 1:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 25, 2011 8:33 PM
Points: 9, Visits: 84
Hi, Reporting Service at SQL2005 does work better than 2008.
SQL2005 may use temp disk storage. SQL2008 uses on-memory for Reporting
Service. On-memory work is unstable, I think.

Ohio_bear_1234

Post #929500
Posted Wednesday, June 2, 2010 2:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 16, 2011 4:53 AM
Points: 3, Visits: 16
Hi. Do u have any idea to solve memory related issues in SSRS 2008?
Post #931181
Posted Wednesday, June 2, 2010 9:58 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 9, 2010 8:19 AM
Points: 81, Visits: 90
Never seen this issue in SSRS 2008, but i found this

http://msdn.microsoft.com/en-us/library/ms159206.aspx



Post #931470
Posted Wednesday, June 2, 2010 10:09 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 12:45 PM
Points: 670, Visits: 233
How much memory do you have on the Server? E.g. If you have 4GB then it doesn't mean 4GB is available for BI!!..


-RP
Post #931481
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse