BI performance counter: Active Sessions – Windows service

Applies to

SSRS

Description

Windows Service has more features than the Web Service. For instance, features such as subscription, delivery and snapshots are all processed using Windows Service.

This counter keeps tracks of all Active Sessions relating to these features. Not surprisingly, this counter is likely to have higher values than Web Service Active Sessions as it supports several features. Likewise, the cumulative value is reset whenever the service is restarted.

Resolved by

DBAs, Network 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 about particular sessions, query the dbo.ExecutionLog view in the ReportServer SQL Server database

Additional research

Reporting Services Report Server
How to Monitor Active Sessions on IIS
SSRS Active Session Information

 

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