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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics