BI performance counter: Active Connections

Applies to

SSRS

Description

This performance counter measures the total number of simultaneous connections at a given time. The value of this counter is the sum of both active running and queued tasks and it will fluctuate as connections are opened or closed. This value is measured as numeric whole number that is reset whenever the service is restarted.

Resolved by

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

Suggested solutions

  1. You specify the maximum number of simultaneous and in-progress connections that a single user can open to the Report Server by editing MaxActiveReqForOneUser property in the RSReportServer.config file
  2. Ensure that you have a healthy Report Server with adequate hard drive space and RAM
  3. Check your network settings to ensure that users can connect to your Report Server instance

Additional research

Limit the active number of connections within Reporting Service
SSRS Error: Exceeding Maximum Requests for One User
SQL Report Server ERROR: The number of requests for domain\jermsmit has exceeded the maximum number allowed for a single user

 

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