Microsoft SQL Server 2017 on Windows Always On monitoring.
| DisplayName | ID | Isolation | Accessibility | |
|---|---|---|---|---|
 | MSSQL 2017 on Windows Always On: Condition Detection User Policy Data Mapper | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConditionDetection.UserPolicyDataMapper | Any | Public |
| DisplayName | ID | Isolation | Accessibility | |
|---|---|---|---|---|
 | MSSQL 2017 on Windows Always On: EventReaderSingleParam Data Source | Microsoft.SQLServer.2017.AlwaysOn.Windows.DataSource.EventReaderSingleParam | Any | Internal |
| MSSQL 2017 on Windows Always On: MSSQLLogReaderEventTrigger DataSource | Microsoft.SQLServer.2017.AlwaysOn.Windows.DataSource.MSSQLLogReaderEventTrigger | Any | Internal |
| MSSQL 2017 on Windows Always On: SQL Server OS Performance Data Source | Microsoft.SQLServer.2017.AlwaysOn.Windows.DataSource.SqlOsPerformanceReader | Any | Internal |
| MSSQL 2017 on Windows Always On: System Policy Data Source | Microsoft.SQLServer.2017.AlwaysOn.Windows.DataSource.SystemPolicy | Any | Internal |
| MSSQL 2017 on Windows Always On: Custom User Policy Data Source | Microsoft.SQLServer.2017.AlwaysOn.Windows.DataSource.UserPolicy | Any | Internal |
| MSSQL 2017 on Windows Always On: SqlOsPerfCounterReaderHelper ProbeAction | Microsoft.SQLServer.2017.AlwaysOn.Windows.ProbeAction.SqlOsPerfCounterReaderHelper | Any | Internal |
| DisplayName | ID | Isolation | Accessibility | |
|---|---|---|---|---|
 | MSSQL 2017 on Windows Always On: System Policy Probe Action | Microsoft.SQLServer.2017.AlwaysOn.Windows.ProbeAction.SystemPolicy | Any | Internal |
| MSSQL 2017 on Windows Always On: Custom User Policy Probe Action | Microsoft.SQLServer.2017.AlwaysOn.Windows.ProbeAction.UserPolicy | Any | Internal |
| DisplayName | ID | Accessibility | Support Monitor Recalculate | |
|---|---|---|---|---|
 | MSSQL 2017 on Windows Always On: Two-State System Policy Monitor Type | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.SystemPolicy | Internal | False |
| MSSQL 2017 on Windows Always On: Two-State Custom User Policy Monitor Type | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitorType.UserPolicy | Internal | False |
| ID | Accessibility | |
|---|---|---|
 | Microsoft.SQLServer.2017.AlwaysOn.Windows.DataSource.MSSQLLogReaderSchema | Internal |
| Microsoft.SQLServer.2017.AlwaysOn.Windows.DataSource.SqlOsPerfReaderSchema | Internal |
| ID | Target | |
|---|---|---|
 | Cat.Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.AvailabilityReplica.ForcedFailover | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.AvailabilityReplica.ForcedFailover |
| Cat.Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.AvailabilityReplica.ManualFailover | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.AvailabilityReplica.ManualFailover |
| Cat.Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.AvailabilityReplica.RunPowerShell | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.AvailabilityReplica.RunPowerShell |
| Cat.Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.AvailabilityReplica.RunSSMS | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.AvailabilityReplica.RunSSMS |
| Cat.Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.DatabaseReplica.ResumeDataMovement | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.DatabaseReplica.ResumeDataMovement |
| Cat.Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.DatabaseReplica.RunPowerShell | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.DatabaseReplica.RunPowerShell |
| Cat.Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.DatabaseReplica.RunSSMS | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.DatabaseReplica.RunSSMS |
| Cat.Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.DatabaseReplica.SuspendDataMovement | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.DatabaseReplica.SuspendDataMovement |
| DisplayName | ID | Target | Algorithm | Category | Enabled | Alert Generate | Accessibility | |
|---|---|---|---|---|---|---|---|---|
 | Availability Group Extended Health State | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregate | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | WorstOf | AvailabilityHealth | True | False | Public |
