Microsoft SQL Server 2014 Always On (Discovery)

Microsoft.SQLServer.2014.AlwaysOn.Discovery :: 7.0.2.0 (Management Pack)

This Management Pack discovers objects required for monitoring of Microsoft SQL Server 2014 Always On functionality. It contains only discovery logic and requires the separate monitoring management pack to be imported to enable monitoring.

Management Pack Elements

Show Management Pack References

TypeDefinitions

EntityTypes

ClassType (14)
RelationshipType (17)

ModuleTypes

DataSourceModuleType (3)

SecureReference (1)

Monitoring

Discovery (4)
Rule (1)

Presentation

ImageReference (4)

Resources

Image (8)

Classes (14)

System.Entity

System.LogicalEntity

System.ApplicationComponent

Microsoft.Windows.ApplicationComponent

Microsoft.SQLServer.2014.Component

Microsoft.SQLServer.2014.AlwaysOn.Policy

System.LocalApplication

Microsoft.Windows.LocalApplication

Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeed

Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabase
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup

	DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
	MSSQL 2014: Always On Seed	Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeed	Microsoft.Windows.LocalApplication	False	True	False	False	False	Public
	MSSQL 2014: Availability Database	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabase	System.Entity	False	True	False	False	False	Public
	MSSQL 2014: Availability Database Health	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseHealth	Microsoft.SQLServer.2014.Component	False	True	False	False	False	Public
	MSSQL 2014: Availability Group	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	System.Entity	False	False	False	False	False	Public
	MSSQL 2014: Availability Group Critical Policy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorUserPolicy	Microsoft.SQLServer.2014.AlwaysOn.Policy	False	True	False	False	False	Public
	MSSQL 2014: Availability Group Health	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	Microsoft.SQLServer.2014.Component	False	True	False	False	False	Public
	MSSQL 2014: Availability Group Warning Policy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningUserPolicy	Microsoft.SQLServer.2014.AlwaysOn.Policy	False	True	False	False	False	Public
	MSSQL 2014: Availability Replica	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	Microsoft.SQLServer.2014.Component	False	True	False	False	False	Public
	MSSQL 2014: Availability Replica Critical Policy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorUserPolicy	Microsoft.SQLServer.2014.AlwaysOn.Policy	False	True	False	False	False	Public
	MSSQL 2014: Availability Replica Warning Policy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningUserPolicy	Microsoft.SQLServer.2014.AlwaysOn.Policy	False	True	False	False	False	Public
	MSSQL 2014: Database Replica	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	Microsoft.SQLServer.2014.Component	False	True	False	False	False	Public
	MSSQL 2014: Database Replica Critical Policy	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorUserPolicy	Microsoft.SQLServer.2014.AlwaysOn.Policy	False	True	False	False	False	Public
	MSSQL 2014: Database Replica Warning Policy	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningUserPolicy	Microsoft.SQLServer.2014.AlwaysOn.Policy	False	True	False	False	False	Public
	MSSQL 2014: Always On Custom User Policy	Microsoft.SQLServer.2014.AlwaysOn.Policy	Microsoft.SQLServer.2014.Component	True	False	False	False	False	Public

