SSRS Application fails after about a month or so

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SSRS Application fails after about a month or...

SSRS Application fails after about a month or so

Rate Topic

Display Mode

Topic Options

Author

Message

dgarforth

Posted Wednesday, February 15, 2012 2:00 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 8:04 AM
Points: 5, Visits: 12

Hi,

I'm running SQLServer2008 on an XP SP3 box. All is well with the system except that SSRS seems to just bomb after about 4 weeks solid operation.

I've checked the dump files and there seems to be no specific error, this is the end of the dump:

appdomainmanager!DefaultDomain!d34!01/30/2012-08:39:03:: i INFO: Appdomain:126 ReportServer_2-83-129723431400312500 unregistered.
appdomainmanager!ReportServer_2-83-129723431400312500!d34!01/30/2012-08:39:03:: i INFO: Appdomain:126 ReportServer_2-83-129723431400312500 unloading
rpcserver!DefaultDomain!588!01/30/2012-08:42:07:: e ERROR: Managed server timed out. Timeout=150 sec. Gc extension timeout=30 sec.
rpcserver!DefaultDomain!588!01/30/2012-08:42:07:: i INFO: Generating a dump from the RPCServer ProcessMonitor.

Does anyone have any idea how I can track this down?

Any ideas much appreciated.

Daz

Post #1252301

sharma_rakesh

Posted Tuesday, February 19, 2013 8:00 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 6:52 AM
Points: 1, Visits: 7

It seems like a bug in SSRS investigation reveals that the major cause of SSRS un-responsiveness\crash
Of SSRS was slow GC (Garbage collection- it manages the allocation and release of memory for your application). Granting additional timeout of 30 sec." indicates that managed server timed out while GC was in process, and so slow GC was the likely reason.

Slow GC occurs usually when you have a lot of RAM on the box and the report server process is using a lot of it. The problem is that for managed applications, a Garbage Collection (GC) occurs periodically. During a GC the process is suspended temporarily.

I tried several things during this issue at last I applied latest SP on that SSRS

Please refer below link, this will be helpfull to you.

http://connect.microsoft.com/SQLServer/feedback/details/519612/reporting-services-2008-crashing

Post #1421659

« Prev Topic | Next Topic »

Permissions