• Management Pack:  SQL Server Reporting Services
  • MP Version:  6.7.31.0 for SQL Server 2016 Reporting Services
  • Released:  6/27/2017
  • Publisher:  Microsoft

SSRS 2016 Deployment Class

  • ID:  Microsoft.SQLServer.2016.ReportingServices.Deployment
  • Description:  Reporting Services (native mode) support a scale-out deployment model that allows running multiple report server instances that share a single report server database. Scale-out deployments are used to increase scalability of report servers to handle more concurrent users and larger report execution loads. It can also be used to dedicate specific servers to process interactive or scheduled reports.
  • Class Hierarchy: 
    Object
    SSRS 2016 Deployment

  • Attributes:  Public, Non-Hosted
Login
The monitor raises an alert, if not all SSRS Instances are discovered for the given SSRS Deployment. The monitor changes its state and raises an alert, if the deployment watcher fails to connect to Reporting Services Database The monitor raises an alert, if the deployment watcher fails to connect to Reporting Services Temporary Database. The monitor alerts, if misconfigured data sources are detected. The monitor alerts, if the number of failed report executions expressed as a percentage of total number of report executions is higher than the threshold. The monitor will raise an alert and change its state only when several consecutive checks have failed. The monitor raises an alert, if monitoring workflow cannot connect to SSRS Report Manager The monitor raises an alert, if monitoring workflow cannot connect to SSRS web service. The monitor alerts, if SSRS Windows service is not in running state for a longer period than the threshold. The monitor raises an alert, if the monitoring workflow cannot access the Reporting Services Database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. The monitor raises an alert, if the instance failed to connect to Reporting Services Temporary Database. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. The monitor alerts, if there is a SQL Server process running on the server, and WorkingSetMaximum setting for the SSRS Instance does not allow enough memory for the SQL server process. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. The monitor raises an alert, if SSRS instance has certain configuration problems. The monitor alerts, if the CPU usage by the SSRS process is close to 100%. The monitor alerts, if the memory consumed by processes other than SSRS does not allow SSRS to allocate the amount of memory prescribed by WorkingSetMinimum setting. The monitor uses the following formula to determine the state: ({WorkingSetMinimum} + {Memory Consumed By Others})*100/{Total Memory} < {Threshold (%)} The monitor alerts, if the memory usage by the SSRS process is close to the limit defined by WorkingSetMaximum setting. The monitor checks, if the number of failed report executions per minute does not exceed the threshold expressed as an absolute value. The monitor will raise an alert and change its state only when several consecutive checks have failed. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. Reporting Services (native mode) support a scale-out deployment model that allows running multiple report server instances that share a single report server database. Scale-out deployments are used to increase scalability of report servers to handle more concurrent users and larger report execution loads. It can also be used to dedicate specific servers to process interactive or scheduled reports. Deployment Watcher is a hidden object, which is used as a target to run monitoring workflows for Deployment object. Deployment Watcher is an unhosted object. The server hosting SSRS Catalog Database is used to manage this object. If the server hosting the database has no agent installed, then one of SSRS servers will take responsibility of running the respective workflows. Microsoft SQL Server 2016 Reporting Services (Native Mode)

Download diagram as a Visio file

Properties

Display Name Description
Catalog Database  
Database Instance  
Database Server  
Deployment Name (Key)  
Display Name Display name of the object.
SSRS Instances  
Temp Database  

Discovered By

Name Description
SSRS 2016: Native Mode Deployment Discovery This rule discovers all instances of SSRS 2016 Native Mode Deployments.

Relations

Health Source
NameClassType
Deployment Contains SSRS Instance SSRS 2016 Deployment Membership
Deployment Contains SQL DB SSRS 2016 Deployment Membership
Deployment Reference Deployment Watcher SSRS 2016 Deployment Reference
Entity Watched By Perspective Object Reference

Health Target

This class does not contain health targets.

Class Knowledgebase

Summary

Deployment object provides information on scale-out deployments by listing the servers connected to the Reporting Services catalog database. Scale-out deployments are used to increase scalability of report servers to handle more concurrent users and larger report execution loads. It can also be used to dedicate specific servers to process interactive or scheduled reports. More information can be found at Configure a Native Mode Report Server Scale-Out Deployment page. This will list the SQL Server name hosting the Reporting Services catalog database, the SQL Server instance name hosting the Reporting Services catalog database, the Reporting Services catalog database name, the Reporting Services temp database name, and the Reporting Services instances connected in the scale-out deployment.

External References
This class does not contain any external references.

See Also for SQL Server Reporting Services Management Pack


Downloads for SQL Server Reporting Services Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED