Microsoft SQL Server 2014 Reporting Services (Monitoring, Native Mode)

Microsoft.SQLServer.2014.ReportingServices.Monitoring :: 7.0.7.0 (Management Pack)

Microsoft SQL Server 2014 Reporting Services (Monitoring, Native Mode) Management Pack enables the monitoring of Microsoft SQL Server 2014 Reporting Services (Monitoring, Native Mode).

• Show Management Pack XML
• Get Management Pack data in Excel format
• Microsoft.SQLServer.2014.ReportingServices.Monitoring.mpb

Management Pack Elements

DataSource Modules (5)

	DisplayName	ID	Isolation	Accessibility
	Data source all Instances are discovered	Microsoft.SQLServer.2014.ReportingServices.DataSource.AllInstancesAreDiscovered	Any	Internal
	Data source instance configuration	Microsoft.SQLServer.2014.ReportingServices.DataSource.InstanceConfiguration	Any	Internal
	Data source mapped instance performance data provider	Microsoft.SQLServer.2014.ReportingServices.DataSource.MappedInstancePerfomanceDataProvider	Any	Internal
	Data source memory	Microsoft.SQLServer.2014.ReportingServices.DataSource.Memory	Any	Internal
	Data source TSQL counters reporting service custom	Microsoft.SQLServer.2014.ReportingServices.DataSource.TSQLCountersReportingServiceCustom	Any	Internal

ProbeAction Modules (8)

	DisplayName	ID	Isolation	Accessibility
	Probe action all instances are discovered	Microsoft.SQLServer.2014.ReportingServices.ProbeAction.AllInstancesAreDiscovered	Any	Internal
	Probe action DB connection monitor	Microsoft.SQLServer.2014.ReportingServices.ProbeAction.DBConnectionMonitor	Any	Internal
	Probe action instance configuration	Microsoft.SQLServer.2014.ReportingServices.ProbeAction.InstanceConfiguration	Any	Internal
	Probe action memory	Microsoft.SQLServer.2014.ReportingServices.ProbeAction.Memory	Any	Internal
	Probe action performance data provider	Microsoft.SQLServer.2014.ReportingServices.ProbeAction.PerfomanceDataProvider	Any	Internal
	Probe action TSQL counters reporting service custom	Microsoft.SQLServer.2014.ReportingServices.ProbeAction.TSQLCountersReportingServiceCustom	Any	Internal
	Probe action web service accessible monitor	Microsoft.SQLServer.2014.ReportingServices.ProbeAction.WebServiceAccessibleMonitor	Any	Internal
	Probe action windows service state	Microsoft.SQLServer.2014.ReportingServices.ProbeAction.WindowsServiceState	Any	Internal

Unit Monitor Types (12)

	DisplayName	ID	Accessibility	Support Monitor Recalculate
	All deployment instances are discovered monitor type	Microsoft.SQLServer.2014.ReportingServices.MonitorType.Deployment.AllInstancesAreDiscovered	Internal	False
	SQL 2014 RS: Misconfigured data sources monitor type	Microsoft.SQLServer.2014.ReportingServices.MonitorType.DeploymentWatcher.MisconfiguredDataSources	Internal	False
	SQL 2014 RS: Number of failed report executions monitor type	Microsoft.SQLServer.2014.ReportingServices.MonitorType.DeploymentWatcher.NumberOfFailedReportExecutions	Internal	False
	Configuration Conflict with SQL Server monitor type	Microsoft.SQLServer.2014.ReportingServices.MonitorType.Instance.ConfigurationConflictWithSQLServer	Internal	False
	SQL 2014 RS: CPU Usage (\%) monitor type	Microsoft.SQLServer.2014.ReportingServices.MonitorType.Instance.CpuUsageByInstance	Internal	False
	DB Connection monitor type	Microsoft.SQLServer.2014.ReportingServices.MonitorType.Instance.DBConnectionMonitor	Internal	False
	Reporting Service Instance configuration monitor type	Microsoft.SQLServer.2014.ReportingServices.MonitorType.Instance.InstanceConfiguration	Internal	False
	Memory Usage by RS monitor type	Microsoft.SQLServer.2014.ReportingServices.MonitorType.Instance.MemoryUsageByInstance	Internal	False
	Memory Usage on the Server monitor type	Microsoft.SQLServer.2014.ReportingServices.MonitorType.Instance.MemoryUsageOnServer	Internal	False
	Reports execution instance failure status monitor type	Microsoft.SQLServer.2014.ReportingServices.MonitorType.Instance.ReportsExecutionFailure	Internal	False
	Web service accessible monitor type	Microsoft.SQLServer.2014.ReportingServices.MonitorType.Instance.WebServiceAccessibleMonitor	Internal	False
	Service Availability monitor type	Microsoft.SQLServer.2014.ReportingServices.MonitorType.Instance.WindowsServiceState	Internal	False

