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 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 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
