Report Server Processes

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.
JimmyYes, 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
"Jimmy D" wrote:
> 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
>|||Excellent. That is exactly what I was looking for. Thanks very much
Tudor.