Performance Counters for the MSRS 2008 R2 Windows Service Performance Object
This topic describes performance counters for the MSRS 2008 R2 Windows Service that is part of a SQL Server 2008 R2 Reporting Services deployment.
Note
This performance object is used to monitor events on the local report server. If you are running a report server in a scale-out deployment, the counts apply to the current server and not the scale-out deployment as a whole.
Performance objects are available in the Windows Performance Console (in Windows 2000 Server and Windows Server 2003) and in the Windows Reliability and Performance Console (in Windows Vista and Windows Server 2008). For more information, see your Microsoft Windows documentation.
MSRS 2008 R2 Windows Service Performance Counters
The MSRS 2008 R2 Windows Service performance object is used to monitor the Report Server Windows service. This performance object includes a collection of counters used to track report processing that is initiated through scheduled operations. Scheduled operations can include subscription and delivery, report execution snapshots, and report history. When you set up this counter, you can apply the counter to all instances of Reporting Services or you can select specific instances.
The following table lists the counters that are included in the MSRS 2008 R2 Windows Service performance object.
Counter |
Description |
|---|---|
Active Sessions |
Number of active sessions stored in the report server database. This counter provides a cumulative count of all usable browser sessions generated from report subscriptions, whether they are still active or not. |
Cache Flushes/Sec |
Number of cache flushes per second. |
Cache Hits/Sec |
Number of requests per second for cached reports. These are requests for re-rendered reports, not requests for reports processed directly from the cache. |
Cache Hits/Sec (Semantic Models) |
Number of requests per second for cached models. |
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. |
Cache Misses/Sec (Semantic Models) |
Number of requests per second that failed to return a model from cache. Use this counter to find out whether the resources used for caching (disk or memory) are sufficient. |
Delivers/Sec |
Number of report deliveries per second, from any delivery extension. |
Events/Sec |
Number of events processed per second. Events that are monitored include SnapshotUpdated and TimedSubscription. |
First Session Requests/Sec |
Number of new report execution sessions created per second. |
Memory Cache Hits/Sec |
Number of times per second that reports are 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 cannot 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 (such as reports that are rendered from a session snapshot). |
Report Requests |
Number of reports that are currently active and being handled by the report server. Use this counter to evaluate caching strategy. There might be significantly more requests than reports generated. |
Reports Executed/Sec |
Number of reports successfully generated per second. |
Requests/Sec |
Total Number of successful requests the report sever service processed per second. |
Snapshot Updates/Sec |
Total number of report execution snapshot updates per second. |
Total App Domain Recycles |
Total number of application domain cycles after the Report Server Windows service started. |
Total Cache Flushes |
Total number of report server cache updates after the service started. This counter resets when the application domain recycles. See Cache Flushes/Sec. |
Total Cache Hits |
Total number of requests for reports processed directly from the cache after the Report Server Windows service started. This counter resets when the application domain recycles. |
Total Cache Hits (Semantic Models) |
Total number of requests for models processed directly from the cache after the Report Server Windows service started. This counter resets when the application domain recycles. |
Total Cache Misses |
Total number of times that a report could not be returned from cache after the Report Server Windows service started. This counter resets when the application domain recycles. |
Total Cache Misses (Semantic Models) |
Total number of times that a model could not be returned from cache after the Report Server Windows service started. This counter resets when the application domain recycles. |
Total Deliveries |
Total number of reports delivered by the Scheduling and Delivery Processor, for all delivery extensions. This counter resets when the application domain recycles. |
Total Events |
Total number of events after the Report Server Windows service started. This counter resets when the application domain recycles. |
Total Memory Cache Hits |
Total number of cached reports returned from the in-memory cache after the Report Server Windows service started. This counter resets when the application domain recycles. |
Total Memory Cache Misses |
Total number of cache misses against the in-memory cache after the service started. This counter resets when the application domain recycles. |
Total Processing Failures |
Number of errors in report server windows service request processing. |
Total Rejected Threads |
Total number of threads rejected for asynchronous processing, and subsequently handled as a synchronous process in the same thread. Under moderate or heavy load, this counter steadily increases. |
Total Reports Executed |
Total number of reports run. |
Total Requests |
Total number of reports that ran successfully after the service started. This counter resets when the application domain recycles. |
TotalSnapshot Updates |
Total number of report execution snapshot updates. |