Wednesday, March 7, 2012

Repot Manager Hangs

This happens very frequently on our server and I can't determine the cause.
The basic issue is that SRs gets into a state where it hangs, you can't
render reports,you can't even vire proprties, navigate folder etc, so I know
its not extenal data sources.
One things I tried was disabling Script Blocking which was enabled on our
antivirus. This is mentioned in this Kb:
http://support.microsoft.com/kb/295375/en-us
I also set the IIS Idle rest to 8 hours. But that wasn't the initial issue.
I've been looking at perfmon (thread counts, pages\sec, disk queues, working
set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
I appreciate any addiional info on things to try.
Thanks,
-pWhat version?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peaboy" <Peaboy@.discussions.microsoft.com> wrote in message
news:96C28CF8-0A0B-4C75-9811-5884A172385E@.microsoft.com...
> This happens very frequently on our server and I can't determine the
> cause.
> The basic issue is that SRs gets into a state where it hangs, you can't
> render reports,you can't even vire proprties, navigate folder etc, so I
> know
> its not extenal data sources.
> One things I tried was disabling Script Blocking which was enabled on our
> antivirus. This is mentioned in this Kb:
> http://support.microsoft.com/kb/295375/en-us
> I also set the IIS Idle rest to 8 hours. But that wasn't the initial
> issue.
> I've been looking at perfmon (thread counts, pages\sec, disk queues,
> working
> set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
> I appreciate any addiional info on things to try.
> Thanks,
> -p|||SQL 2005 w/ latest SPs and fixes.
"Bruce L-C [MVP]" wrote:
> What version?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Peaboy" <Peaboy@.discussions.microsoft.com> wrote in message
> news:96C28CF8-0A0B-4C75-9811-5884A172385E@.microsoft.com...
> > This happens very frequently on our server and I can't determine the
> > cause.
> > The basic issue is that SRs gets into a state where it hangs, you can't
> > render reports,you can't even vire proprties, navigate folder etc, so I
> > know
> > its not extenal data sources.
> >
> > One things I tried was disabling Script Blocking which was enabled on our
> > antivirus. This is mentioned in this Kb:
> > http://support.microsoft.com/kb/295375/en-us
> >
> > I also set the IIS Idle rest to 8 hours. But that wasn't the initial
> > issue.
> >
> > I've been looking at perfmon (thread counts, pages\sec, disk queues,
> > working
> > set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
> >
> > I appreciate any addiional info on things to try.
> >
> > Thanks,
> > -p
>
>

No comments:

Post a Comment