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
- Increase the amount of memory that is allocated
- Configure duration of the cache in report properties
- 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)