Microsoft SQL Server 2014 AlwaysOn (Discovery)

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

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

Management Pack Elements

Classes (12)

 DisplayNameIDBase ClassAbstractHostedSingletonGroupExtensionAccessibility
Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedAlwaysOn SeedMicrosoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedMicrosoft.Windows.LocalApplicationFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupAvailability GroupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupSystem.EntityFalseFalseFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorUserPolicyAvailability Group Critical PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupErrorUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthAvailability Group HealthMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthMicrosoft.SQLServer.2014.ComponentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningUserPolicyAvailability Group Warning PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupWarningUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaAvailability ReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaMicrosoft.SQLServer.2014.ComponentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorUserPolicyAvailability Replica Critical PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaErrorUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningUserPolicyAvailability Replica Warning PolicyMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaWarningUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaDatabase ReplicaMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaMicrosoft.SQLServer.2014.ComponentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorUserPolicyDatabase Replica Critical PolicyMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaErrorUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningUserPolicyDatabase Replica Warning PolicyMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaWarningUserPolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2014.AlwaysOn.PolicyAlwaysOn Custom User PolicyMicrosoft.SQLServer.2014.AlwaysOn.PolicyMicrosoft.SQLServer.2014.ComponentTrueFalseFalseFalseFalsePublic

Relationship Types (13)

 DisplayNameIDSourceTargetAccessibilityAbstract
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.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.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 datasourceMicrosoft.SQLServer.2014.AlwaysOn.CommandExecuterDataSourceAnyInternal
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaCommandExecuterDataSourcePowerShell command executer database replica datasourceMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaCommandExecuterDataSourceAnyInternal
Microsoft.SQLServer.2014.AlwaysOn.UserPolicyDataSourceUser Policy Discovery DatasourceMicrosoft.SQLServer.2014.AlwaysOn.UserPolicyDataSourceAnyInternal

Secure References (1)

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

Discoveries (4)

 DisplayNameIDTargetEnabled
Microsoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedDiscoveryMSSQL 2014: AlwaysOn Seed DiscoveryMicrosoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedDiscoveryMicrosoft.SQLServer.2014.DBEngineTrue
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaAlwaysOnDiscoveryMSSQL 2014: Database Replicas AlwaysOn DiscoveryMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaAlwaysOnDiscoveryMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupHealthTrue
Microsoft.SQLServer.2014.AlwaysOn.GeneralAlwaysOnDiscoveryMSSQL 2014: General AlwaysOn 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: AlwaysOn discovery script failed ruleMicrosoft.SQLServer.2014.AlwaysOn.ScriptFailedRuleMicrosoft.SQLServer.2014.AlwaysOn.AlwaysOnSeedAlertTrueTrue

Image References (4)

 DisplayNameIDImageID
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityGroupAvailability GroupMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityGroupMicrosoft.SQLServer.2014.AlwaysOn.AvailabiliryGroupImage80
Microsoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaAvailability ReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabilityReplicaMicrosoft.SQLServer.2014.AlwaysOn.AvailabiliryReplicaImage80
Microsoft.SQLServer.2014.AlwaysOn.DatabaseReplicaDatabase ReplicaMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaMicrosoft.SQLServer.2014.AlwaysOn.DatabaseReplicaImage80
Microsoft.SQLServer.2014.AlwaysOn.PolicyAlwaysOn 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