I was hesitating to reopen this topic ... but the issue has cropped up again and I have no leads to resolve this ...

The process has started taking up 12-13...

Well, the reboot did remove the stuck sqldumper.exe process.

However I have seen this happening a couple of times. If anyone has seen this before, kindly let know if it has...

Any ideas guys ?

I will reboot the server and see if anything changes ...

Nope its not custom. It started 3 days back, till then it was logging normally.

All other SQL related events are also normal.

- Ninad

Ater months of close monitoring this cause was found -

There was a customized report rendered in the .CSV format, which brings about a Million rows. This report renders to...

I observe the following error in the security logs:

Event Type:Failure Audit

Event Source:Security

Event Category:Object Access

Event ID:560

Date:8/20/2008

Time:3:30:00 AM

User:NT AUTHORITY\NETWORK SERVICE

Computer:xxxxxxxxxxxxx

Description:

Object Open:

Object Server:SC Manager

Object Type:SERVICE OBJECT

Object Name:ReportServer

Handle ID:-

...

I scanned the securtiy logs and have come across a peculiar event logged.

I can see that the logon/logoff event is logged several times and it is done so by the...

Finally I got the resolution.

The reports were using DB2 datasource and there was a problem on the db side itself

This was the error logged:

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set...

Any more analysis or suggestions ?

If SSRS is idle for a certain period of time, would it make the service stop ? Or perhaps even makes IIS stop. Then maybe when an event occurs,...

The reports are not that huge ... usually they get rendered in 5 mins (average)

The data pulled for the reports is from other systems, and not necessarily on the same...

I did check ... and there is nothing logged in which will help me out ...