BI performance counter: Total Memory Cache Hits – Windows service

Applies to

SSRS

Description

When a request for a report is received from the client, Report Server can either render the report using data from SQL Server, or retrieve the same copy of the report from a cache. 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 usually a high numeric number which is reset every time the Windows Service is restarted

Resolved by

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

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