2 Replies Latest reply on Feb 26, 2018 1:46 PM by er.vansh17091

    SQL Database Monitoring in following manners: (data sync across the databases of Always on SQL 2016 cluster is not available)

    er.vansh17091

      Hi All,

       

      The monitoring for the data sync across the databases of Always on SQL 2016 cluster is not available.  For the below test server (X.X.X.X)and the database,

      Can you please confirm is the monitoring setup for SQL 2016 production servers only or is there any setup done for test servers as well.

       

      How to Monitor below as well:

       

      Errors from the error Log
      Operating system error
      backup log with truncate_only or with no_log
      setting database option recovery to simple
      the metadata is inconsistent
      cannot be opened due to inaccessible files or insufficient memory or disk space
      backup sets on the media might be damaged and unusable
      A nonrecoverable i/o error occurred on file
      Database out of Sync
      Database XXX is marked Restoring
      The log is out of space
      An inconsistency was detected during an internal operation
      Severity: 19
      Severity: 20
      Severity: 21

        • Re: SQL Database Monitoring in following manners: (data sync across the databases of Always on SQL 2016 cluster is not available)
          orioncrack

          You aren't going to get all of these cleanly with SAM without customizing your own template. Many of them are in AppInsight but not all. And, setting up alerts with SQL Appinsight is tough.

           

          Here are the rules and monitors in the SQL 2016 Monitoring pack of another tool that I wish SolarWinds SAM had - Someday I hope they add these basic events to SAM. We have to stay with this tool until SAM can do as much.

           

           

           

          ID
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.GarbageCollectionFillFactor
          Microsoft.SQLServer.2016.Script_Failed_Database_Login
          Microsoft.SQLServer.Visualization.Library.AggregateDashboardData.Rule
          Microsoft.SQLServer.2016._.NET_Framework_runtime_was_shut_down_by_user_code_5_Rule
          Microsoft.SQLServer.2016.Unable_to_connect_to_SQL_Server_1_5_Rule
          Microsoft.SQLServer.2016.A_default_full_text_catalog_does_not_exist_in_the_database_or_user_does_not_have_permission_to_perform_this_action_5_Rule
          Microsoft.SQLServer.2016.A_fatal_error_occurred_in_.NET_Framework_runtime_5_Rule
          Microsoft.SQLServer.2016.A_security__SSPI__error_occurred_when_connecting_to_another_Service_Broker_or_Database_Mirroring_host_5_Rule
          Microsoft.SQLServer.2016.An_SNI_call_failed_during_a_Service_Broker_Database_Mirroring_transport_operation_1_5_Rule
          Microsoft.SQLServer.2016.A_SQL_job_failed_to_complete_successfully_1_5_Rule
          Microsoft.SQLServer.2016.A_SQL_Server_Service_Broker_conversation_closed_due_to_an_error_5_Rule
          Microsoft.SQLServer.2016.A_SQL_Server_Service_Broker_procedure_output_results_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.CheckpointFile.Active
          Microsoft.SQLServer.2016.Alert_engine_stopped_due_to_unrecoverable_local_eventlog_errors_1_5_Rule
          Microsoft.SQLServer.2016.AlwaysOn.ScriptFailedRule
          Microsoft.SQLServer.2016.An_error_occurred_in_a_SQL_Server_Service_Broker_Database_Mirroring_transport_connection_endpoint_1_5_Rule
          Microsoft.SQLServer.2016.An_error_occurred_in_the_Service_Broker_manager_5_Rule
          Microsoft.SQLServer.2016.An_error_occurred_in_the_Service_Broker_queue_rollback_handler_5_Rule
          Microsoft.SQLServer.2016.An_error_occurred_in_the_SQL_Server_Service_Broker_message_dispatcher_5_Rule
          Microsoft.SQLServer.2016.An_error_occurred_in_the_SQL_Server_Service_Broker_message_transmitter_5_Rule
          Microsoft.SQLServer.2016.An_error_occurred_in_the_SQL_Server_Service_Broker_or_Database_Mirroring_transport_manager_5_Rule
          Microsoft.SQLServer.2016.An_error_occurred_in_the_timer_event_cache_5_Rule
          Microsoft.SQLServer.2016.An_error_occurred_while_processing_SQL_Server_Service_Broker_mirroring_routes_5_Rule
          Microsoft.SQLServer.2016.An_error_occurred_while_processing_the_log_for_database_5_Rule
          Microsoft.SQLServer.2016.An_SQL_Server_Service_Broker_dialog_caught_an_error_5_Rule
          Microsoft.SQLServer.2016.AppDomain_failed_to_unload_with_error_code_5_Rule
          Microsoft.SQLServer.2016.Attempt_to_fetch_logical_page_that_belongs_to_different_object_5_Rule
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupFailed
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaRoleChanged
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPAvgTransactionSegmentLargeDataSize
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPAvgTransactionSegmentSize
          Microsoft.SQLServer.2016.Backup_device_failed___Operating_system_error_1_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Activation_Stored_Procedures_Invoked_sec__Total_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Activation_Task_Limit_Reached__Total_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Activation_Task_Limit_Reached_sec__Total_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Activation_Tasks_Aborted_sec__Total_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Activation_Tasks_Started_sec__Total_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Statistics_Broker_Transaction_Rollbacks_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Statistics_Enqueued_Messages_sec_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Statistics_Enqueued_Transport_Msgs_sec_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Statistics_SQL_RECEIVEs_sec_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Statistics_SQL_SENDs_sec_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Transport_Message_Fragment_Receives_sec_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Transport_Message_Fragment_Sends_sec_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Transport_Open_Connection_Count_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Transport_Receive_I_Os_sec_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.SQLServer_Broker_Transport_Send_I_Os_sec_15.0_minutes_5_Rule
          Microsoft.SQLServer.2016.BufferCacheHitRatio
          Microsoft.SQLServer.2016.AlwaysOn.BytesReceivedFromReplicaPerSecond
          Microsoft.SQLServer.2016.AlwaysOn.BytesSentToReplicaPerSecond
          Microsoft.SQLServer.2016.AlwaysOn.BytesSentToTransportPerSecond
          Microsoft.SQLServer.2016.EventCollectionRule.DBEngine.CannotCreateFile
          Microsoft.SQLServer.2016.Cannot_determine_the_service_account_for_SQL_Server_instance_1_5_Rule
          Microsoft.SQLServer.2016.Cannot_open_backup_device.__1_5_Rule
          Microsoft.SQLServer.2016.Cannot_open_user_default_database._Login_failed_1_5_Rule
          Microsoft.SQLServer.2016.Cannot_recover_the_master_database._Exiting_1_5_Rule
          Microsoft.SQLServer.2016.Cannot_start_service_broker_activation_manager_5_Rule
          Microsoft.SQLServer.2016.Cannot_start_service_broker_manager_5_Rule
          Microsoft.SQLServer.2016.Cannot_start_service_broker_manager_due_to_operating_system_error_5_Rule
          Microsoft.SQLServer.2016.Cannot_start_service_broker_security_manager_5_Rule
          Microsoft.SQLServer.2016.Cannot_start_SQL_Server_Service_Broker_on_Database_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPCascadingAbortsSec
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.CheckpointFile.UnderConstruction
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.CheckpointFile.Stale
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPCheckpointsClosed
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPCheckpointsCompleted
          Microsoft.SQLServer.2016.Check_sum_failure_while_page_in_cache_id832
          Microsoft.SQLServer.2016.CHECKTABLE_processing_of_object_encountered_page_twice._Possible_internal_error_or_allocation_fault_1_5_Rule
          Microsoft.SQLServer.2016.CHECKTABLE_terminated._A_failure_was_detected_while_collecting_facts._Possibly_tempdb_out_of_space_or_a_system_table_is_inconsistent._Check_previous_errors_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPCommitDependenciesTakenSec
          Microsoft.SQLServer.2016.Commit_of_internal_MSDTC_transaction_failed_1_5_Rule
          Microsoft.SQLServer.2016.Common_Language_Runtime__CLR__not_installed_properly_5_Rule
          Microsoft.SQLServer.2016.Conflict_table__does_not_exist_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPCoreMergesCompleted
          Microsoft.SQLServer.2016.Could_not_allocate_new_page_for_database_._There_are_no_more_pages_available_in_filegroup._Space_can_be_created_by_dropping_objects_adding_additional_files_or_allowing_file_growth_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_allocate_space_for_object__in_database__because_the__filegroup_is_full_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_connect_to_server_because_it_is_not_defined_as_a_remote_login_at_the_server_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_create_a_statement_object_using_OLE_DB_provider_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_create_an_instance_of_OLE_DB_provider_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_create_AppDomain_manager_5_Rule
          Microsoft.SQLServer.2016.Could_not_do_cleanup_for_the_killed_process_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_find_CHECK_constraint_although_the_table_is_flagged_as_having_one_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_find_filegroup_ID_in_sys.filegroups_for_database_5_Rule
          Microsoft.SQLServer.2016.Could_not_find_FOREIGN_KEY_constraints_for_table_although_the_table_is_flagged_as_having_them_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_mark_database_as_suspect._Getnext_NC_scan_on_sysdatabases.dbid_failed_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_obtain_exclusive_lock_on_database_5_Rule
          Microsoft.SQLServer.2016.Could_not_obtain_information_about_Windows_NT_group_user_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_open_error_log_file_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_open_referenced_table_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_open_tempdb.__Cannot_continue_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_read_and_latch_page_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_recover_database_due_to_unresolved_transaction_outcomes_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_resolve_the_referenced_column_name_in_table_1_5_Rule
          Microsoft.SQLServer.2016.AWE__Could_not_use_Address_Windowing_Extensions_because__lock_pages_in_memory__privilege_was_not_granted_5_Rule
          Microsoft.SQLServer.2016.Could_not_write_a_CHECKPOINT_record_in_database_because_the_log_is_out_of_space_1_5_Rule
          Microsoft.SQLServer.2016.CREATE_DATABASE_failed._Could_not_allocate_enough_disk_space_for_a_new_database_on_the_named_disks_1_5_Rule
          Microsoft.SQLServer.2016.EventCollectionRule.DBEngine.CreateFileEncounteredOperatingSystemError
          Microsoft.SQLServer.2016.CollectionRule.ResourcePool.CacheMemoryTargetKB
          Microsoft.SQLServer.2016.CollectionRule.ResourcePool.CompileMemoryTargetKB
          Microsoft.SQLServer.2016.CollectionRule.ResourcePool.QueryExecMemoryTargetKB
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPCursorDeletesSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPCursorInsertsSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPCursorScansStartedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPCursorUniqueViolationsSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPCursorUpdatesSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPCursorWriteConflictsSec
          Microsoft.SQLServer.2016.Database_Backup_Failed_To_Complete_1_5_Rule
          Microsoft.SQLServer.2016.Database_cannot_be_opened_due_to_inaccessible_files_or_insufficient_memory_or_disk_space._See_the_SQL_Server_errorlog_for_details_1_5_Rule
          Microsoft.SQLServer.2016.DBCC_executed_found_no_errors_Rule
          Microsoft.SQLServer.2016.DBCC_executed_found_and_not_repaired_errors_Rule
          Microsoft.SQLServer.2016.DBCC_executed_found_and_repaired_errors_Rule
          Microsoft.SQLServer.2016.Database_log_file_is_full._Back_up_the_transaction_log_for_the_database_to_free_up_some_log_space_1_5_Rule
          Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaRoleChanged
          Microsoft.SQLServer.2016.Database.ActiveConnections.Collection
          Microsoft.SQLServer.2016.Database.ActiveRequests.Collection
          Microsoft.SQLServer.2016.Database.ActiveSessions.Collection
          Microsoft.SQLServer.2016.Database.ActiveTransactionsDB.Collection
          Microsoft.SQLServer.2016.Database.DBAllocatedFreeSpaceMB.Collection
          Microsoft.SQLServer.2016.Database.DBSize.Collection
          Microsoft.SQLServer.2016.Database.DBUsedSpaceMB.Collection
          Microsoft.SQLServer.2016.Database.DiskReadLatency.Collection
          Microsoft.SQLServer.2016.Database.DiskWriteLatency.Collection
          Microsoft.SQLServer.2016.DBEngine.AverageWaitTime.Collection
          Microsoft.SQLServer.2016.DBEngine.CPUUsagePercent.Collection
          Microsoft.SQLServer.2016.DBEngine.PageLifeExpectancy.Collection
          Microsoft.SQLServer.2016.DBEngine.StolenServerMemory.Collection
          Microsoft.SQLServer.2016.DBEngine.ThreadCount.Collection
          Microsoft.SQLServer.2016.DBFile.FileAllocatedSpaceLeftPercent.Collection
          Microsoft.SQLServer.2016.DBFile.FileAllocatedSpaceLeftMB.Collection
          Microsoft.SQLServer.2016.DBFile.SpaceFreePercent.Collection
          Microsoft.SQLServer.2016.DBFile.SpaceFreeMegabytes.Collection
          Microsoft.SQLServer.2016.DBFileGroup.FileGroupAllocatedSpaceLeftPercent.Collection
          Microsoft.SQLServer.2016.DBFileGroup.FileGroupAllocatedSpaceLeftMB.Collection
          Microsoft.SQLServer.2016.DBFileGroup.SpaceFreePercent.Collection
          Microsoft.SQLServer.2016.DBFileGroup.SpaceFreeMegabytes.Collection
          Microsoft.SQLServer.2016.DBFileStream.FileGroup.SpaceFreePercent.Collection
          Microsoft.SQLServer.2016.DBFileStream.FileGroup.SpaceFreeMegabytes.Collection
          Microsoft.SQLServer.2016.Database.DBDiskFreeSpaceMB.Collection
          Microsoft.SQLServer.2016.Database.DBSpaceFreePercent.Collection
          Microsoft.SQLServer.2016.Database.DBSpaceFree.Collection
          Microsoft.SQLServer.2016.DBLogFile.FileAllocatedSpaceLeftPercent.Collection
          Microsoft.SQLServer.2016.DBLogFile.FileAllocatedSpaceLeftMB.Collection
          Microsoft.SQLServer.2016.DBLogFile.SpaceFreePercent.Collection
          Microsoft.SQLServer.2016.DBLogFile.SpaceFreeMegabytes.Collection
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.SpaceFreePercent
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.SpaceFreeMegabytes
          Microsoft.SQLServer.2016.Database.TransactionLogSpaceFreePercent.Collection
          Microsoft.SQLServer.2016.Database.TransactionsPerSecDB.Collection
          Microsoft.SQLServer.2016.Descriptor_for_object_in_database_not_found_in_the_hash_table_during_attempt_to_unhash_it_1_5_Rule
          Microsoft.SQLServer.2016.DiscoveryFailed.Rule
          Microsoft.SQLServer.2016.DiscoveryWarning.Rule
          Microsoft.SQLServer.2016.Distributed_transaction_aborted_by_MSDTC_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPDustyCornerScanRetriesSecGcIssued
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPDustyCornerScanRetriesSecPhantomIssued
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPDustyCornerScanRetriesSecUserIssued
          Microsoft.SQLServer.2016.Enlist_of_MSDTC_transaction_failed_1_5_Rule
          Microsoft.SQLServer.2016.Error_recovering_database_._Could_not_connect_to_MSDTC_to_check_the_completion_status_of_transaction_1_5_Rule
          Microsoft.SQLServer.2016.Error_while_undoing_logged_operation_in_database__1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPExpiredRowsRemovedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPExpiredRowsTouchedSec
          Microsoft.SQLServer.2016.Failed_to_add_column__to_table__1_5_Rule
          Microsoft.SQLServer.2016.Failed_to_allocate_memory_for_Common_Language_Runtime__CLR__5_Rule
          Microsoft.SQLServer.2016.Failed_to_create_AppDomain_5_Rule
          Microsoft.SQLServer.2016.Failed_to_drop_column__from_table__1_5_Rule
          Microsoft.SQLServer.2016.Failed_to_finish_full_text_operation._The_filegroup_is_empty_read_only_or_not_online_5_Rule
          Microsoft.SQLServer.2016.Failed_to_initialize_the_Common_Language_Runtime__CLR__due_to_memory_pressure_5_Rule
          Microsoft.SQLServer.2016.Failed_to_initialize_the_Common_Language_Runtime__CLR__with_HRESULT_5_Rule
          Microsoft.SQLServer.2016.Failed_to_initialize_the_Common_Language_Runtime__CLR__with_HRESULT_1_5_Rule
          Microsoft.SQLServer.2016.Operating_system_error_during_creation_opening_of_physical_device_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_open_device_1_5_Rule
          Microsoft.SQLServer.2016.Failed_to_restore_master_database._Shutting_down_SQL_Server_5_Rule
          Microsoft.SQLServer.2016.Database_could_not_recover_1_5_Rule
          Microsoft.SQLServer.2016.AlwaysOn.FileBytesReceivedPerSecond
          Microsoft.SQLServer.2016.AlwaysOn.FlowControlPerSecond
          Microsoft.SQLServer.2016.AlwaysOn.FlowControlTimeSeconds
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPFlushThread256KQueueDepth
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPFlushThread4KQueueDepth
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPFlushThread64KQueueDepth
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPFlushThreadFrozenIosSec256K
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPFlushThreadFrozenIosSec4K
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPFlushThreadFrozenIosSec64K
          Microsoft.SQLServer.2016.Full_Text_Search___An_unknown_full_text_failure_occurred_1_5_Rule
          Microsoft.SQLServer.2016.Full_Text_Search___Could_not_find_full_text_index_for_database_1_5_Rule
          Microsoft.SQLServer.2016.Full_Text_Search___Full_text_catalog_is_in_a_unusable_state._Drop_and_re_create_this_full_text_catalog_1_5_Rule
          Microsoft.SQLServer.2016.Full_Text_Search___Full_text_catalog_lacks_sufficient_disk_space_to_complete_this_operation_1_5_Rule
          Microsoft.SQLServer.2016.Full_Text_Search___Full_Text_Search_is_not_enabled_for_the_current_database._Use_sp_fulltext_database_to_enable_Full_Text_Search_1_5_Rule
          Microsoft.SQLServer.2016.Full_Text_Search___Search_on_full_text_catalog_failed_with_unknown_result_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageAvgBytesPerRead
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageAvgBytesPerTransfer
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageAvgBytesPerWrite
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageAvgMicrosecPerRead
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageAvgMicrosecPerReadComp
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageAvgMicrosecPerTransfer
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageAvgMicrosecPerWrite
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageAvgMicrosecPerWriteComp
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageHTTPStorageIOFailedPerSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageHTTPStorageIORetryPerSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageOutstandingHTTPStorageIO
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageReadBytesPerSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageReadsPerSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageTotalBytesPerSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageTransfersPerSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageWriteBytesPerSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.HTTPStorageWritesPerSec
          Microsoft.SQLServer.2016.IORequestsTakingLongerThen15SecondsToComplete
          Microsoft.SQLServer.2016.Indexed_view_does_not_contain_all_rows_that_the_view_definition_produces.__Refer_to_Books_Online_for_more_information_on_this_error.__This_does_not_necessarily_represent_an_integrity_issue_with_th_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPInsufficientCreditsWaitsSec
          Microsoft.SQLServer.2016.Internal_Query_Processor_Error__The_query_processor_could_not_obtain_access_to_a_required_interface_1_5_Rule
          Microsoft.SQLServer.2016.Internal_Query_Processor_Error__The_query_processor_encountered_an_internal_limit_overflow_1_5_Rule
          Microsoft.SQLServer.2016.Internal_Query_Processor_Error__The_query_processor_encountered_an_unexpected_error_during_execution_1_5_Rule
          Microsoft.SQLServer.2016.Internal_Query_Processor_Error__The_query_processor_encountered_an_unexpected_error_during_the_processing_of_a_remote_query_phase_1_5_Rule
          Microsoft.SQLServer.2016.Internal_Query_Processor_Error__The_query_processor_ran_out_of_stack_space_during_query_optimization_1_5_Rule
          Microsoft.SQLServer.2016.Could_not_open_FCB_for_invalid_file_in_database__1_5_Rule
          Microsoft.SQLServer.2016.Invalid_reference_to_LOB_page_id7105
          Microsoft.SQLServer.2016.IO_Completion_Listener_Worker_appears_to_be_non_yielding_on_Node_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPIoIssuedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPIopagepool256kFreeListCount
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPIopagepool256kTotalAllocated
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPIopagepool4kFreeListCount
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPIopagepool4kTotalAllocated
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPIopagepool64kFreeListCount
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPIopagepool64kTotalAllocated
          Microsoft.SQLServer.2016.IS_Package_Failed_5_Rule
          Microsoft.SQLServer.2016.IS_Service_failed_to_load_user_defined_Configuration_file_5_Rule
          Microsoft.SQLServer.2016.IS_Service_has_attempted_to_stop_a_running_package_5_Rule
          Microsoft.SQLServer.2016.Job_step_cannot_be_run_because_the_subsystem_failed_to_load_1_5_Rule
          Microsoft.SQLServer.2016.LockTimeoutsPerSecond
          Microsoft.SQLServer.2016.AlwaysOn.LogApplyPendingQueue
          Microsoft.SQLServer.2016.AlwaysOn.LogApplyReadyQueue
          Microsoft.SQLServer.2016.Log_Backup_Failed_to_Complete_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPLogBlocksSec
          Microsoft.SQLServer.2016.AlwaysOn.LogBytesReceivedPerSecond
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPLogBytesWrittenSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPLogRecordsWrittenSec
          Microsoft.SQLServer.2016.AlwaysOn.LogRemainingForUndo
          Microsoft.SQLServer.2016.AlwaysOn.LogSendQueue
          Microsoft.SQLServer.2016.Logical_consistency_error_after_performing_IO_on_page_id824
          Microsoft.SQLServer.2016.Logical_page_in_database_is_already_hashed_1_5_Rule
          Microsoft.SQLServer.2016.Login_failed__Account
          Microsoft.SQLServer.2016.Login_failed._The_workstation_licensing_limit_for_SQL_Server_access_has_already_been_reached_5_Rule
          Microsoft.SQLServer.2016.Login_failed__Account_locked_out_5_Rule
          Microsoft.SQLServer.2016.Login_failed__Error_during_validation_5_Rule
          Microsoft.SQLServer.2016.Login_failed__Password_cannot_be_used_at_this_time_5_Rule
          Microsoft.SQLServer.2016.Login_failed__Password_expired_5_Rule
          Microsoft.SQLServer.2016.Login_failed__Password_fails_password_filter_DLL_requirements_5_Rule
          Microsoft.SQLServer.2016.Login_failed__Password_must_be_changed_5_Rule
          Microsoft.SQLServer.2016.Login_failed__Password_too_long_5_Rule
          Microsoft.SQLServer.2016.Login_failed__Password_too_short_5_Rule
          Microsoft.SQLServer.2016.Login_failed__Password_too_simple_5_Rule
          Microsoft.SQLServer.2016.LoginsPerSecCollection
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMainGcWorkItemsSec
          Microsoft.SQLServer.2016.CollectionRule.ResourcePool.MaxMemoryKB
          Microsoft.SQLServer.2016.Maximum_limit_for_connections_has_been_reached_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.IndexesUsedMemoryMB
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.TablesMemoryUsageMB
          Microsoft.SQLServer.2016.CollectionRule.Container.SpaceFreePercent
          Microsoft.SQLServer.2016.CollectionRule.Container.SpaceFreeMB
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMergePolicyEvaluations
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMergeRequestsOutstanding
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.CheckpointFile.MergeTarget
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMergesAbandoned
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMergesInstalled
          Microsoft.SQLServer.2016.AlwaysOn.MirroredWriteTransactionsPerSecond
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMissedCreditSlots
          Microsoft.SQLServer.2016.MonitoringFailed.Rule
          Microsoft.SQLServer.2016.MonitoringWarning.Rule
          Microsoft.SQLServer.2016.MSDTC_on_server__is_unavailable_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMtlog256KExpandCount
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMtlog256KIosOutstanding
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMtlog256KPageFillPageFlushed
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMtlog256KWriteBytesSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMtlog4KExpandCount
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMtlog4KIosOutstanding
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMtlog4KPageFillPageFlushed
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMtlog4KWriteBytesSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMtlog64KExpandCount
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMtlog64KIosOutstanding
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMtlog64KPageFillPageFlushed
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPMtlog64KWriteBytesSec
          Microsoft.SQLServer.2016.No_slots_are_free_to_keep_buffers_for_table__1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPNumMerges
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPNumMergesSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPNumSerializations
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPNumSerializationsSec
          Microsoft.SQLServer.2016.NumberDeadlocksPerSecond
          Microsoft.SQLServer.2016.LockRequestsPerSecond
          Microsoft.SQLServer.2016.LockWaitsPerSecond
          Microsoft.SQLServer.2016.CollectionRule.ResourcePool.PendingMemoryGrantsCount
          Microsoft.SQLServer.2016.CollectionRule.ResourcePool.MemoryGrantTimeoutsSec
          Microsoft.SQLServer.2016.CollectionRule.ResourcePool.ActiveMemoryGrantAmountKB
          Microsoft.SQLServer.2016.CollectionRule.ResourcePool.MemoryGrantsSec
          Microsoft.SQLServer.2016.One_or_more_indexes_are_damaged_and_must_be_repaired_or_dropped_1_5_Rule
          Microsoft.SQLServer.2016.Operating_System_error_encountered_1_5_Rule
          Microsoft.SQLServer.2016.Operating_system_error_on_a_device_1_5_Rule
          Microsoft.SQLServer.2016.Optimized_concurrent_query_limit_has_been_exceeded_1_5_Rule
          Microsoft.SQLServer.2016.OSError_Occurred_While_Performing_IO_onpage_id823
          Microsoft.SQLServer.2016.Package_execution_failed_because_the_checkpoint_file_cannot_be_loaded_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPParallelGcWorkItemSec
          Microsoft.SQLServer.2016.Permission_denied_on_object_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPPhantomExpiredRowsRemovedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPPhantomExpiredRowsTouchedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPPhantomExpiringRowsTouchedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPPhantomRowsTouchedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPPhantomScansStartedSec
          Microsoft.SQLServer.2016.PhysicalFileAccessErrorRule
          Microsoft.SQLServer.2016.Potential_deadlocks_exist_on_all_schedulers_on_Node_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.CheckpointFile.Precreated
          Microsoft.SQLServer.2016.Process_Worker_appears_to_be_non_yielding_on_Scheduler_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPReadOnlyTransactionsPreparedSec
          Microsoft.SQLServer.2016.AlwaysOn.ReceivesFromReplicaPerSecond
          Microsoft.SQLServer.2016.Recovery_of_database__detected_possible_identity_value_inconsistency_in_table_1_5_Rule
          Microsoft.SQLServer.2016.AlwaysOn.RecoveryQueue
          Microsoft.SQLServer.2016.AlwaysOn.RedoBlockedSec
          Microsoft.SQLServer.2016.AlwaysOn.RedoBytesRemaining
          Microsoft.SQLServer.2016.AlwaysOn.RedoneBytesPerSecond
          Microsoft.SQLServer.2016.AlwaysOn.RecentMessagesPerSecond
          Microsoft.SQLServer.2016.RESTORE_could_not_start_database_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPRowsProcessedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPRowsProcessedSecFirstInBucketAndRemoved
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPRowsProcessedSecFirstInBucket
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPRowsProcessedSecMarkedForUnlink
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPRowsProcessedSecNoSweepNeeded
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPRowsReturnedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPRowsTouchedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPSavePointRefreshesSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPSavePointRollbacksSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPSavePointsCreatedSec
          Microsoft.SQLServer.2016.AlwaysOn.SendsToReplicaPerSecond
          Microsoft.SQLServer.2016.AlwaysOn.SendsToTransportPerSecond
          Microsoft.SQLServer.2016.Service_Broker_was_not_able_to_allocate_memory_for_cryptographic_operations_5_Rule
          Microsoft.SQLServer.2016.SQLCompilationsPerSecond
          Microsoft.SQLServer.2016.SQLRecompilesPerSecond
          Microsoft.SQLServer.2016.DBEngineServiceRestart
          Microsoft.SQLServer.2016.SQLServerAgent_could_not_be_started_1_5_Rule
          Microsoft.SQLServer.2016.SQLServerAgent_initiating_self_termination_1_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_Assertion_1_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_Assertion_2_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_Assertion_3_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_cannot_start_the_Service_Broker_event_handler_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_could_not_allocate_enough_memory_to_start_Service_Broker_task_manager_5_Rule
          Microsoft.SQLServer.2016.EventCollectionRule.DBEngine.SQLServerOutOfMemory
          Microsoft.SQLServer.2016.SQL_Server_SQL_Server_Service_Broker_attempted_to_use_an_unsupported_encryption_algorithm_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_Service_Broker_cannot_use_RC4_encryption_algorithm_when_running_in_FIPS_compliance_mode_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_Service_Broker_could_not_query_the_FIPS_compliance_mode_flag_from_the_registry_5_Rule
          Microsoft.SQLServer.2016.A_SQL_Server_Service_Broker_cryptographic_operation_failed_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_Service_Broker_Manager_has_shutdown_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_Service_Broker_or_Database_Mirror_cryptographic_call_failed_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_Service_Broker_or_Database_Mirroring_is_running_in_FIPS_compliance_mode_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_Service_Broker_or_Database_Mirroring_Transport_stopped_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_Service_Broker_transmitter_shut_down_due_to_an_exception_or_a_lack_of_memory_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_shutdown_due_to_Ctrl_C_or_Ctrl_Break_signal_1_5_Rule
          Microsoft.SQLServer.2016.SQL_Server_terminating_because_of_system_shutdown_1_5_Rule
          Microsoft.SQLServer.2016.UserConnectionsCollection
          Microsoft.SQLServer.2016.IntegrationServices.PerformanceRule.Instance.PipelineBuffersSpooled
          Microsoft.SQLServer.2016.IntegrationServices.PerformanceRule.Instance.PipelineRowsRead
          Microsoft.SQLServer.2016.IntegrationServices.PerformanceRule.Instance.PipelineRowsWritten
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPStaleRateObjectWaitsSec
          Microsoft.SQLServer.2016.Starting_without_recovery_1_5_Rule
          Microsoft.SQLServer.2016.Step_of_a_job_caused_an_exception_in_the_subsystem_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPSweepExpiredRowsRemovedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPSweepExpiredRowsTouchedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPSweepExpiringRowsTouchedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPSweepRowsTouchedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPSweepScansStartedSec
          Microsoft.SQLServer.2016.Table_error___Address_is_not_aligned_1_5_Rule
          Microsoft.SQLServer.2016.Table_error___The_next_pointer_of_refers_to_page._Neither_its_parent_were_encountered._Possible_bad_chain_linkage_1_5_Rule
          Microsoft.SQLServer.2016.Table_error___Unexpected_page_type__1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Allocation_page_has_invalid__page_header_values.__1_5_Rule
          Microsoft.SQLServer.2016.Table_error__B_tree_chain_linkage_mismatch.__1_5_Rule
          Microsoft.SQLServer.2016.Table_error__B_tree_level_mismatch_page_does_not_match_level_from_parent__1_5_Rule
          Microsoft.SQLServer.2016.Table_error__B_tree_page_has_two_parent_nodes__1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Column_is_not_a_valid_complex_column_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Cross_object_linkage_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Cross_object_linkage._Page_PGID_next_is_not_in_the_same_index_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Cross_object_linkage__Parent_page_in_object_next_refer_to_page_not_in_the_same_object_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__cross_object_chain_linkage_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Extent_object_is_beyond_the_range_of_this_database_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Extra_or_invalid_key_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__IAM_chain_linkage_error_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__IAM_page_is_linked_in_the_IAM_chain_for_object_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Index_node_page_refers_to_child_page_and_previous_child_but_they_were_not_encountered_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Object_index_page_Test_failed._Slot___Offset_is__invalid_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Page_allocated_to_object_was_not_seen.__Page_may_be_invalid_or_have_incorrect_object_ID_information_in_its_header_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Page_in_its_header_is_allocated_by_another_object_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Page_is_missing_a_reference_from_previous_page._Possible_chain_linkage_problem_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Page_is_missing_references_from_parent__unknown__and_previous_nodes._Possible_bad_root_entry_in_sysindexes_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__page_is_out_of_the_range_of_this_database_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Page_was_not_seen_in_the_scan_although_its_parent_and_previous_refer_to_it._Check_any_previous_errors_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Parent_node_for_page_was_not_encountered_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Slot_row_extends_into_free_space__1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Table_missing_or_invalid_key_in_index_for_the_row__1_5_Rule
          Microsoft.SQLServer.2016.Table_error___Test_failed._Slot_overlaps_with_the_prior_row_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__The_high_key_value_on_page_is_not_less_than_the_low_key_value_in_the_parent_slot_of_the_next_page_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__The_low_key_value_on_page__is_not_the_key_value_in_the_parent_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__The_previous_link_on_page_does_not_match_the_previous_page_that_the_parent_slot_expects_for_this_page_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__The_text_ntext_or_image_node_at_page__is_referenced_by_page_not_seen_in_the_scan_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__The_text_ntext_or_image_node_at_page_is_not_referenced_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__The_text_ntext_or_image_node_has_wrong_type_1_5_Rule
          Microsoft.SQLServer.2016.Table_error__Wrong_PageId_in_the_page_header_1_5_Rule
          Microsoft.SQLServer.2016.Table___No_columns_without_statistics_found_1_5_Rule
          Microsoft.SQLServer.2016.Table__Creating_statistics_for_the_following_columns_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPTailCachePageCount
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPTailCachePageCountPeak
          Microsoft.SQLServer.2016.CollectionRule.ResourcePool.TargetMemoryKB
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPTentativelyDeletedRowsTouchedSec
          Microsoft.SQLServer.2016.The_agent_is_suspect._No_response_within_last_minutes_1_5_Rule
          Microsoft.SQLServer.2016.The_IO_operation_was_successful_after_retry_id825
          Microsoft.SQLServer.2016.The_log_for_database_is_not_available_1_5_Rule
          Microsoft.SQLServer.2016.The_LSN_passed_to_log_scan_in_database_is_invalid_5_Rule
          Microsoft.SQLServer.2016.The_MSSQLServer_service_terminated_unexpectedly_3_5_Rule
          Microsoft.SQLServer.2016.The_package_restarted_from_checkpoint_file.__Package_was_configured_to_restart_from_checkpoint_and_it_did_5_Rule
          Microsoft.SQLServer.2016.The_provider_reported_an_unexpected_catastrophic_failure_1_5_Rule
          Microsoft.SQLServer.2016.The_query_has_been_canceled_because_the_estimated_cost_of_this_query_exceeds_the_configured_threshold._Contact_the_system_administrator_1_5_Rule
          Microsoft.SQLServer.2016.The_query_processor_could_not_start_the_necessary_thread_resources_for_parallel_query_execution_1_5_Rule
          Microsoft.SQLServer.2016.The_server_is_too_busy_to_perform_the_backup_or_restore_operation_1_5_Rule
          Microsoft.SQLServer.2016.The_Service_Broker_or_Database_Mirroring_Transport_has_started_5_Rule
          Microsoft.SQLServer.2016.The_Service_Broker_Database_Mirroring_transport_cannot_listen_on_port_because_it_is_in_use_5_Rule
          Microsoft.SQLServer.2016.The_Service_Broker_Database_Mirroring_Transport_could_not_listen_for_connections_due_to_an_error_5_Rule
          Microsoft.SQLServer.2016.The_SQL_Server_Service_Broker_or_Database_Mirroring_transport_is_disabled_or_not_configured_5_Rule
          Microsoft.SQLServer.2016.The_user_is_not_allowed_to_truncate_the_system_table_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.ResourcePool.ActiveMemoryGrantsCount
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPTotalFilesMerged
          Microsoft.SQLServer.2016.AlwaysOn.TotalLogRequiringUndo
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPTotalRateObjectsPublished
          Microsoft.SQLServer.2016.TransactionsPerSecond
          Microsoft.SQLServer.2016.AlwaysOn.TransactionDelay
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPTransactionValidationFailuresSec
          Microsoft.SQLServer.2016.Transaction_was_deadlocked_on_resources_with_another_process_and_has_been_chosen_as_the_deadlock_victim._Rerun_the_transaction_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPTransactionsAbortedByUserSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPTransactionsAbortedSec
          Microsoft.SQLServer.2016.CollectionRule.DBEngine.XTPTransactionsCreatedSec
          Microsoft.SQLServer.2016.EventCollectionRule.DBEngine.UnableToOpenThePhysicalFile
          Microsoft.SQLServer.2016.Unable_to_re_open_the_local_eventlog_1_5_Rule
          Microsoft.SQLServer.2016.Unexpected_end_of_file_while_reading_beginning_of_backup_set_1_5_Rule
          Microsoft.SQLServer.2016.Unique_table_computation_failed_1_5_Rule
          Microsoft.SQLServer.2016.CollectionRule.ResourcePool.UsedMemoryKB
          Microsoft.SQLServer.2016.CollectionRule.UserResourcePool.MemoryConsumptionPercent
          Microsoft.SQLServer.2016.CollectionRule.UserResourcePool.MemoryConsumptionMB
          Microsoft.SQLServer.2016.XML___Failed_to_instantiate_class._Make_sure_Msxml2.dll_exists_in_the_SQL_Server_installation_1_5_Rule
          Microsoft.SQLServer.2016.XML___Failed_to_load_Msxml2.dll_1_5_Rule
          Microsoft.SQLServer.2016.XML___FOR_XML_EXPLICIT_stack_overflow_occurred._Circular_parent_tag_relationships_are_not_allowed_1_5_Rule
          Microsoft.SQLServer.2016.XML___Size_of_data_chunk_requested_from_the_stream_exceeds_allowed_limit_5_Rule
          Microsoft.SQLServer.2016.XML___XML_document_could_not_be_created_because_server_memory_is_low._Use_sp_xml_removedocument_to_release_XML_documents_1_5_Rule
          Microsoft.SQLServer.2016.XML___XML_error_1_5_Rule
          Microsoft.SQLServer.2016.XML___XML_parsing_error_1_5_Rule
          Microsoft.SQLServer.2016.Rule.XTP.BackgroundThreadError
          Microsoft.SQLServer.2016.Rule.XTP.BackgroundThreadErrorLog
          Microsoft.SQLServer.2016.Rule.XTP.CompilerFailure
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.XTPControllerDLCLatencyFetch
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.XTPControllerDLCPeakLatency
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.XTPControllerLogProcessedSec
          Microsoft.SQLServer.2016.Rule.XTP.InsufficientDiskSpace
          Microsoft.SQLServer.2016.CollectionRule.DBFileGroupFx.XTPMemoryUsedKB
          Microsoft.SQLServer.2016.Rule.XTP.UnableCallCompiler
          Microsoft.SQLServer.2016.Rule.XTP.UnableLoadCompiledDll

           

             

          IDName in 7.0.0.0Target Class in 7.0.0.0Target Class in 6.7.20.0Alert Message in 7.0.0.0
          Microsoft.SQLServer.2016.Monitor.DBFileGroupFx.GarbageCollectionState[Deprecated] Garbage CollectionSQL Server 2016 DB
            Memory-Optimized Data Filegroup
          SQL Server 2016 DB
            Memory-Optimized Data Filegroup
          MSSQL 2016: Memory-Optimized
            Data Garbage Collection Fill Factor is too low
          Microsoft.SQLServer.2016.Database.Configuration.AutoCloseAuto Close ConfigurationSQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Auto Close
            Configuration Error
          Microsoft.SQLServer.2016.Database.Configuration.AutoCreateStatAuto Create Statistics
            Configuration
          SQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Auto Create
            Statistics Configuration Error
          Microsoft.SQLServer.2016.Database.Configuration.AutoShrinkAuto Shrink ConfigurationSQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Auto Shrink
            Configuration Error
          Microsoft.SQLServer.2016.Database.Configuration.AutoUpdateStatAsyncAuto Update Statistics Async
            Configuration
          SQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Auto Update
            Statistics Async Configuration Error
          Microsoft.SQLServer.2016.Database.Configuration.AutoUpdateSetAuto Update Statistics
            Configuration
          SQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Auto Update
            Statistics Configuration Error
          Microsoft.SQLServer.2016.AlwaysOn.Monitor.AvailabilityDatabaseHealth.BackupStatusAvailability Database Backup
            Status
          MSSQL 2016: Availability
            Database Health
          Microsoft.SQLServer.2016.AlwaysOn.DbrDataSynchronizationStateAvailability Database Data
            Synchronization
          MSSQL 2016: Database ReplicaMSSQL 2016: Database Replica
          Microsoft.SQLServer.2016.AlwaysOn.DbrJoinStateAvailability Database Join StateMSSQL 2016: Database ReplicaMSSQL 2016: Database Replica
          Microsoft.SQLServer.2016.AlwaysOn.DbrSuspendStateAvailability Database Suspension
            State
          MSSQL 2016: Database ReplicaMSSQL 2016: Database Replica
          Microsoft.SQLServer.2016.AlwaysOn.AutomaticFailoverReadinessAvailability Group Automatic
            Failover monitor
          MSSQL 2016: Availability Group
            Health
          MSSQL 2016: Availability Group
            Health
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitorAvailability Group Health PolicyMSSQL 2016: Availability Group
            Critical Policy
          MSSQL 2016: Availability Group
            Critical Policy
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitorAvailability Group Health PolicyMSSQL 2016: Availability Group
            Warning Policy
          MSSQL 2016: Availability Group
            Warning Policy
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityGroupOnlineAvailability Group Online
            monitor
          MSSQL 2016: Availability Group
            Health
          MSSQL 2016: Availability Group
            Health
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaIsConnectedAvailability Replica ConnectionMSSQL 2016: Availability ReplicaMSSQL 2016: Availability Replica
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaDataSynchronizationHealthAvailability Replica Data
            Synchronization
          MSSQL 2016: Availability ReplicaMSSQL 2016: Availability Replica
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitorAvailability Replica Health
            Policy
          MSSQL 2016: Availability Replica
            Critical Policy
          MSSQL 2016: Availability Replica
            Critical Policy
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitorAvailability Replica Health
            Policy
          MSSQL 2016: Availability Replica
            Warning Policy
          MSSQL 2016: Availability Replica
            Warning Policy
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaIsJoinedAvailability Replica Join StateMSSQL 2016: Availability ReplicaMSSQL 2016: Availability Replica
          Microsoft.SQLServer.2016.AlwaysOn.RoleOfAvailabilityReplicaIsHealthyAvailability Replica RoleMSSQL 2016: Availability ReplicaMSSQL 2016: Availability Replica
          Microsoft.SQLServer.2016.AlwaysOn.AllAvailabilityReplicasAreConnectedAvailability Replicas Connection
            monitor
          MSSQL 2016: Availability Group
            Health
          MSSQL 2016: Availability Group
            Health
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizingAvailability Replicas Data
            Synchronization monitor
          MSSQL 2016: Availability Group
            Health
          MSSQL 2016: Availability Group
            Health
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicaRoleStateAvailability Replicas Role
            monitor
          MSSQL 2016: Availability Group
            Health
          MSSQL 2016: Availability Group
            Health
          Microsoft.SQLServer.2016.Monitoring.HashIndexAvgChainLengthMonitorAverage length of the row chains
            in the hash buckets
          SQL Server 2016 DB
            Memory-Optimized Data Filegroup
          SQL Server 2016 DB
            Memory-Optimized Data Filegroup
          MSSQL 2016: Average length of
            the row chains in the hash buckets Error
          Microsoft.SQLServer.2016.DBEngine.AverageWaitTimeMonitorAverage Wait TimeSQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: DB Average Wait Time
            is too high
          Microsoft.SQLServer.2016.DBEngine.BlockedSPIDsMonitorBlocking SessionsSQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: Blocked Session(s)
          Microsoft.SQLServer.2016.DBEngine.BufferCacheHitRatioMonitorBuffer Cache Hit RatioSQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: Buffer Cache Hit
            Ratio is too low
          Microsoft.SQLServer.2016.DBEngine.CPUUsagePercentMonitorCPU Utilization (%)SQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: CPU Utilization (%)
            is too high
          Microsoft.SQLServer.2016.Database.DBBackupStatusMonitorDatabase Backup StatusSQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Database backup
            should be performed
          Microsoft.SQLServer.2016.DBErrorUserPolicyStateMonitorDatabase Health PolicySQL Server 2016 Database
            Critical Policy
          SQL Server 2016 Database
            Critical Policy
          Microsoft.SQLServer.2016.DBWarningUserPolicyStateMonitorDatabase Health PolicySQL Server 2016 Database Warning
            Policy
          SQL Server 2016 Database Warning
            Policy
          Microsoft.SQLServer.2016.Mirroring.DatabaseStateMonitorDatabase Mirror StatusSQL 2016 Mirrored DBSQL 2016 Mirrored DBDatabase Mirror is not
            Synchronized
          Microsoft.SQLServer.2016.Mirroring.WitnessStateMonitorDatabase Mirror Witness StatusSQL 2016 Mirrored DBSQL 2016 Mirrored DBDatabase Mirror Witness is not
            accessible
          Microsoft.SQLServer.2016.Mirroring.PartnersStateMonitorDatabase Mirroring Partners
            Status
          SQL 2016 Mirrored DB WitnessSQL 2016 Mirrored DB WitnessDatabase mirroring partners are
            not synchronized
          Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitorDatabase Replica Health PolicyMSSQL 2016: Database Replica
            Critical Policy
          MSSQL 2016: Database Replica
            Critical Policy
          Microsoft.SQLServer.2016.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitorDatabase Replica Health PolicyMSSQL 2016: Database Replica
            Warning Policy
          MSSQL 2016: Database Replica
            Warning Policy
          Microsoft.SQLServer.2016.Database.DBStatusMonitorDatabase StatusSQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Database is in
            offline/recovery pending/suspect/emergency state
          Microsoft.SQLServer.2016.Database.Configuration.DBChainingDB Chaining ConfigurationSQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: DB Chaining
            Configuration Error
          Microsoft.SQLServer.2016.Monitoring.DBFileSpaceMonitorDB File Free Space LeftSQL Server 2016 DB FileSQL Server 2016 DB FileMSSQL 2016: DB File is running
            out of space
          Microsoft.SQLServer.2016.Monitoring.DBFileStreamGroupSpaceMonitorDB FILESTREAM Filegroup Free
            Space
          SQL Server 2016 DB FILESTREAM
            Filegroup
          SQL Server 2016 DB FILESTREAM
            Filegroup
          MSSQL 2016: DB FILESTREAM
            Filegroup data container is running out of space
          Microsoft.SQLServer.2016.Database.DBSizePercentMonitorDB Free Space LeftSQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Database is Out of
            Space
          Microsoft.SQLServer.2016.Monitoring.DBLogFileSpaceMonitorDB Log File Free Space LeftSQL Server 2016 DB Log FileSQL Server 2016 DB Log FileMSSQL 2016: DB Log File is
            running out of space
          Microsoft.SQLServer.2016.Database.DBSizePercentageChangeMonitorDB Space Percentage ChangeSQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Significant
            Percentage Change in DB Total Free Space
          Microsoft.SQLServer.2016.Database.LogShippingDestinationMonitorDestination Log ShippingSQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Log Shipping
            Destination
          Microsoft.SQLServer.2016.Database.DiskReadLatencyMonitorDisk Read LatencySQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Disk read latency is
            too high
          Microsoft.SQLServer.2016.Database.DiskWriteLatencyMonitorDisk Write LatencySQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Disk write latency
            is too high
          Microsoft.SQLServer.2016.Monitoring.HashIndexEmptyBucketsCountMonitorEmpty Bucket percent in the hash
            index
          SQL Server 2016 DB
            Memory-Optimized Data Filegroup
          SQL Server 2016 DB
            Memory-Optimized Data Filegroup
          MSSQL 2016: Empty Bucket percent
            in the hash index
          Microsoft.SQLServer.2016.AgentJob.JobDurationJob DurationSQL Server 2016 Agent JobSQL Server 2016 Agent Job
          Microsoft.SQLServer.2016.AgentJob.JobLastRunStateLast Run StatusSQL Server 2016 Agent JobSQL Server 2016 Agent Job
          Microsoft.SQLServer.2016.Agent.LongRunningJobsLong Running JobsSQL Server 2016 AgentSQL Server 2016 AgentMSSQL 2016: Long Running Jobs
          Microsoft.SQLServer.2016.UnitMonitor.DBEngine.SmartAdminSystemHealthPolicyManaged Backup System Health
            Policy
          SQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: The Managed Backup
            System Health Policy failed.
          Microsoft.SQLServer.2016.UnitMonitor.DBEngine.SmartAdminUserActionHealthPolicyManaged Backup User Action
            Health Policy
          SQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: The Managed Backup
            User Action Health Policy evaluates warnings such as corrupted backups, etc.
          Microsoft.SQLServer.2016.Monitor.Container.FreeSpacePercentMemory-Optimized Data Filegroup
            Container Free Space
          SQL Server 2016 DB
            Memory-Optimized Data Container
          SQL Server 2016 DB
            Memory-Optimized Data Container
          MSSQL 2016: Insufficient Free
            Space for Memory-Optimized Data Filegroup Container
          Microsoft.SQLServer.2016.Monitor.DBFileGroupFx.StaleCFPsMemory-Optimized Data Stale
            Checkpoint File Pairs Ratio
          SQL Server 2016 DB
            Memory-Optimized Data Filegroup
          SQL Server 2016 DB
            Memory-Optimized Data Filegroup
          MSSQL 2016: The portion of stale
            CFPs is above the thresholds
          Microsoft.SQLServer.2016.DBEngine.PageLifeExpectancyMonitorPage Life ExpectancySQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: Page Life Expectancy
            is too low
          Microsoft.SQLServer.2016.Database.Configuration.TornPageDetectionPage Verify ConfigurationSQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Page Verify
            Configuration Error
          Microsoft.SQLServer.2016.Database.Configuration.RecoveryModelRecovery Model ConfigurationSQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Recovery Model
            Configuration Error
          Microsoft.SQLServer.2016.Monitor.UserResourcePool.MemoryConsumptionResource Pool Memory ConsumptionSQL Server 2016 User Resource
            Pool
          SQL Server 2016 User Resource
            Pool
          MSSQL 2016: Memory-Optimized
            Data: Resource Pool is using too much memory.
          Microsoft.SQLServer.2016.DBEngine.Configuration.ServicePackLevelService Pack ComplianceSQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: Service Pack
            Compliance
          Microsoft.SQLServer.2016.DBEngine.Configuration.SPNStatusMonitorService Principal Name
            Configuration Status
          SQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: SQL Server cannot
            authenticate using Kerberos because the Service Principal Name (SPN) is
            missing, misplaced, or duplicated.
          Microsoft.SQLServer.2016.Database.LogShippingSourceMonitorSource Log ShippingSQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Log Shipping Source
          Microsoft.SQLServer.2016.DBEngine.FullTextSearchServiceMonitorSQL Full-text Filter Daemon
            Launcher Service
          SQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: SQL Full-text Filter
            Daemon Launcher Service Stopped
          Microsoft.SQLServer.2016.DBEngine.SQLReCompilationMonitorSQL Re-CompilationSQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: SQL Re-Compilation
            is too high
          Microsoft.SQLServer.2016.Agent.ServiceMonitorSQL Server Agent Windows ServiceSQL Server 2016 AgentSQL Server 2016 AgentMSSQL 2016: SQL Server Agent
            Windows Stopped
          Microsoft.SQLServer.2016.IntegrationServices.ServiceMonitorSQL Server Integration Services
            Windows Service
          SQL Server 2016 Integration
            Services
          SQL Server 2016 Integration
            Services
          MSSQL 2016: SQL Server
            Integration Services Windows Service Stopped
          Microsoft.SQLServer.2016.DBEngine.ServiceMonitorSQL Server Windows ServiceSQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: SQL Server Service
            Stopped
          Microsoft.SQLServer.2016.Database.ServiceMonitorSQL Server Windows ServiceSQL Server 2016 DBSQL Server 2016 DB
          Microsoft.SQLServer.2016.DBEngine.StolenServerMemoryMonitorStolen Server MemorySQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: Stolen Server Memory
            is too high
          Microsoft.SQLServer.2016.AlwaysOn.AvailabilityReplicasSynchronizationStateSynchronous Replicas Data
            Synchronization monitor
          MSSQL 2016: Availability Group
            Health
          MSSQL 2016: Availability Group
            Health
          Microsoft.SQLServer.2016.DBEngine.ThreadCountMonitorThread CountSQL Server 2016 DB EngineSQL Server 2016 DB EngineMSSQL 2016: Thread Count is too
            high
          Microsoft.SQLServer.2016.Database.TransactionLogSpaceFreePercentMonitorTransaction Log Free Space (%)SQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Transaction Log Free
            Space (%) is too low
          Microsoft.SQLServer.2016.Database.Configuration.TrustWorthyTrustworthy ConfigurationSQL Server 2016 DBSQL Server 2016 DBMSSQL 2016: Trustworthy
            Configuration Error
          Microsoft.SQLServer.2016.AlwaysOn.ClusterStateMonitorWSFC Cluster monitorMSSQL 2016: Availability Group
            Health
          MSSQL 2016: Availability Group
            Health
          Microsoft.SQLServer.2016.Monitoring.XTPConfigurationMonitorXTP ConfigurationSQL Server 2016 DB
            Memory-Optimized Data Filegroup
          SQL Server 2016 DB
            Memory-Optimized Data Filegroup
          MSSQL 2016: XTP Configuration
            Error