Reporting Services Management

What tools are available to manage which users are currently running what
reports, parameters selected, load on server etc. Basically I'm trying to
figure out how I determine if Reporting Services is slow, what report/user is
causing it, or if it's just a lot of people asking for reports and I need to
look at scaling the server.
I'm interested in historical stuff, but I'm also interested in real time
this is what's happening where with what components. For instance is
retrieval slow or is it rendering that's slowing the report down, slamming
the cpu etc.
I see the DTS package for the logs and am installing that, but is there
anything more immediate like current activity in SQL server?Larry,
Your first stop should be the Execution Log. Check "Report Server Execution
Log" topic in the documentation. Among many other things, the Execution Log
will tell you how much time is spend in querying the data, processing and
rendering the report. In addition, in Report Manager you can see the current
activity (Running Jobs).
Warning.. shameless self-promotion :-) Accidentally, my book includes a
whole chapter (Chapter 16) on the RS performance and scalability.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Larry Charlton" <LarryCharlton@.discussions.microsoft.com> wrote in message
news:8947D670-D575-4FD1-A724-9A7A0147DF29@.microsoft.com...
> What tools are available to manage which users are currently running what
> reports, parameters selected, load on server etc. Basically I'm trying to
> figure out how I determine if Reporting Services is slow, what report/user
is
> causing it, or if it's just a lot of people asking for reports and I need
to
> look at scaling the server.
> I'm interested in historical stuff, but I'm also interested in real time
> this is what's happening where with what components. For instance is
> retrieval slow or is it rendering that's slowing the report down, slamming
> the cpu etc.
> I see the DTS package for the logs and am installing that, but is there
> anything more immediate like current activity in SQL server?sql