Report Server Processes -- sql server reporting services

Jimmy D
11/3/2005 3:08:22 PM

I am fairly new to MS report services. Through Profiler I've found
that the report service is constantly calling procedures in the
ReportServer database; procedures like GetMyRunningJobs and updates to
the Notifications table.

I don't have any scheduled reports. If users need reports, they hit
the report URL and it should be generated on an as-needed basis. As
such I would like to minimize the number of cycles Report Services is
using on my DB server. Is there any way to disable these
polling/notification processes? If so, how? If not, darn.

Thanks in advance.

Jimmy

Tudor Trufinescu (MSFT)
11/3/2005 6:19:05 PM

Yes, you can turn off the subscription capabilities of SRS by setting
the following values to false in RsReportServer.config
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
That will still leave you with the check for running jobs, which is needed
to cancel running jobs. In general, all these operations should be no-ops if
you don't have any content, so I don't know whether you will get out by
eliminitating them - my guess you won't notice any difference on your SQL
Server.

Thanks,
Tudor

[quoted text, click to view]

Jimmy D
11/4/2005 2:18:04 PM

Excellent. That is exactly what I was looking for. Thanks very much
Tudor.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Report Server Processes