| DisplayName | ID | Target | Algorithm | Source Monitor | Relationship | Category | Enabled | Alert Generate | Accessibility | |
|---|---|---|---|---|---|---|---|---|---|---|
 | Availability Replicas Connection (Windows rollup) | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AllAvailabilityReplicasAreConnected | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | WorstOf | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnected | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Availability Group Automatic Failover (Windows rollup) | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AutomaticFailoverReadiness | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | WorstOf | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AutomaticFailoverReadiness | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Availability Group Online (Windows rollup) | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AvailabilityGroupOnline | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | WorstOf | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityGroupOnline | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Availability Group Extended Health State (Windows rollup) | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AvailabilityGroupUserPolicyState | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | WorstOf | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroupHealth.UserPolicyAggregate | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Availability Group Critical Policies (Windows rollup) | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AvailabilityReplicaRoleState | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | WorstOf | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicaRoleState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Synchronous Replicas Data Synchronization (Windows rollup) | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizationState | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | WorstOf | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Availability Replicas Data Synchronization (Windows rollup) | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroup.AvailabilityReplicasSynchronizing | Microsoft.SQLServer.2017.AlwaysOn.Library.AvailabilityGroup | WorstOf | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizing | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupReferencesAvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Availability Group Critical Policies (rollup) | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroupHealth.ErrorUserPolicyState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | WorstOf | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupErrorPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealthHostsAvailabilityGroupErrorUserPolicy | AvailabilityHealth | True | False | Public |
| Availability Group Warning Policies (rollup) | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rollup.AvailabilityGroupHealth.WarningUserPolicyState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | WorstOf | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupWarningPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealthHostsAvailabilityGroupWarningUserPolicy | AvailabilityHealth | True | False | Public |
| Availability Replica Critical Policies Availability | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaAvailability | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | WorstOf | System.Health.AvailabilityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy | AvailabilityHealth | True | False | Public |
| Availability Replica Critical Policies Configuration | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaConfiguration | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | WorstOf | System.Health.ConfigurationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy | ConfigurationHealth | True | False | Public |
| Availability Replica Critical Policies Performance | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaPerformance | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | WorstOf | System.Health.PerformanceState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy | PerformanceHealth | True | False | Public |
| Availability Replica Critical Policies Security | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaErrorUserPolicyToAvailabilityReplicaSecurity | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | WorstOf | System.Health.SecurityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaErrorUserPolicy | SecurityHealth | True | False | Public |
| Availability Replica Warning Policies Availability | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaAvailability | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | WorstOf | System.Health.AvailabilityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy | AvailabilityHealth | True | False | Public |
| Availability Replica Warning Policies Configuration | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaConfiguration | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | WorstOf | System.Health.ConfigurationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy | ConfigurationHealth | True | False | Public |
| Availability Replica Warning Policies Performance | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaPerformance | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | WorstOf | System.Health.PerformanceState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy | PerformanceHealth | True | False | Public |
| Availability Replica Warning Policies Security | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.AvailabilityReplicaWarningUserPolicyToAvailabilityReplicaSecurity | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | WorstOf | System.Health.SecurityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsAvailabilityReplicaWarningUserPolicy | SecurityHealth | True | False | Public |
| Database Replicas Availability | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaAvailability | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | WorstOf | System.Health.AvailabilityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsDatabaseReplica | AvailabilityHealth | True | False | Public |
| Database Replicas Configuration | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaConfiguration | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | WorstOf | System.Health.ConfigurationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsDatabaseReplica | ConfigurationHealth | True | False | Public |
| Database Replicas Performance | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaPerformance | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | WorstOf | System.Health.PerformanceState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsDatabaseReplica | PerformanceHealth | True | False | Public |
| Database Replicas Security | Microsoft.SQLServer.2017.Windows.Rollup.AvailabilityReplica.DatabaseReplicaToAvailabilityReplicaSecurity | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | WorstOf | System.Health.SecurityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaHostsDatabaseReplica | SecurityHealth | True | False | Public |
| Database Replica Critical Policies Availability | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaAvailability | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | WorstOf | System.Health.AvailabilityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy | AvailabilityHealth | True | False | Public |
| Database Replica Critical Policies Configuration | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaConfiguration | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | WorstOf | System.Health.ConfigurationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy | ConfigurationHealth | True | False | Public |
| Database Replica Critical Policies Performance | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaPerformance | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | WorstOf | System.Health.PerformanceState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy | PerformanceHealth | True | False | Public |
| Database Replica Critical Policies Security | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaErrorUserPolicyToDatabaseReplicaSecurity | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | WorstOf | System.Health.SecurityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaErrorUserPolicy | SecurityHealth | True | False | Public |
| Database Replica Warning Policies Availability | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaAvailability | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | WorstOf | System.Health.AvailabilityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy | AvailabilityHealth | True | False | Public |
| Database Replica Warning Policies Configuration | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaConfiguration | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | WorstOf | System.Health.ConfigurationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy | ConfigurationHealth | True | False | Public |
| Database Replica Warning Policies Performance | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaPerformance | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | WorstOf | System.Health.PerformanceState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy | PerformanceHealth | True | False | Public |
| Database Replica Warning Policies Security | Microsoft.SQLServer.2017.Windows.Rollup.DatabaseReplica.DatabaseReplicaWarningUserPolicyToDatabaseReplicaSecurity | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | WorstOf | System.Health.SecurityState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaHostsDatabaseReplicaWarningUserPolicy | SecurityHealth | True | False | Public |
| DisplayName | ID | Target | Category | Enabled | Alert Generate | Accessibility | |
|---|---|---|---|---|---|---|---|
 | Availability Group Health Policy | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupErrorPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupErrorUserPolicy | AvailabilityHealth | True | False | Public |
