BI performance counter: Total Cache Hits – Web service

Applies to

SSRS

Description

This counter monitors the number of times that activities originating from report execution and report management endpoints are retrieved from a memory cache instead of querying SQL Server. Stopping the Web Service causes this performance counter to be reset back to 0.

Resolved by

DBAs, Server administrators, System administrators, Web administrators

Suggested solutions

  1. Increase the amount of memory that is allocated
  2. Configure duration of the cache in report properties
  3. If you require a more predictable caching strategy, you should create a report snapshot

Additional research

Reporting Services Report Server
Create, Modify, and Delete Snapshots in Report History
Caching Reports (SSRS)

 

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