Relationship Types (17)

	DisplayName	ID	Source	Target	Accessibility	Abstract
	Availability Group contains Database Replica	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseContainsDatabaseReplica	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabase	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	Public	False
	Availability Database references Availability Database Health	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseReferencesAvailabilityDatabaseHealth	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabase	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseHealth	Public	False
	Availability Group contains Availability Replica	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupContainsAvailabilityReplica	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	Public	False
	Availability Group Health contains Availability Replicas	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthContainsAvailabilityReplicas	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	Public	False
	Availability Group Health hosts Availability Database Health	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsAvailabilityDatabaseHealth	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseHealth	Public	False
	Availability Group hosts Error User Policy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsErrorUserPolicy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorUserPolicy	Public	False
	Availability Group hosts Warning User Policy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsWarningUserPolicy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningUserPolicy	Public	False
	Availability Group hosts Availability Database	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHostsAvailabilityDatabase	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabase	Public	False
	Availability Group references Availability Group Health	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealth	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	Public	False
	Availability Group contains Database Replicas	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaContainsDatabaseReplicas	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	Public	False
	Availability Replica hosts Error User Policy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaHostsErrorUserPolicy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorUserPolicy	Public	False
	Availability Replica hosts Warning User Policy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaHostsWarningUserPolicy	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningUserPolicy	Public	False
	Computer Hosts Availability Group Health	Microsoft.SQLServer.2014.AlwaysOn.ComputerHostsAvailabilityGroupHealth	Microsoft.Windows.Computer	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	Public	False
	Computer hosts Availability Replica	Microsoft.SQLServer.2014.AlwaysOn.ComputerHostsAvailabilityReplica	Microsoft.Windows.Computer	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	Public	False
	Computer hosts Database Replica	Microsoft.SQLServer.2014.AlwaysOn.ComputerHostsDatabaseReplica	Microsoft.Windows.Computer	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	Public	False
	Database Replica hosts Error User Policy	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaHostsErrorUserPolicy	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorUserPolicy	Public	False
	Database Replica hosts Warning User Policy	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaHostsWarningUserPolicy	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningUserPolicy	Public	False

DataSource Modules (3)

	DisplayName	ID	Isolation	Accessibility
	PowerShell command executer Data Source	Microsoft.SQLServer.2014.AlwaysOn.CommandExecuterDataSource	Any	Internal
	PowerShell command executer database replica Data Source	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaCommandExecuterDataSource	Any	Internal
	User Policy Discovery Data Source	Microsoft.SQLServer.2014.AlwaysOn.UserPolicyDataSource	Any	Internal

Secure References (1)

	DisplayName	ID	Context	Accessibility
	Microsoft SQL Server 2014 Always On Discovery Run As Profile	Microsoft.SQLServer.2014.AlwaysOn.DiscoveryAccount	System.Entity	Public

Discoveries (4)

	DisplayName	ID	Target	Enabled
	MSSQL 2014: Always On Seed Discovery	Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedDiscovery	Microsoft.SQLServer.2014.DBEngine	True
	MSSQL 2014: Database Replicas Always On Discovery	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaAlwaysOnDiscovery	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	True
	MSSQL 2014: General Always On Discovery	Microsoft.SQLServer.2014.AlwaysOn.GeneralAlwaysOnDiscovery	Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeed	True
	MSSQL 2014: General Custom User Policy Discovery	Microsoft.SQLServer.2014.AlwaysOn.GeneralUserPolicyDiscovery	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealth	False

Rules (1)

	DisplayName	ID	Target	Category	Enabled	Alert Generate
	MSSQL 2014: Always On monitoring script failed rule	Microsoft.SQLServer.2014.AlwaysOn.ScriptFailedRule	Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeed	Alert	True	True

Image References (4)

	DisplayName	ID	ImageID
	MSSQL 2014: Availability Group	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroup	Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage80
	MSSQL 2014: Availability Replica	Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplica	Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage80
	MSSQL 2014: Database Replica	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplica	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage80
	MSSQL 2014: Always On Custom User Policy	Microsoft.SQLServer.2014.AlwaysOn.Policy	Microsoft.SQLServer.2014.AlwaysOn.Policy.Image80

Images (8)

	ID	File Name	Accessibility
	Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage16	Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage16.png	Public
	Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage80	Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage80.png	Public
	Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage16	Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage16.png	Public
	Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage80	Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage80.png	Public
	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage16	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage16.png	Public
	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage80	Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage80.png	Public
	Microsoft.SQLServer.2014.AlwaysOn.Policy.Image16	Microsoft.SQLServer.2014.AlwaysOn.Policy.Image16.png	Public
	Microsoft.SQLServer.2014.AlwaysOn.Policy.Image80	Microsoft.SQLServer.2014.AlwaysOn.Policy.Image80.png	Public