| Availability Replicas Connection monitor | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AllAvailabilityReplicasAreConnected | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Availability Group Automatic Failover monitor | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AutomaticFailoverReadiness | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Availability Group Online monitor | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityGroupOnline | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Availability Replicas Role monitor | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicaRoleState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Synchronous Replicas Data Synchronization monitor | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Availability Replicas Data Synchronization monitor | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupHealth.AvailabilityReplicasSynchronizing | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupHealth | AvailabilityHealth | True | False | Public |
| Availability Group Health Policy | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityGroupWarningPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityGroupWarningUserPolicy | AvailabilityHealth | True | False | Public |
| Availability Replica Data Synchronization | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityReplica.DataSynchronizationHealth | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | AvailabilityHealth | True | False | Public |
| Availability Replica Connection | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityReplica.IsConnected | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | AvailabilityHealth | True | False | Public |
| Availability Replica Join State | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityReplica.IsJoined | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | AvailabilityHealth | True | False | Public |
| Availability Replica Role | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityReplica.RoleIsHealthy | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | AvailabilityHealth | True | False | Public |
| Availability Replica Health Policy | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityReplicaErrorPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaErrorUserPolicy | AvailabilityHealth | True | False | Public |
| Availability Replica Health Policy | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.AvailabilityReplicaWarningPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplicaWarningUserPolicy | AvailabilityHealth | True | False | Public |
| Availability Database Data Synchronization | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.DatabaseReplica.DataSynchronizationState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | AvailabilityHealth | True | False | Public |
| Availability Database Join State | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.DatabaseReplica.JoinState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | AvailabilityHealth | True | False | Public |
| Availability Database Suspension State | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.DatabaseReplica.SuspendState | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | AvailabilityHealth | True | False | Public |
| Database Replica Health Policy | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.DatabaseReplicaErrorPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaErrorUserPolicy | AvailabilityHealth | True | False | Public |
| Database Replica Health Policy | Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitor.DatabaseReplicaWarningPolicy.State | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplicaWarningUserPolicy | AvailabilityHealth | True | False | Public |
| DisplayName | ID | Target | Category | Enabled | Alert Generate | |
|---|---|---|---|---|---|---|
 | MSSQL 2017 on Windows Always On: Bytes Received from Replica / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.BytesReceivedFromReplicaPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Bytes Sent to Replica / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.BytesSentToReplicaPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Bytes Sent to Transport / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.BytesSentToTransportPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Flow Control / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.FlowControlPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Flow Control Time (ms/sec) | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.FlowControlTimeSeconds | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Receives from Replica / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.ReceivesFromReplicaPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Resent Messages / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.ResentMessagesPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Sends to Replica / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.SendsToReplicaPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Sends to Transport / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.AvailabilityReplica.SendsToTransportPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: File Bytes Received / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.FileBytesReceivedPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Log Apply Pending Queue | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.LogApplyPendingQueue | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Log Apply Ready Queue | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.LogApplyReadyQueue | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Log Bytes Received / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.LogBytesReceivedPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Log Remaining for undo | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.LogRemainingForUndo | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Log Send Queue | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.LogSendQueue | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Mirrored Write Transactions / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.MirroredWriteTransactionsPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Recovery Queue | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.RecoveryQueue | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Redo blocked / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.RedoBlockedSec | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Redo Bytes Remaining | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.RedoBytesRemaining | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Redone Bytes / sec | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.RedoneBytesPerSecond | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Total Log requiring undo | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.TotalLogRequiringUndo | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Transaction Delay | Microsoft.SQLServer.2017.AlwaysOn.Windows.CollectionRule.DatabaseReplica.TransactionDelay | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | PerformanceCollection | True | False |
