BI performance counter: Total Requests – Web service

Applies to

SSRS

Description

This counter is similar to Total Reports Executed performance counter except that it monitors all requests regardless of whether they were successful or not since the service restart. The value of this performance counter is reset whenever Report Server Web Service is stopped by ASP.NET.

Resolved by

DBAs, Server administrators, System administrators, Web administrators, Network administrators

Suggested solutions

  1. Check the Reporting Services error log file
  2. Modify the ReportingServicesService.exe configuration file to enable HTTP Logging
  3. Allocate more memory (RAM)
  4. For a record of every HTTP requests handled by Report Server, you can go through the log files which is usually located as \Microsoft SQL Server\\Reporting Services\LogFiles

Additional research

Reporting Services Report Server
Report Server HTTP Log
Troubleshoot Processing of Reporting Services Reports

 

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