Dependency Monitors (12)

	DisplayName	ID	Target	Algorithm	Source Monitor	Relationship	Category	Enabled	Alert Generate	Accessibility
	Database Availability (rollup)	Microsoft.SQLServer.2014.ReportingService.DependencyMonitor.Deployment.DatabaseAvailabilityRollup	Microsoft.SQLServer.2014.ReportingServices.Deployment	WorstOf	System.Health.AvailabilityState	Microsoft.SQLServer.2014.ReportingServices.Relations.DeploymentContainDB	AvailabilityHealth	True	False	Public
	Database Configuration (rollup)	Microsoft.SQLServer.2014.ReportingService.DependencyMonitor.Deployment.DatabaseConfigurationRollup	Microsoft.SQLServer.2014.ReportingServices.Deployment	WorstOf	System.Health.ConfigurationState	Microsoft.SQLServer.2014.ReportingServices.Relations.DeploymentContainDB	ConfigurationHealth	True	False	Public
	Database Performance (rollup)	Microsoft.SQLServer.2014.ReportingService.DependencyMonitor.Deployment.DatabasePerformanceRollup	Microsoft.SQLServer.2014.ReportingServices.Deployment	WorstOf	System.Health.PerformanceState	Microsoft.SQLServer.2014.ReportingServices.Relations.DeploymentContainDB	PerformanceCollection	True	False	Public
	Database Security (rollup)	Microsoft.SQLServer.2014.ReportingService.DependencyMonitor.Deployment.DatabaseSecurityRollup	Microsoft.SQLServer.2014.ReportingServices.Deployment	WorstOf	System.Health.SecurityState	Microsoft.SQLServer.2014.ReportingServices.Relations.DeploymentContainDB	SecurityHealth	True	False	Public
	Deployment Watcher Availability (rollup)	Microsoft.SQLServer.2014.ReportingService.DependencyMonitor.Deployment.DeploymentWatcherAvailabilityRollup	Microsoft.SQLServer.2014.ReportingServices.Deployment	WorstOf	System.Health.AvailabilityState	Microsoft.SQLServer.2014.ReportingServices.Relations.DeploymentReferenceDeploymentWatcher	AvailabilityHealth	True	False	Public
	Deployment Watcher Configuration (rollup)	Microsoft.SQLServer.2014.ReportingService.DependencyMonitor.Deployment.DeploymentWatcherConfigurationRollup	Microsoft.SQLServer.2014.ReportingServices.Deployment	WorstOf	System.Health.ConfigurationState	Microsoft.SQLServer.2014.ReportingServices.Relations.DeploymentReferenceDeploymentWatcher	ConfigurationHealth	True	False	Public
	Deployment Watcher Performance (rollup)	Microsoft.SQLServer.2014.ReportingService.DependencyMonitor.Deployment.DeploymentWatcherPerformanceRollup	Microsoft.SQLServer.2014.ReportingServices.Deployment	WorstOf	System.Health.PerformanceState	Microsoft.SQLServer.2014.ReportingServices.Relations.DeploymentReferenceDeploymentWatcher	PerformanceCollection	True	False	Public
	Deployment Watcher Security (rollup)	Microsoft.SQLServer.2014.ReportingService.DependencyMonitor.Deployment.DeploymentWatcherSecurityRollup	Microsoft.SQLServer.2014.ReportingServices.Deployment	WorstOf	System.Health.SecurityState	Microsoft.SQLServer.2014.ReportingServices.Relations.DeploymentReferenceDeploymentWatcher	SecurityHealth	True	False	Public
	Instance Availability (rollup)	Microsoft.SQLServer.2014.ReportingService.DependencyMonitor.Deployment.RSInstanceAvailabilityRollup	Microsoft.SQLServer.2014.ReportingServices.Deployment	Percentage	System.Health.AvailabilityState	Microsoft.SQLServer.2014.ReportingServices.Relations.DeploymentContainRSInstance	AvailabilityHealth	True	False	Public
	Instance Configuration (rollup)	Microsoft.SQLServer.2014.ReportingService.DependencyMonitor.Deployment.RSInstanceConfigurationRollup	Microsoft.SQLServer.2014.ReportingServices.Deployment	Percentage	System.Health.ConfigurationState	Microsoft.SQLServer.2014.ReportingServices.Relations.DeploymentContainRSInstance	ConfigurationHealth	True	False	Public
	Instance Performance (rollup)	Microsoft.SQLServer.2014.ReportingService.DependencyMonitor.Deployment.RSInstancePerformanceRollup	Microsoft.SQLServer.2014.ReportingServices.Deployment	Percentage	System.Health.PerformanceState	Microsoft.SQLServer.2014.ReportingServices.Relations.DeploymentContainRSInstance	PerformanceCollection	True	False	Public
	Instance Security (rollup)	Microsoft.SQLServer.2014.ReportingService.DependencyMonitor.Deployment.RSInstanceSecurityRollup	Microsoft.SQLServer.2014.ReportingServices.Deployment	Percentage	System.Health.SecurityState	Microsoft.SQLServer.2014.ReportingServices.Relations.DeploymentContainRSInstance	SecurityHealth	True	False	Public

