BI performance counter: Total Cache Misses – Web service

Applies to

SSRS

Description

This performance counter keeps track of all instances whereby a Web Service request is not successfully retrieved from a cache since the restart of the Web Service. This counter is cleared up whenever the Web Service is restarted.

Resolved by

DBAs, Server administrators, System administrators, Web administrators

Suggested solutions

  1. Allocate more memory (RAM)
  2. 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