This template uses Windows performance counters to assess the status and performance of Microsoft SQL Server 2016 Reporting Services.
Prerequisites: WMI access to the target server.
Credentials: Windows Administrator on the target server.
Portions of this document are based on the following sources:
https://docs.microsoft.com/en-us/sql/reporting-services/report-server/performance-counters-msrs-2011-web-service-performance-objects?view=sql-server-2016
https://docs.microsoft.com/en-us/sql/reporting-services/report-server/performance-counters-reportserver-service-performance-objects?view=sql-server-2016
MONITORED COMPONENTS
MSRS Windows Service: Active Sessions
This monitor returns the number of active sessions. This counter provides a cumulative count of all browser sessions generated from report executions, whether they are still active or not. The counter is decremented as session records are removed. By default, sessions are removed after ten minutes of no activity.
MSRS Windows Service: Cache Flushes/Sec
This monitor returns the number of cache flushes per second.
MSRS Windows Service: Cache Hits/Sec
This monitor returns the number of requests per second for cached reports. These are requests for re-rendered reports, not requests for reports processed directly from the cache.
MSRS Windows Service: Cache Hits/Sec (Semantic Models)
This monitor returns the number of requests per second for cached models. These are requests for re-rendered reports, not requests for reports processed directly from the cache.
MSRS Windows Service: Cache Misses/Sec
This monitor returns the 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.
MSRS Windows Service: Cache Misses/Sec (Semantic Models)
This monitor returns the 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.
MSRS Windows Service: Delivers/Sec
This monitor returns the number of report deliveries per second, from any delivery extension.
MSRS Windows Service: Events/Sec
This monitor returns the number of events processed per second. Events that are monitored include SnapshotUpdated and TimedSubscription.
MSRS Windows Service: Memory Cache Hits/Sec
This monitor returns the 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.
MSRS Windows Service: Memory Cache Miss/Sec
This monitor returns the number of times per second that reports could not be retrieved from the in-memory cache.
MSRS Windows Service: Reports Executed/Sec
This monitor returns the number of successful report executions per second. This counter provides statistics about report volume. Use this counter with Request/Sec to compare report execution to report requests that can be returned from cache.
MSRS Windows Service: Requests/Sec
This monitor returns the number of requests per second made to the report server. This counter tracks all types of requests that are handled by the report server.
MSRS Windows Service: Snapshot Updates/Sec
This monitor returns the total number of report execution snapshot updates per second.
MSRS Windows Service: Total Processing Failures
This monitor returns the number of errors in report server web service request processing.
Note: This counter has the Count statistic as difference option enabled and will show the statistical difference from the last polling cycle.
MSRS Windows Service: Total Rejected Threads
This monitor returns the total number of threads rejected for asynchronous processing, and subsequently handled as synchronous processes in the same thread. Each data source is processed on one thread. If the volume of threads exceeds capacity, threads are rejected for asynchronous processing, and are then processed in a serial manner.
Note: This counter has the Count statistic as difference option enabled and will show the statistical difference from the last polling cycle.
MSRS Windows Service: Report Requests
Number of reports that are currently active and managed by the report server.
MSRS Windows Service: First Session Requests/Sec
Number of new user sessions that are started from the report server cache each second.
MSRS Windows Service: 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).
MSRS Windows Service: Total App Domain Recycles
Total number of application domain cycles after the Report Server Windows service started.
MSRS Windows Service: 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.
MSRS Windows Service: 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. See Cache Hits/Sec.
MSRS Windows Service: 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. See Cache Hits/Sec.
MSRS Windows Service: 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. See Cache Misses/Sec.
MSRS Windows Service: 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.
MSRS Windows Service: Total Deliveries
Total number of reports delivered through the Scheduling and Delivery Processor, for all delivery extensions. This counter resets when the application domain recycles.
MSRS Windows Service: Total Events
Total number of events after the report server Windows service started. This counter resets when the application domain recycles.
MSRS Windows Service: 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.
MSRS Windows Service: 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.
MSRS Windows Service: Total Reports Executed
Total number of reports run.
MSRS Windows Service: Total Requests
Total number of reports that ran successfully after the service started. This counter resets when the application domain recycles.
MSRS Windows Service: Total Snapshot Updates
Total number of updates for report execution snapshots
Report Server: Active Connections
This monitor returns the number of connections currently active on the server.
Report Server: Bytes Received/sec
This monitor returns the number of bytes received per second by the server. This counter is updated only when a transfer is complete. This means that the counter remains at 0 and then the value increases after a transfer is complete.
Report Server: Bytes Sent/sec
This monitor returns the number of bytes sent per second from the server. This counter is updated only when a transfer is complete. This means that the counter remains at 0 and then the value increases after a transfer is complete.
Report Server: Errors/sec
This monitor returns the total number of errors that occur per second during the processing of HTTP requests. These errors include HTTP status codes in the 400s and 500s.
Report Server: Logon Attempts/sec
This monitor returns the rate of logon attempts.
Report Server: Logon Successes/sec
This monitor returns the rate of successful logons.
Report Server: Memory Pressure State
This monitor returns memory pressure state. One of the following numbers, from 1-5, which indicates the current memory state of the server:
1: No pressure
2: Low pressure
3: Medium pressure
4: High pressure
5: Exceeded pressure
Report Server: Memory Shrink Amount
This monitor returns the number of bytes that the server requested to shrink the memory in use.
Report Server: Memory Shrink Notifications/sec
This monitor returns the number of notifications that the server issued in the last second to shrink the memory in use. This value indicates how often the server experiences memory pressure.
Report Server: Requests Executing
This monitor returns the number of requests that are currently processing.
Report Server: Requests/sec
This monitor returns the number of requests that are processed per second. This value represents the current throughput of the application.
Report Server: Tasks Queued
This monitor returns the number of tasks that are waiting for a thread to become available for processing. Each request made to the report server corresponds to one or more tasks. This counter represents only the number of tasks that are ready for processing; it does not include the number of tasks that are currently running.
Service: SQL Server Reporting Services
This monitor returns CPU and memory usage of SQL Server Reporting Services. This service manages, executes, renders, schedules and delivers reports.
Report Server TCP Port
This component monitor tests the ability of a Report Server to accept incoming sessions. By default, it monitors TCP port 80.
Report Server: Bytes Received Total
The number of bytes received by the server. This counter counts the raw bytes received in total by both Report Manager and the report server.
Report Server: Bytes Sent Total
The number of bytes sent from the server. This counter counts the raw bytes sent in total by both Report Manager and the report server.
Report Server: Errors Total
The total number of errors that occur during the processing of HTTP requests. These errors include HTTP status codes in the 400s and 500s.
Report Server: Logon Attempts Total
The number of logon attempts made from RSWindows authentication types. RSWindows authentication types include RSWindowsNegotiate, RSWindowsNTLM, RSWindowsKerberos, and RSWindowsB asic. The value zero (0) represents Custom authentication.
Report Server: Logon Successes Total
The number of successful logons for RSWindows authentication types. RSWindows authentication types include RSWindowsNegotiate, RSWindowsNTLM, RSWindowsKerberos, and RSWindowsB asic. The value zero (0) represents Custom authentication.
Report Server: Requests Disconnected
The number of requests that are disconnected because of a communication failure.
Report Server: Requests Not Authorized
The number of requests that fail with an HTTP 401 status code.
Report Server: Requests Rejected
The total number of requests that were not processed because of insufficient server resources. This counter represents the number of requests that return a HTTP 503 status code, which indicates that the server is too busy.
Report Server: Requests Total
The total number of requests that are received by the report server service since startup. This counter counts requests that are sent to Report Manager and requests that are sent from Report Manager to the report server.
