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

Classes (14)

 DisplayNameIDBase ClassAbstractHostedSingletonGroupExtensionAccessibility
Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedMSSQL 2014: Always On SeedMicrosoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedMicrosoft.Windows.LocalApplicationFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseMSSQL 2014: Availability DatabaseMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseSystem.EntityFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseHealthMSSQL 2014: Availability Database HealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseHealthMicrosoft.SQLServer.2014.ComponentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupMSSQL 2014: Availability GroupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupSystem.EntityFalseFalseFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorUserPolicyMSSQL 2014: Availability Group Critical PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthMSSQL 2014: Availability Group HealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthMicrosoft.SQLServer.2014.ComponentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningUserPolicyMSSQL 2014: Availability Group Warning PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaMSSQL 2014: Availability ReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaMicrosoft.SQLServer.2014.ComponentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorUserPolicyMSSQL 2014: Availability Replica Critical PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningUserPolicyMSSQL 2014: Availability Replica Warning PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaMSSQL 2014: Database ReplicaMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaMicrosoft.SQLServer.2014.ComponentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorUserPolicyMSSQL 2014: Database Replica Critical PolicyMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningUserPolicyMSSQL 2014: Database Replica Warning PolicyMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.PolicyMSSQL 2014: Always On Custom User PolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyMicrosoft.SQLServer.2014.ComponentTrueFalseFalseFalseFalsePublic

Relationship Types (17)

 DisplayNameIDSourceTargetAccessibilityAbstract
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseContainsDatabaseReplicaAvailability Group contains Database ReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseContainsDatabaseReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseReferencesAvailabilityDatabaseHealthAvailability Database references Availability Database HealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseReferencesAvailabilityDatabaseHealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseHealthPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupContainsAvailabilityReplicaAvailability Group contains Availability ReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupContainsAvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthContainsAvailabilityReplicasAvailability Group Health contains Availability ReplicasMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthContainsAvailabilityReplicasMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsAvailabilityDatabaseHealthAvailability Group Health hosts Availability Database HealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsAvailabilityDatabaseHealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityDatabaseHealthPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsErrorUserPolicyAvailability Group hosts Error User PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsErrorUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorUserPolicyPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsWarningUserPolicyAvailability Group hosts Warning User PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthHostsWarningUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningUserPolicyPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHostsAvailabilityDatabaseAvailability Group hosts Availability DatabaseMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHostsAvailabilityDatabaseMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityDatabasePublicFalse
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealthAvailability Group references Availability Group HealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupReferencesAvailabilityGroupHealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaContainsDatabaseReplicasAvailability Group contains Database ReplicasMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaContainsDatabaseReplicasMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaHostsErrorUserPolicyAvailability Replica hosts Error User PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaHostsErrorUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorUserPolicyPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaHostsWarningUserPolicyAvailability Replica hosts Warning User PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaHostsWarningUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningUserPolicyPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.ComputerHostsAvailabilityGroupHealthComputer Hosts Availability Group HealthMicrosoft.SQLServer.2014.AlwaysOn.ComputerHostsAvailabilityGroupHealthMicrosoft.Windows.ComputerMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.ComputerHostsAvailabilityReplicaComputer hosts Availability ReplicaMicrosoft.SQLServer.2014.AlwaysOn.ComputerHostsAvailabilityReplicaMicrosoft.Windows.ComputerMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.ComputerHostsDatabaseReplicaComputer hosts Database ReplicaMicrosoft.SQLServer.2014.AlwaysOn.ComputerHostsDatabaseReplicaMicrosoft.Windows.ComputerMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaHostsErrorUserPolicyDatabase Replica hosts Error User PolicyMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaHostsErrorUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorUserPolicyPublicFalse
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaHostsWarningUserPolicyDatabase Replica hosts Warning User PolicyMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaHostsWarningUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningUserPolicyPublicFalse

DataSource Modules (3)

 DisplayNameIDIsolationAccessibility
Microsoft.SQLServer.2014.AlwaysOn.CommandExecuterDataSourcePowerShell command executer Data SourceMicrosoft.SQLServer.2014.AlwaysOn.CommandExecuterDataSourceAnyInternal
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaCommandExecuterDataSourcePowerShell command executer database replica Data SourceMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaCommandExecuterDataSourceAnyInternal
Microsoft.SQLServer.2014.AlwaysOn.UserPolicyDataSourceUser Policy Discovery Data SourceMicrosoft.SQLServer.2014.AlwaysOn.UserPolicyDataSourceAnyInternal

Secure References (1)

 DisplayNameIDContextAccessibility
Microsoft.SQLServer.2014.AlwaysOn.DiscoveryAccountMicrosoft SQL Server 2014 Always On Discovery Run As ProfileMicrosoft.SQLServer.2014.AlwaysOn.DiscoveryAccountSystem.EntityPublic

Discoveries (4)

 DisplayNameIDTargetEnabled
Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedDiscoveryMSSQL 2014: Always On Seed DiscoveryMicrosoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedDiscoveryMicrosoft.SQLServer.2014.DBEngineTrue
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaAlwaysOnDiscoveryMSSQL 2014: Database Replicas Always On DiscoveryMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaAlwaysOnDiscoveryMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthTrue
Microsoft.SQLServer.2014.AlwaysOn.GeneralAlwaysOnDiscoveryMSSQL 2014: General Always On DiscoveryMicrosoft.SQLServer.2014.AlwaysOn.GeneralAlwaysOnDiscoveryMicrosoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedTrue
Microsoft.SQLServer.2014.AlwaysOn.GeneralUserPolicyDiscoveryMSSQL 2014: General Custom User Policy DiscoveryMicrosoft.SQLServer.2014.AlwaysOn.GeneralUserPolicyDiscoveryMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthFalse

Rules (1)

 DisplayNameIDTargetCategoryEnabledAlert Generate
Microsoft.SQLServer.2014.AlwaysOn.ScriptFailedRuleMSSQL 2014: Always On monitoring script failed ruleMicrosoft.SQLServer.2014.AlwaysOn.ScriptFailedRuleMicrosoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedAlertTrueTrue

Image References (4)

 DisplayNameIDImageID
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupMSSQL 2014: Availability GroupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupMicrosoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage80
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaMSSQL 2014: Availability ReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage80
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaMSSQL 2014: Database ReplicaMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage80
Microsoft.SQLServer.2014.AlwaysOn.PolicyMSSQL 2014: Always On Custom User PolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyMicrosoft.SQLServer.2014.AlwaysOn.Policy.Image80

Images (8)

 IDFile NameAccessibility
Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage16Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage16Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage16.pngPublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage80Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage80Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage80.pngPublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage16Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage16Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage16.pngPublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage80Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage80Microsoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage80.pngPublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage16Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage16Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage16.pngPublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage80Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage80Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage80.pngPublic
Microsoft.SQLServer.2014.AlwaysOn.Policy.Image16Microsoft.SQLServer.2014.AlwaysOn.Policy.Image16Microsoft.SQLServer.2014.AlwaysOn.Policy.Image16.pngPublic
Microsoft.SQLServer.2014.AlwaysOn.Policy.Image80Microsoft.SQLServer.2014.AlwaysOn.Policy.Image80Microsoft.SQLServer.2014.AlwaysOn.Policy.Image80.pngPublic