Export (0) Print
Expand All

Performance Counters for Report Server

SQL Server 2000

The Reporting Services performance object includes the following report server counters.

Counter Description
Active Sessions Number of active sessions. This counter provides a count of all browser sessions.
Cache Hits/Sec Number of requests per second for cached reports.
Cache Misses/Sec Number of requests per second that failed to return a report from cache. Use this counter to find out whether the resources used for caching (disk or memory) are sufficient.
First Session Requests/Sec Number of new user sessions that are started from the report server cache each second.
Memory Cache Hits/Sec Number of times per second that reports were retrieved from the in-memory cache. In-memory cache is a part of the cache that stores reports in CPU memory. When in-memory cache is used, the report server does not query SQL Server for cached content.
Memory Cache Misses/Sec Number of times per second that reports could not be retrieved from the in-memory cache.
Next Session Requests/Sec Number of requests per second for reports that are open in an existing session.
Report Requests Number of reports that are currently active and being handled by the report server.
Reports Executed/Sec Number of successful report executions per second. This counter provides statistics on report volume. Use this counter with Request/Sec to compare execution to report requests that can be returned from cache.
Requests/Sec Number of requests per second made to the report server. This counter tracks all types of requests that are handled by the report server.
Total Cache Hits Total number of requests for reports from cache since the service started. This counter is reset whenever ASP.NET stops the Web service.
Total Cache Misses Total number of times that a report could not be returned from cache since the service started. This counter is reset whenever ASP.NET stops the Web service. Use this counter to determine whether disk space and memory are sufficient.
Total Memory Cache Hits Total number of cached reports that were returned from the in-memory cache since the service started. This counter is reset whenever ASP.NET stops the Web service. In-memory cache is a part of the cache that stores reports in CPU memory. When in-memory cache is used, the report server does not query SQL Server for cached content.
Total Memory Cache Misses Total number of cache misses against the in-memory cache since the service started. This counter is reset whenever ASP.NET stops the Web service.
Total Processing Failures Total number of report processing failures that have occurred since the service started. This counter is reset whenever ASP.NET stops the Web service. Processing failures can originate from the report processor or any extension.
Total Rejected Threads Total number of data processing threads rejected for asynchronous processing, and subsequently handled as a synchronous process in the same thread. Each data source is processed on one thread. If the volume of threads exceeds capacity, threads will be rejected for asynchronous processing, and will be processed in a serial manner.
Total Reports Executed Total number of reports that executed successfully since the service started. This counter is reset whenever ASP.NET stops the Web service.
Total Requests Total number of all requests made to the report server since the service started. This counter is reset whenever ASP.NET stops the Web service.

See Also

Monitoring Performance

Performance Counters for Scheduling and Delivery Processor

Show:
© 2015 Microsoft