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
- Consider adding more memory into your web server
- 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