Unit Monitors (16)

	DisplayName	ID	Target	Category	Enabled	Alert Generate	Accessibility
	All deployment instances are discovered	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.Deployment.AllInstancesAreDiscovered	Microsoft.SQLServer.2014.ReportingServices.Deployment	ConfigurationHealth	True	True	Public
	Database accessible	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.DeploymentWatcher.DBConnection	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	PerformanceHealth	True	True	Public
	Misconfigured data sources	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.DeploymentWatcher.MisconfiguredDataSources	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	ConfigurationHealth	True	True	Public
	Number of failed report executions	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.DeploymentWatcher.NumberOfFailedReportExecutions	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	PerformanceHealth	True	True	Public
	Temporary database accessible	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.DeploymentWatcher.TempDBConnection	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	PerformanceHealth	True	True	Public
	Configuration conflict with SQL Server	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.Instance.ConfigurationConflictWithSQLServer	Microsoft.SQLServer.2014.ReportingServices.Instance	ConfigurationHealth	False	True	Public
	CPU utilization (\%)	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.Instance.CpuUsageByInstance	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceHealth	True	True	Public
	Database accessible	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.Instance.DBConnection	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceHealth	False	True	Public
	Instance configuration state	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.Instance.InstanceConfiguration	Microsoft.SQLServer.2014.ReportingServices.Instance	ConfigurationHealth	False	True	Public
	Memory consumed by SSRS Instance	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.Instance.MemoryUsageByInstance	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceHealth	True	True	Public
	Memory consumed by others	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.Instance.MemoryUsageOnServer	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceHealth	True	True	Public
	Number of failed report executions	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.Instance.ReportsExecutionFailure	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceHealth	False	True	Public
	Report manager accessible	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.Instance.SsrsReportManagerAccessible	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceHealth	True	True	Public
	Web service accessible	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.Instance.SsrsWebServiceAccessible	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceHealth	True	True	Public
	Temporary database accessible	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.Instance.TempDBConnection	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceHealth	False	True	Public
	Windows service state	Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.WindowsServiceState	Microsoft.SQLServer.2014.ReportingServices.Instance	AvailabilityHealth	True	True	Public

Rules (19)

	DisplayName	ID	Target	Category	Enabled	Alert Generate
	SSRS 2014: An error occurred during execution of a SSRS 2014 MP managed module	Microsoft.SQLServer.2014.ReportingServices.AlertRule.Seed.ModuleError	Microsoft.SQLServer.2014.ReportingServices.Seed	Alert	True	True
	SSRS 2014: Failed report executions per minute (Deployment)	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.DeploymentWatcher.CountOfFailedReportExecutions	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	PerformanceCollection	True	False
	SSRS 2014: Report executions per minute (Deployment)	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.DeploymentWatcher.CountOfReportExecutions	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	PerformanceCollection	True	False
	SSRS 2014: Number of reports	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.DeploymentWatcher.NumberOfReports	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	PerformanceCollection	True	False
	SSRS 2014: Number of shared data sources	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.DeploymentWatcher.NumberOfSharedDataSources	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	PerformanceCollection	True	False
	SSRS 2014: Number of subscriptions	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.DeploymentWatcher.NumberOfSubscriptions	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	PerformanceCollection	True	False
	SSRS 2014: On-demand execution failures per minute	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.DeploymentWatcher.OnDemandExecutionFailures	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	PerformanceCollection	True	False
	SSRS 2014: On-demand executions per minute	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.DeploymentWatcher.OnDemandExecutions	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	PerformanceCollection	True	False
	SSRS 2014: Scheduled execution failures per minute	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.DeploymentWatcher.ScheduledExecutionFailures	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	PerformanceCollection	True	False
	SSRS 2014: Scheduled executions per minute	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.DeploymentWatcher.ScheduledExecutions	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher	PerformanceCollection	True	False
	SSRS 2014: Report executions per minute	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.Instance.CountOfExecution	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceCollection	True	False
	SSRS 2014: Failed report executions per minute	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.Instance.CountOfFailedExecution	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceCollection	True	False
	SSRS 2014: CPU utilization (\%)	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.Instance.CPUUsageByInstance	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceCollection	True	False
	SSRS 2014: WorkingSetMaximum (GB)	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.Instance.HighMemoryLimit	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceCollection	True	False
	SSRS 2014: WorkingSetMinimum (GB)	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.Instance.LowMemoryLimit	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceCollection	True	False
	SSRS 2014: Memory consumed by SSRS (GB)	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.Instance.MemoryUsageByInstance	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceCollection	True	False
	SSRS 2014: Memory consumed by other processes (\%)	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.Instance.MemoryUsageByOtherProcess	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceCollection	True	False
	SSRS 2014: Total memory consumed on the server (GB)	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.Instance.MemoryUsedOnServer	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceCollection	True	False
	SSRS 2014: Total memory on the Server (GB)	Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.Instance.TotalMemory	Microsoft.SQLServer.2014.ReportingServices.Instance	PerformanceCollection	True	False

Deployable Assemblies (1)

	ID	File Name	Accessibility
	Microsoft.SQLServer.2014.ReportingServices.Monitoring.Assembly	Microsoft.SQLServer.2014.ReportingServices.Module.Monitoring.dll	Public