Microsoft SQL Server 2016 Always On (Discovery)

Microsoft.SQLServer.2016.AlwaysOn.Discovery :: 7.0.0.0 (Management Pack)

This Management Pack discovers objects required for monitoring of Microsoft SQL Server 2016 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.2016.AlwaysOn.AlwaysOnSeedMSSQL 2016: Always On SeedMicrosoft.SQLServer.2016.AlwaysOn.AlwaysOnSeedMicrosoft.Windows.LocalApplicationFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityDatabaseMSSQL 2016: Availability DatabaseMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityDatabaseSystem.EntityFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityDatabaseHealthMSSQL 2016: Availability Database HealthMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityDatabaseHealthMicrosoft.SQLServer.2016.ComponentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupMSSQL 2016: Availability GroupMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupSystem.EntityFalseFalseFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupErrorUserPolicyMSSQL 2016: Availability Group Critical PolicyMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupErrorUserPolicyMicrosoft.SQLServer.2016.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthMSSQL 2016: Availability Group HealthMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupHealthMicrosoft.SQLServer.2016.ComponentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupWarningUserPolicyMSSQL 2016: Availability Group Warning PolicyMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityGroupWarningUserPolicyMicrosoft.SQLServer.2016.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaMSSQL 2016: Availability ReplicaMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaMicrosoft.SQLServer.2016.ComponentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorUserPolicyMSSQL 2016: Availability Replica Critical PolicyMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorUserPolicyMicrosoft.SQLServer.2016.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningUserPolicyMSSQL 2016: Availability Replica Warning PolicyMicrosoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningUserPolicyMicrosoft.SQLServer.2016.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaMSSQL 2016: Database ReplicaMicrosoft.SQLServer.2016.AlwaysOn.DatabaseReplicaMicrosoft.SQLServer.2016.ComponentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorUserPolicyMSSQL 2016: Database Replica Critical PolicyMicrosoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorUserPolicyMicrosoft.SQLServer.2016.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningUserPolicyMSSQL 2016: Database Replica Warning PolicyMicrosoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningUserPolicyMicrosoft.SQLServer.2016.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2016.AlwaysOn.PolicyMSSQL 2016: Always On Custom User PolicyMicrosoft.SQLServer.2016.AlwaysOn.PolicyMicrosoft.SQLServer.2016.ComponentTrueFalseFalseFalseFalsePublic

Relationship Types (17)

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

DataSource Modules (3)

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

Discoveries (4)

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

Rules (1)

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

Image References (4)

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

Images (8)

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