• State Verified Answer
  • Locked Locked
  • Replies 2 replies
  • Subscribers 38 subscribers
  • Views 802 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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
  • 0

    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
  • 0 in reply to orioncrack

    Hello OC,

    Thank you for sharing an information. Can you please give me few steps to monitor this like few images or process through which I can create the same. I don't have much idea about it.

    Thanks once again.

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.