BI performance counter: Total Cache Hits – Windows service

Applies to

SSRS

Description

Like many windows applications, SSRS report can cache a copy of a processed report. This counter monitors the number of times that the report is retrieved from a memory cache instead of connecting to the database. Instances such as processing a scheduled subscription from a cache are tracked by this performance counter. Stopping of the Windows Service causes counter to be reset back to 0.

Resolved by

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

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