| MSSQL 2017 on Windows Always On: Availability Replica Role Changed | Microsoft.SQLServer.2017.AlwaysOn.Windows.EventRule.AvailabilityReplica.RoleChanged | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | EventCollection | True | True |
| MSSQL 2017 on Windows Always On: Database Replica Role Changed | Microsoft.SQLServer.2017.AlwaysOn.Windows.EventRule.DatabaseReplica.RoleChanged | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | EventCollection | True | True |
| MSSQL 2017 on Windows Always On: Monitoring error | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rule.MonitoringPoolAlertCollection.MonitoringError | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitoringPoolAlertCollection | Alert | True | True |
| MSSQL 2017 on Windows Always On: Monitoring warning | Microsoft.SQLServer.2017.AlwaysOn.Windows.Rule.MonitoringPoolAlertCollection.MonitoringWarning | Microsoft.SQLServer.2017.AlwaysOn.Windows.MonitoringPoolAlertCollection | Alert | True | True |
| DisplayName | ID | Target | Accessibility | Enabled | |
|---|---|---|---|---|---|
 | Forced Failover | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.AvailabilityReplica.ForcedFailover | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | Internal | True |
| Manual Failover | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.AvailabilityReplica.ManualFailover | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | Internal | True |
| SQL Server PowerShell | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.AvailabilityReplica.RunPowerShell | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | Internal | True |
| SQL Server Management Studio | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.AvailabilityReplica.RunSSMS | Microsoft.SQLServer.2017.AlwaysOn.Windows.AvailabilityReplica | Internal | True |
| Resume Data Movement | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.DatabaseReplica.ResumeDataMovement | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | Internal | True |
| SQL Server PowerShell | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.DatabaseReplica.RunPowerShell | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | Internal | True |
| SQL Server Management Studio | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.DatabaseReplica.RunSSMS | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | Internal | True |
| Suspend Data Movement | Microsoft.SQLServer.2017.AlwaysOn.Windows.ConsoleTask.DatabaseReplica.SuspendDataMovement | Microsoft.SQLServer.2017.AlwaysOn.Windows.DatabaseReplica | Internal | True |
| ID | File Name | Accessibility | |
|---|---|---|---|
 | Microsoft.SQLServer.2017.AlwaysOn.Windows.Module.Monitoring.Assembly | Microsoft.SQLServer.2017.AlwaysOn.Windows.Module.Monitoring.dll | Public |
| Smo.Microsoft.SqlServer.Management.HadrDMF.Assembly | Microsoft.SqlServer.Management.HadrDMF.dll | Public |
Home
Show Management Pack References