BI performance counter: Total Memory Cache Hits – Web service

Applies to

SSRS

Description

This counter monitors all reports that were retrieved directly from CPU in-memory without querying SQL Server’s report cache. This method of rendering a report is very fast as it avoids unnecessary SQL Server database roundtrips. The value returned is a numeric whole number which is reset every time the Report Server Windows Service is restarted.

Resolved by

DBAs, Server administrators, System administrators, Web administrators

Suggested solutions

  1. Consider adding more memory into your web server
  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
Monitoring and Performance Tuning

 

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