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

Microsoft.SQLServer.2014.ReportingServices.Monitoring :: 6.6.7.6 (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).

Summary

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

Management Pack Elements

Show Management Pack References

TypeDefinitions

ModuleTypes

DataSourceModuleType (5)
ProbeActionModuleType (8)

UnitMonitorType (12)

Monitoring

Monitors

DependencyMonitor (12)
UnitMonitor (16)

Rule (19)

Resources

DeployableAssembly (1)

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