active user connection?
Now and again i need to restart reporting services to perform maintenance on the server. Unfortunately I don't have an easy way to ascertain whether users are logged on when I do
this, so inevitably end up throwing people off.
I could log log on the to box that ssrs sits on and run netstat, but was wondering if people here know of a plugin to report manager that can tell me what users are logged in and active.
Andy
February 23rd, 2011 10:03am
Hi Andy,
You could use the windows Performane Counters to monitor users' activity. The
ReportServer:Service performance object includes a collection of counters to track HTTP-related events and memory-related events for a report server instance. This performance object appears one time for each Reporting Services instance
on the computer, and you can add or remove counters from the performance object for each instance. Counters for the default instance appear in the format
ReportServer:Service. Counters for named instances appear in the format
ReportServer$<instance_name>:Service.
The ReportServer:Service performance object is new in SQL Server 2008 Reporting Services, and it provides a subset of counters that were included with Internet Information Services (IIS) and ASP.NET in previous versions of Reporting
Services. These new counters are specific to Reporting Services, and they track HTTP-related events for the report server, such as requests, connections, and logon attempts. Additionally, this performance object includes counters to track memory management
events.
For more information about Performance Counters for the ReportServer:Service Performance Object, please see:
http://msdn.microsoft.com/en-us/library/cc627471.aspx
Thanks,
Challen FuChallen Fu [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
March 1st, 2011 1:30pm