Microsoft SQL Server 2014 Mirroring (Monitoring)

Microsoft.SQLServer.2014.Mirroring.Monitoring :: 6.7.2.0 (Management Pack)

Microsoft SQL Server 2014 Mirroring Monitoring Management Pack. This Management Pack provides monitoring capabilities for Microsoft SQL Server 2014 Mirroring. The management pack only contains the monitoring logic and requires the separate discovery management pack to be imported to discover objects.

Summary

The SQL Server 2014 Mirroring (Monitoring) Management Pack provides the SQL Server 2014 mirroring services specific monitoring functionality. It requires the SQL Server 2014 Mirroring (Discovery) Management Pack.

Management Pack Elements

Show Management Pack References

TypeDefinitions

ModuleTypes

DataSourceModuleType (2)

UnitMonitorType (2)

Monitoring

Monitors

DependencyMonitor (5)
UnitMonitor (3)

DataSource Modules (2)

	DisplayName	ID	Isolation	Accessibility
	Microsoft SQL Server 2014 Mirroring Scripted State Provider	Microsoft.SQLServer.2014.Mirroring.ScriptedStateProvider	Any	Internal
	Microsoft SQL Server 2014 Mirroring Scripted State Provider (with two level of Host Tcp param)	Microsoft.SQLServer.2014.Mirroring.ScriptedStateProviderTwoLevelHostTcp	Any	Internal

Unit Monitor Types (2)

	DisplayName	ID	Accessibility	Support Monitor Recalculate
	MSSQL 2014: Mirroring Scripted Three State Unit Monitor Type	Microsoft.SQLServer.2014.Mirroring.ScriptedThreeStateType	Internal	False
	MSSQL 2014: Mirroring Scripted Two State Unit Monitor Type	Microsoft.SQLServer.2014.Mirroring.ScriptedTwoStateType	Internal	False

Dependency Monitors (5)

DisplayName	ID	Target	Algorithm	Source Monitor	Relationship	Category	Enabled	Alert Generate	Accessibility
Mirrored Database Availability Rollup	Microsoft.SQLServer.2014.Mirroring.DatabaseToGroupAvailabilityRollup	Microsoft.SQLServer.2014.Mirroring.Group	WorstOf	System.Health.AvailabilityState	Microsoft.SQLServer.2014.Mirroring.GroupContainsDatabase	AvailabilityHealth	True	False	Public
Mirrored Database Configuration Rollup	Microsoft.SQLServer.2014.Mirroring.DatabaseToGroupConfigurationRollup	Microsoft.SQLServer.2014.Mirroring.Group	WorstOf	System.Health.ConfigurationState	Microsoft.SQLServer.2014.Mirroring.GroupContainsDatabase	ConfigurationHealth	True	False	Public
Mirrored Database Performance Rollup	Microsoft.SQLServer.2014.Mirroring.DatabaseToGroupPerformanceRollup	Microsoft.SQLServer.2014.Mirroring.Group	WorstOf	System.Health.PerformanceState	Microsoft.SQLServer.2014.Mirroring.GroupContainsDatabase	PerformanceHealth	True	False	Public
Mirroring Witness Availability Rollup	Microsoft.SQLServer.2014.Mirroring.WitnessToGroupAvailabilityRollup	Microsoft.SQLServer.2014.Mirroring.Group	WorstOf	System.Health.AvailabilityState	Microsoft.SQLServer.2014.Mirroring.GroupContainsWitness	AvailabilityHealth	True	False	Public
Mirroring Witness Availability Rollup	Microsoft.SQLServer.2014.Mirroring.WitnessToWitnessRoleAvailabilityRollup	Microsoft.SQLServer.2014.Mirroring.WitnessRole	WorstOf	System.Health.AvailabilityState	Microsoft.SQLServer.2014.Mirroring.WitnessRoleHostsWitness	AvailabilityHealth	True	False	Public

Unit Monitors (3)

DisplayName	ID	Target	Category	Enabled	Alert Generate	Accessibility
Database Mirror Status	Microsoft.SQLServer.2014.Mirroring.DatabaseStateMonitor	Microsoft.SQLServer.2014.Mirroring.Database	AvailabilityHealth	True	True	Public
Database Mirroring Partners Status	Microsoft.SQLServer.2014.Mirroring.PartnersStateMonitor	Microsoft.SQLServer.2014.Mirroring.Witness	AvailabilityHealth	True	True	Public
Database Mirror Witness Status	Microsoft.SQLServer.2014.Mirroring.WitnessStateMonitor	Microsoft.SQLServer.2014.Mirroring.Database	AvailabilityHealth	True	True	Public