Index/DBAmon Doc. |
DBAmon monitors SSRS (Microsoft SQL Server Reporting Server) as follows:
SSRS provides Windows Performance Counters to provide performance information about
an instance of SSRS. DBAmon collects data from these counters and instantiates the
readings as DBAmon PERF_SSRS_* Performance Metrics.
Here is a good MS WWW page describing
SSRS Performance Counters.
As with all DBAmon Performance Metrics, you can set thresholds with which will you will be notified
|SSRS Windows Performance Counter||DBAmon Performance Metrics
||\ReportServer:Service\Memory Pressure State||PERF_SSRS_Mem_Pressure_State
||\ReportServer:Service\Memory Shrink Amount||PERF_SSRS_Mem_Shrink_Bytes
||\ReportServer:Service\Requests Not Authorized||PERF_SSRS_Reqs_AuthFail
Two metrics that appear to be particuarly interesting are PERF_SSRS_Mem_Pressure_State and PERF_SSRS_Tasks_Queued. If PERF_SSRS_MEM_Pressure_State is > 0, then this SSRS instance is under memory pressure (see the above URL for details). If PERF_SSRS_Tasks_Queued is > 0, then tasks are queued.
SSRS also provides a view called ExecutionLog2 which is a log of SSRS requests. Here is a good Description of ExecutionLog2. DBAmon collects the 20 most recent rows from this view on every iteration and saves this in the WWW "Drilldown" data. It is not saved historically.