BI performance counter: Active Sessions – Web service

Applies to

SSRS

Description

The Web Service provides two endpoints – one for report execution and another for report management. This performance counter monitors the active sessions accessed via the two endpoints. The counter is made up of total active sessions as well as inactive sessions. However, when a session has been idle for more than ten minutes, it is removed from the overall active session count.

Resolved by

DBAs, Server administrators, System administrators, Web administrators, Report developers

Suggested solutions

  1. Additional information regarding sessions can be queried from dbo.SessionsData in ReportingServerTempDB SQL Server database
  2. For details of historical sessions, query the dbo.ExecutionLog view in the ReportServer SQL Server database
  3. Check your network settings to ensure that users can connect to your Report Server instance

Additional research

SSRS Active Session Information
Report Server Web Service
Performance Counters for the MSRS 2011 Web Service and MSRS 2011 Windows Service Performance Objects (Native Mode)

 

To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.

⇐ Back to index