¿Alerting when a database is offline?

mdecima

Hi.

I have several databases monitored using Appinsight in SAM 6.2.2, i never realized until today, that there is no alert when a database goes offline.

as stated in this KB article

When a database goes offline, an alert is never fired - SolarWinds Worldwide, LLC. Help and Support

¿How in the name of all the circles of hell can i have one alert when a database is offline?

Help, guidance, kind words would be much appreciated.

Thanks in advance.

orioncrack

SolarWinds SQL AppInsight doesn't do comprehensive Event ID alerting.

So, you must create them yourself.

SQL database offline is Event ID: 5084 

Someday we'll have comprehensive SQL monitoring of the below objects and not all of the silly WMI counters from SQL Appinsight...

Sorry to sound angry, but my god, SQL AppInsight still lacks such basic capabilities and doens't do any of the below or what the OP asks. How can a SQL monitoring product not tell you when your DB is offline? SCOM sure does.
 

Here are the SQL events that my DBAs need. No more WMI noise under the supposed guiose of "Monitorting" please.

Microsoft.SQLServer.2012.Database.Configuration.AutoClose

Microsoft.SQLServer.2012.Database.Configuration.AutoCreateStat

Microsoft.SQLServer.2012.Database.Configuration.AutoShrink

Microsoft.SQLServer.2012.Database.Configuration.AutoUpdateStatAsync

Microsoft.SQLServer.2012.Database.Configuration.AutoUpdateSet

Microsoft.SQLServer.2012.AlwaysOn.DbrDataSynchronizationState

Microsoft.SQLServer.2012.AlwaysOn.DbrJoinState

Microsoft.SQLServer.2012.AlwaysOn.DbrSuspendState

Microsoft.SQLServer.2012.AlwaysOn.AutomaticFailoverReadiness

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroupErrorPolicyStateMonitor

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroupWarningPolicyStateMonitor

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityGroupOnline

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaIsConnected

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaDataSynchronizationHealth

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaErrorPolicyStateMonitor

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaWarningPolicyStateMonitor

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaIsJoined

Microsoft.SQLServer.2012.AlwaysOn.RoleOfAvailabilityReplicaIsHealthy

Microsoft.SQLServer.2012.AlwaysOn.AllAvailabilityReplicasAreConnected

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicasSynchronizing

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicaRoleState

Microsoft.SQLServer.2012.DBEngine.BlockedSPIDsMonitor

Microsoft.SQLServer.2012.Database.DBBackupStatusMonitor

Microsoft.SQLServer.2012.DBErrorUserPolicyStateMonitor

Microsoft.SQLServer.2012.DBWarningUserPolicyStateMonitor

Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplicaErrorPolicyStateMonitor

Microsoft.SQLServer.2012.AlwaysOn.DatabaseReplicaWarningPolicyStateMonitor

Microsoft.SQLServer.2012.Database.DBStatusMonitor

Microsoft.SQLServer.2012.Database.Configuration.DBChaining

Microsoft.SQLServer.2012.Monitoring.DBFileSpaceMonitor

Microsoft.SQLServer.2012.Monitoring.DBLogFileSpaceMonitor

Microsoft.SQLServer.2012.Database.DBSizePercentageChangeMonitor

Microsoft.SQLServer.2012.Database.DBSizePercentMonitor

Microsoft.SQLServer.2012.Database.LogShippingDestinationMonitor

Microsoft.SQLServer.2012.AgentJob.JobDuration

Microsoft.SQLServer.2012.AgentJob.JobLastRunState

Microsoft.SQLServer.2012.Agent.LongRunningJobs

Microsoft.SQLServer.2012.Database.Configuration.TornPageDetection

Microsoft.SQLServer.2012.Database.Configuration.RecoveryModel

Microsoft.SQLServer.2012.DBEngine.Configuration.ServicePackLevel

Microsoft.SQLServer.2012.DBEngine.Configuration.SPNStatusMonitor

Microsoft.SQLServer.2012.Database.LogShippingSourceMonitor

Microsoft.SQLServer.2012.Agent.ServiceMonitor

Microsoft.SQLServer.2012.AnalysisServices.ServiceMonitor

Microsoft.SQLServer.2012.DBEngine.FullTextSearchServiceMonitor

Microsoft.SQLServer.2012.IntegrationServices.ServiceMonitor

Microsoft.SQLServer.2012.ReportingServices.ServiceMonitor

Microsoft.SQLServer.2012.DBEngine.ServiceMonitor

Microsoft.SQLServer.2012.Database.ServiceMonitor

Microsoft.SQLServer.2012.DBEngine.UserConnectionsBaselineMonitor

Microsoft.SQLServer.2012.AlwaysOn.AvailabilityReplicasSynchronizationState

Microsoft.SQLServer.2012.Database.Configuration.TrustWorthy

Microsoft.SQLServer.2012.AlwaysOn.ClusterStateMonitor

 

Microsoft.SQLServer.2012._.NET_Framework_runtime_was_shut_down_by_user_code_5_Rule

Microsoft.SQLServer.2012.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.2012.A_fatal_error_occurred_in_.NET_Framework_runtime_5_Rule

Microsoft.SQLServer.2012.A_security__SSPI__error_occurred_when_connecting_to_another_Service_Broker_or_Database_Mirroring_host_5_Rule

Microsoft.SQLServer.2012.Agent_shutdown._For_more_information_see_the_SQL_Server_Agent_job_history_for_job_1_5_Rule

Microsoft.SQLServer.2012.Alert_engine_stopped_due_to_unrecoverable_local_eventlog_errors_1_5_Rule

Microsoft.SQLServer.2012.AlwaysOn.ScriptFailedRule

Microsoft.SQLServer.2012.An_error_occurred_in_a_SQL_Server_Service_Broker_Database_Mirroring_transport_connection_endpoint_1_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_in_the_Service_Broker_manager_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_in_the_Service_Broker_queue_rollback_handler_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_in_the_SQL_Server_Service_Broker_message_dispatcher_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_in_the_SQL_Server_Service_Broker_message_transmitter_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_in_the_SQL_Server_Service_Broker_or_Database_Mirroring_transport_manager_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_in_the_timer_event_cache_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_when_the_service_attempted_to_shrink_the_database_connection_pool__5_Rule

Microsoft.SQLServer.2012.An_error_occurred_while_closing_the_trace_output_file_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_while_data_was_being_written_to_the_query_log_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_while_processing_SQL_Server_Service_Broker_mirroring_routes_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_while_processing_the_log_for_database_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_while_starting_the_error_log_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_while_starting_the_flight_recorder_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_while_starting_the_query_log_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_while_stopping_the_error_log_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_while_stopping_the_query_log_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_while_the_query_log_table_was_being_created_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_while_writing_a_trace_event_to_the_file_5_Rule

Microsoft.SQLServer.2012.An_error_occurred_while_writing_a_trace_event_to_the_rowset_5_Rule

Microsoft.SQLServer.2012.An_SNI_call_failed_during_a_Service_Broker_Database_Mirroring_transport_operation_1_5_Rule

Microsoft.SQLServer.2012.A_SQL_job_failed_to_complete_successfully_1_5_Rule

Microsoft.SQLServer.2012.A_SQL_Server_Service_Broker_conversation_closed_due_to_an_error_5_Rule

Microsoft.SQLServer.2012.A_SQL_Server_Service_Broker_cryptographic_operation_failed_5_Rule

Microsoft.SQLServer.2012.An_SQL_Server_Service_Broker_dialog_caught_an_error_5_Rule

Microsoft.SQLServer.2012.A_SQL_Server_Service_Broker_procedure_output_results_5_Rule

Microsoft.SQLServer.2012.AppDomain_failed_to_unload_with_error_code_5_Rule

Microsoft.SQLServer.2012.Attempt_to_fetch_logical_page_that_belongs_to_different_object_5_Rule

Microsoft.SQLServer.2012.AWE__Could_not_use_Address_Windowing_Extensions_because__lock_pages_in_memory__privilege_was_not_granted_5_Rule

Microsoft.SQLServer.2012.Background_lazy_processing_failed_because_of_an_error_5_Rule

Microsoft.SQLServer.2012.Backup_device_failed___Operating_system_error_1_5_Rule

Microsoft.SQLServer.2012.AlwaysOn.BytesReceivedFromReplicaPerSecond

Microsoft.SQLServer.2012.AlwaysOn.BytesSentToReplicaPerSecond

Microsoft.SQLServer.2012.AlwaysOn.BytesSentToTransportPerSecond

Microsoft.SQLServer.2012.Cannot_determine_the_service_account_for_SQL_Server_instance_1_5_Rule

Microsoft.SQLServer.2012.Cannot_open_backup_device.__1_5_Rule

Microsoft.SQLServer.2012.Cannot_open_user_default_database._Login_failed_1_5_Rule

Microsoft.SQLServer.2012.Cannot_recover_the_master_database._Exiting_1_5_Rule

Microsoft.SQLServer.2012.Cannot_start_service_broker_activation_manager_5_Rule

Microsoft.SQLServer.2012.Cannot_start_service_broker_manager_5_Rule

Microsoft.SQLServer.2012.Cannot_start_service_broker_manager_due_to_operating_system_error_5_Rule

Microsoft.SQLServer.2012.Cannot_start_service_broker_security_manager_5_Rule

Microsoft.SQLServer.2012.Cannot_start_SQL_Server_Service_Broker_on_Database_5_Rule

Microsoft.SQLServer.2012.Check_sum_failure_while_page_in_cache_id832

Microsoft.SQLServer.2012.CHECKTABLE_processing_of_object_encountered_page_twice._Possible_internal_error_or_allocation_fault_1_5_Rule

Microsoft.SQLServer.2012.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.2012.Commit_of_internal_MSDTC_transaction_failed_1_5_Rule

Microsoft.SQLServer.2012.Common_Language_Runtime__CLR__not_installed_properly_5_Rule

Microsoft.SQLServer.2012.Conflict_table__does_not_exist_1_5_Rule

Microsoft.SQLServer.2012.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.2012.Could_not_allocate_space_for_object__in_database__because_the__filegroup_is_full_1_5_Rule

Microsoft.SQLServer.2012.Could_not_connect_to_server_because_it_is_not_defined_as_a_remote_login_at_the_server_1_5_Rule

Microsoft.SQLServer.2012.Could_not_create_a_statement_object_using_OLE_DB_provider_1_5_Rule

Microsoft.SQLServer.2012.Could_not_create_an_instance_of_OLE_DB_provider_1_5_Rule

Microsoft.SQLServer.2012.Could_not_create_AppDomain_manager_5_Rule

Microsoft.SQLServer.2012.Could_not_do_cleanup_for_the_killed_process_1_5_Rule

Microsoft.SQLServer.2012.Could_not_find_CHECK_constraint_although_the_table_is_flagged_as_having_one_1_5_Rule

Microsoft.SQLServer.2012.Could_not_find_filegroup_ID_in_sys.filegroups_for_database_5_Rule

Microsoft.SQLServer.2012.Could_not_find_FOREIGN_KEY_constraints_for_table_although_the_table_is_flagged_as_having_them_1_5_Rule

Microsoft.SQLServer.2012.Could_not_mark_database_as_suspect._Getnext_NC_scan_on_sysdatabases.dbid_failed_1_5_Rule

Microsoft.SQLServer.2012.Could_not_obtain_exclusive_lock_on_database_5_Rule

Microsoft.SQLServer.2012.Could_not_obtain_information_about_Windows_NT_group_user_1_5_Rule

Microsoft.SQLServer.2012.Could_not_open_error_log_file_1_5_Rule

Microsoft.SQLServer.2012.Could_not_open_referenced_table_1_5_Rule

Microsoft.SQLServer.2012.Could_not_open_tempdb.__Cannot_continue_1_5_Rule

Microsoft.SQLServer.2012.Could_not_read_and_latch_page_1_5_Rule

Microsoft.SQLServer.2012.Could_not_recover_database_due_to_unresolved_transaction_outcomes_1_5_Rule

Microsoft.SQLServer.2012.Could_not_resolve_the_referenced_column_name_in_table_1_5_Rule

Microsoft.SQLServer.2012.Could_not_write_a_CHECKPOINT_record_in_database_because_the_log_is_out_of_space_1_5_Rule

Microsoft.SQLServer.2012.CREATE_DATABASE_failed._Could_not_allocate_enough_disk_space_for_a_new_database_on_the_named_disks_1_5_Rule

Microsoft.SQLServer.2012.Database_Backup_Failed_To_Complete_1_5_Rule

Microsoft.SQLServer.2012.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.2012.DBCC_executed_found_no_errors_Rule

Microsoft.SQLServer.2012.DBCC_executed_found_and_not_repaired_errors_Rule

Microsoft.SQLServer.2012.DBCC_executed_found_and_repaired_errors_Rule

Microsoft.SQLServer.2012.Database_log_file_is_full._Back_up_the_transaction_log_for_the_database_to_free_up_some_log_space_1_5_Rule

Microsoft.SQLServer.2012.Descriptor_for_object_in_database_not_found_in_the_hash_table_during_attempt_to_unhash_it_1_5_Rule

Microsoft.SQLServer.2012.Distributed_transaction_aborted_by_MSDTC_1_5_Rule

Microsoft.SQLServer.2012.Enlist_of_MSDTC_transaction_failed_1_5_Rule

Microsoft.SQLServer.2012.Error_recovering_database_._Could_not_connect_to_MSDTC_to_check_the_completion_status_of_transaction_1_5_Rule

Microsoft.SQLServer.2012.Error_reported_from_Message_Manager.__5_Rule

Microsoft.SQLServer.2012.Error_while_undoing_logged_operation_in_database__1_5_Rule

Microsoft.SQLServer.2012.Failed_to_add_column__to_table__1_5_Rule

Microsoft.SQLServer.2012.Failed_to_allocate_memory_for_Common_Language_Runtime__CLR__5_Rule

Microsoft.SQLServer.2012.Failed_to_create_AppDomain_5_Rule

Microsoft.SQLServer.2012.Failed_to_drop_column__from_table__1_5_Rule

Microsoft.SQLServer.2012.Failed_to_finish_full_text_operation._The_filegroup_is_empty_read_only_or_not_online_5_Rule

Microsoft.SQLServer.2012.Failed_to_initialize_the_Common_Language_Runtime__CLR__due_to_memory_pressure_5_Rule

Microsoft.SQLServer.2012.Failed_to_initialize_the_Common_Language_Runtime__CLR__with_HRESULT_5_Rule

Microsoft.SQLServer.2012.Failed_to_initialize_the_Common_Language_Runtime__CLR__with_HRESULT_1_5_Rule

Microsoft.SQLServer.2012.Operating_system_error_during_creation_opening_of_physical_device_1_5_Rule

Microsoft.SQLServer.2012.Could_not_open_device_1_5_Rule

Microsoft.SQLServer.2012.Failed_to_restore_master_database._Shutting_down_SQL_Server_5_Rule

Microsoft.SQLServer.2012.Database_could_not_recover_1_5_Rule

Microsoft.SQLServer.2012.AlwaysOn.FileBytesReceivedPerSecond

Microsoft.SQLServer.2012.AlwaysOn.FlowControlPerSecond

Microsoft.SQLServer.2012.AlwaysOn.FlowControlTimeSeconds

Microsoft.SQLServer.2012.Full_Text_Search___An_unknown_full_text_failure_occurred_1_5_Rule

Microsoft.SQLServer.2012.Full_Text_Search___Could_not_find_full_text_index_for_database_1_5_Rule

Microsoft.SQLServer.2012.Full_Text_Search___Full_text_catalog_is_in_a_unusable_state._Drop_and_re_create_this_full_text_catalog_1_5_Rule

Microsoft.SQLServer.2012.Full_Text_Search___Full_text_catalog_lacks_sufficient_disk_space_to_complete_this_operation_1_5_Rule

Microsoft.SQLServer.2012.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.2012.Full_Text_Search___Search_on_full_text_catalog_failed_with_unknown_result_1_5_Rule

Microsoft.SQLServer.2012.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.2012.Internal_Query_Processor_Error__The_query_processor_could_not_obtain_access_to_a_required_interface_1_5_Rule

Microsoft.SQLServer.2012.Internal_Query_Processor_Error__The_query_processor_encountered_an_internal_limit_overflow_1_5_Rule

Microsoft.SQLServer.2012.Internal_Query_Processor_Error__The_query_processor_encountered_an_unexpected_error_during_execution_1_5_Rule

Microsoft.SQLServer.2012.Internal_Query_Processor_Error__The_query_processor_encountered_an_unexpected_error_during_the_processing_of_a_remote_query_phase_1_5_Rule

Microsoft.SQLServer.2012.Internal_Query_Processor_Error__The_query_processor_ran_out_of_stack_space_during_query_optimization_1_5_Rule

Microsoft.SQLServer.2012.Could_not_open_FCB_for_invalid_file_in_database__1_5_Rule

Microsoft.SQLServer.2012.Invalid_reference_to_LOB_page_id7105

Microsoft.SQLServer.2012.IO_Completion_Listener_Worker_appears_to_be_non_yielding_on_Node_5_Rule

Microsoft.SQLServer.2012.IS_Package_Failed_5_Rule

Microsoft.SQLServer.2012.IS_Service_failed_to_load_user_defined_Configuration_file_5_Rule

Microsoft.SQLServer.2012.IS_Service_has_attempted_to_stop_a_running_package_5_Rule

Microsoft.SQLServer.2012.Job_step_cannot_be_run_because_the_subsystem_failed_to_load_1_5_Rule

Microsoft.SQLServer.2012.Log_Backup_Failed_to_Complete_1_5_Rule

Microsoft.SQLServer.2012.AlwaysOn.LogBytesReceivedPerSecond

Microsoft.SQLServer.2012.AlwaysOn.LogRemainingForUndo

Microsoft.SQLServer.2012.AlwaysOn.LogSendQueue

Microsoft.SQLServer.2012.Logical_consistency_error_after_performing_IO_on_page_id824

Microsoft.SQLServer.2012.Logical_page_in_database_is_already_hashed_1_5_Rule

Microsoft.SQLServer.2012.Login_failed._The_workstation_licensing_limit_for_SQL_Server_access_has_already_been_reached_5_Rule

Microsoft.SQLServer.2012.Login_failed__Account_locked_out_5_Rule

Microsoft.SQLServer.2012.Login_failed__Error_during_validation_5_Rule

Microsoft.SQLServer.2012.Login_failed__Password_cannot_be_used_at_this_time_5_Rule

Microsoft.SQLServer.2012.Login_failed__Password_expired_5_Rule

Microsoft.SQLServer.2012.Login_failed__Password_fails_password_filter_DLL_requirements_5_Rule

Microsoft.SQLServer.2012.Login_failed__Password_must_be_changed_5_Rule

Microsoft.SQLServer.2012.Login_failed__Password_too_long_5_Rule

Microsoft.SQLServer.2012.Login_failed__Password_too_short_5_Rule

Microsoft.SQLServer.2012.Login_failed__Password_too_simple_5_Rule

Microsoft.SQLServer.2012.Maximum_limit_for_connections_has_been_reached_1_5_Rule

Microsoft.SQLServer.2012.AlwaysOn.MirroredWriteTransactionsPerSecond

Microsoft.SQLServer.2012.MSDTC_on_server__is_unavailable_1_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Stored_Procedures_Invoked_sec__Total_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Task_Limit_Reached__Total_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Task_Limit_Reached_sec__Total_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Tasks_Aborted_sec__Total_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Tasks_Started_sec__Total_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_Broker_Transaction_Rollbacks_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_Enqueued_Messages_sec_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_Enqueued_Transport_Msgs_sec_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_SQL_RECEIVEs_sec_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_SQL_SENDs_sec_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Message_Fragment_Receives_sec_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Message_Fragment_Sends_sec_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Open_Connection_Count_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Receive_I_Os_sec_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Send_I_Os_sec_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.BufferCacheHitRatio

Microsoft.SQLServer.2012.Database.DBSize.Collection

Microsoft.SQLServer.2012.Database.DBSpaceFreePercent.Collection

Microsoft.SQLServer.2012.Database.DBSpaceFree.Collection

Microsoft.SQLServer.2012.DBFile.FileAllocatedSpaceLeftPercent.Collection

Microsoft.SQLServer.2012.DBFile.FileAllocatedSpaceLeftMB.Collection

Microsoft.SQLServer.2012.DBFile.SpaceFreePercent.Collection

Microsoft.SQLServer.2012.DBFile.SpaceFreeMegabytes.Collection

Microsoft.SQLServer.2012.DBFileGroup.FileGroupAllocatedSpaceLeftPercent.Collection

Microsoft.SQLServer.2012.DBFileGroup.FileGroupAllocatedSpaceLeftMB.Collection

Microsoft.SQLServer.2012.DBFileGroup.SpaceFreePercent.Collection

Microsoft.SQLServer.2012.DBFileGroup.SpaceFreeMegabytes.Collection

Microsoft.SQLServer.2012.DBLogFile.FileAllocatedSpaceLeftPercent.Collection

Microsoft.SQLServer.2012.DBLogFile.FileAllocatedSpaceLeftMB.Collection

Microsoft.SQLServer.2012.DBLogFile.SpaceFreePercent.Collection

Microsoft.SQLServer.2012.DBLogFile.SpaceFreeMegabytes.Collection

Microsoft.SQLServer.2012.UserConnectionsCollectionLearning

Microsoft.SQLServer.2012.LockTimeoutsPerSecond

Microsoft.SQLServer.2012.NumberDeadlocksPerSecond

Microsoft.SQLServer.2012.LockRequestsPerSecond

Microsoft.SQLServer.2012.LockWaitsPerSecond

Microsoft.SQLServer.2012.SQLCompilationsPerSecond

Microsoft.SQLServer.2012.SQLRecompilesPerSecond

Microsoft.SQLServer.2012.TransactionsPerSecond

Microsoft.SQLServer.2012.LoginsPerSecCollection

Microsoft.SQLServer.2012.UserConnectionsCollection

Microsoft.SQLServer.2012.No_slots_are_free_to_keep_buffers_for_table__1_5_Rule

Microsoft.SQLServer.2012.One_or_more_indexes_are_damaged_and_must_be_repaired_or_dropped_1_5_Rule

Microsoft.SQLServer.2012.Operating_System_error_encountered_1_5_Rule

Microsoft.SQLServer.2012.Operating_system_error_on_a_device_1_5_Rule

Microsoft.SQLServer.2012.Optimized_concurrent_query_limit_has_been_exceeded_1_5_Rule

Microsoft.SQLServer.2012.OSError_Occurred_While_Performing_IO_onpage_id823

Microsoft.SQLServer.2012.Package_execution_failed_because_the_checkpoint_file_cannot_be_loaded_5_Rule

Microsoft.SQLServer.2012.Permission_denied_on_object_1_5_Rule

Microsoft.SQLServer.2012.Potential_deadlocks_exist_on_all_schedulers_on_Node_5_Rule

Microsoft.SQLServer.2012.Process_Worker_appears_to_be_non_yielding_on_Scheduler_5_Rule

Microsoft.SQLServer.2012.AlwaysOn.ReceivesFromReplicaPerSecond

Microsoft.SQLServer.2012.Recovery_of_database__detected_possible_identity_value_inconsistency_in_table_1_5_Rule

Microsoft.SQLServer.2012.AlwaysOn.RecoveryQueue

Microsoft.SQLServer.2012.AlwaysOn.RedoBlockedSec

Microsoft.SQLServer.2012.AlwaysOn.RedoBytesRemaining

Microsoft.SQLServer.2012.AlwaysOn.RedoRate

Microsoft.SQLServer.2012.AlwaysOn.RedoneBytesPerSecond

Microsoft.SQLServer.2012.AlwaysOn.RecentMessagesPerSecond

Microsoft.SQLServer.2012.RESTORE_could_not_start_database_1_5_Rule

Microsoft.SQLServer.2012.Script_Failed_Database_Login

Microsoft.SQLServer.2012.AlwaysOn.SendsToReplicaPerSecond

Microsoft.SQLServer.2012.AlwaysOn.SendsToTransportPerSecond

Microsoft.SQLServer.2012.Service_Broker_was_not_able_to_allocate_memory_for_cryptographic_operations_5_Rule

Microsoft.SQLServer.2012.DBEngineServiceRestart

Microsoft.SQLServer.2012.SQL_Server_Assertion_1_5_Rule

Microsoft.SQLServer.2012.SQL_Server_Assertion_2_5_Rule

Microsoft.SQLServer.2012.SQL_Server_Assertion_3_5_Rule

Microsoft.SQLServer.2012.SQL_Server_cannot_start_the_Service_Broker_event_handler_5_Rule

Microsoft.SQLServer.2012.SQL_Server_could_not_allocate_enough_memory_to_start_Service_Broker_task_manager_5_Rule

Microsoft.SQLServer.2012.SQL_Server_SQL_Server_Service_Broker_attempted_to_use_an_unsupported_encryption_algorithm_5_Rule

Microsoft.SQLServer.2012.SQL_Server_Service_Broker_cannot_use_RC4_encryption_algorithm_when_running_in_FIPS_compliance_mode_5_Rule

Microsoft.SQLServer.2012.SQL_Server_Service_Broker_could_not_query_the_FIPS_compliance_mode_flag_from_the_registry_5_Rule

Microsoft.SQLServer.2012.SQL_Server_Service_Broker_Manager_has_shutdown_5_Rule

Microsoft.SQLServer.2012.SQL_Server_Service_Broker_or_Database_Mirror_cryptographic_call_failed_5_Rule

Microsoft.SQLServer.2012.SQL_Server_Service_Broker_or_Database_Mirroring_is_running_in_FIPS_compliance_mode_5_Rule

Microsoft.SQLServer.2012.SQL_Server_Service_Broker_or_Database_Mirroring_Transport_stopped_5_Rule

Microsoft.SQLServer.2012.SQL_Server_Service_Broker_transmitter_shut_down_due_to_an_exception_or_a_lack_of_memory_5_Rule

Microsoft.SQLServer.2012.SQL_Server_shutdown_due_to_Ctrl_C_or_Ctrl_Break_signal_1_5_Rule

Microsoft.SQLServer.2012.SQL_Server_terminating_because_of_system_shutdown_1_5_Rule

Microsoft.SQLServer.2012.SQLServerAgent_could_not_be_started_1_5_Rule

Microsoft.SQLServer.2012.SQLServerAgent_initiating_self_termination_1_5_Rule

Microsoft.SQLServer.2012._MSAS11_Connection_Current_connections_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.MSAS11_Data_Mining_Model_Processing_Current_models_processing_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.MSAS11_Data_Mining_Prediction_Concurrent_DM_queries_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.MSAS11_Memory_Memory_Limit_High_KB_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.MSAS11_Proc_Rows_read_sec_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.MSAS11_Proc_Rows_written_sec_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.MSAS11_Query_Avg_time_query_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.MSAS11_Query_Bytes_sent_sec_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.MSAS11_Query_Rows_sent_sec_15.0_minutes_5_Rule

Microsoft.SQLServer.2012.SQLServer_SSIS_Pipeline_Buffers_Spooled_15.0_minutes_2_Rule

Microsoft.SQLServer.2012.SQLServer_SSIS_Pipeline_Rows_Read_15.0_minutes_2_Rule

Microsoft.SQLServer.2012.SQLServer_SSIS_Pipeline_Rows_Written_15.0_minutes_2_Rule

Microsoft.SQLServer.2012.Starting_without_recovery_1_5_Rule

Microsoft.SQLServer.2012.Step_of_a_job_caused_an_exception_in_the_subsystem_1_5_Rule

Microsoft.SQLServer.2012.Table_error___Address_is_not_aligned_1_5_Rule

Microsoft.SQLServer.2012.Table_error___Test_failed._Slot_overlaps_with_the_prior_row_1_5_Rule

Microsoft.SQLServer.2012.Table_error___The_next_pointer_of_refers_to_page._Neither_its_parent_were_encountered._Possible_bad_chain_linkage_1_5_Rule

Microsoft.SQLServer.2012.Table_error___Unexpected_page_type__1_5_Rule

Microsoft.SQLServer.2012.Table_error__Allocation_page_has_invalid__page_header_values.__1_5_Rule

Microsoft.SQLServer.2012.Table_error__B_tree_chain_linkage_mismatch.__1_5_Rule

Microsoft.SQLServer.2012.Table_error__B_tree_level_mismatch_page_does_not_match_level_from_parent__1_5_Rule

Microsoft.SQLServer.2012.Table_error__B_tree_page_has_two_parent_nodes__1_5_Rule

Microsoft.SQLServer.2012.Table_error__Column_is_not_a_valid_complex_column_1_5_Rule

Microsoft.SQLServer.2012.Table_error__Cross_object_linkage_1_5_Rule

Microsoft.SQLServer.2012.Table_error__Cross_object_linkage._Page_PGID_next_is_not_in_the_same_index_1_5_Rule

Microsoft.SQLServer.2012.Table_error__Cross_object_linkage__Parent_page_in_object_next_refer_to_page_not_in_the_same_object_1_5_Rule

Microsoft.SQLServer.2012.Table_error__cross_object_chain_linkage_1_5_Rule

Microsoft.SQLServer.2012.Table_error__Extent_object_is_beyond_the_range_of_this_database_1_5_Rule

Microsoft.SQLServer.2012.Table_error__Extra_or_invalid_key_1_5_Rule

Microsoft.SQLServer.2012.Table_error__IAM_chain_linkage_error_1_5_Rule

Microsoft.SQLServer.2012.Table_error__IAM_page_is_linked_in_the_IAM_chain_for_object_1_5_Rule

Microsoft.SQLServer.2012.Table_error__Index_node_page_refers_to_child_page_and_previous_child_but_they_were_not_encountered_1_5_Rule

Microsoft.SQLServer.2012.Table_error__Object_index_page_Test_failed._Slot___Offset_is__invalid_1_5_Rule

Microsoft.SQLServer.2012.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.2012.Table_error__Page_in_its_header_is_allocated_by_another_object_1_5_Rule

Microsoft.SQLServer.2012.Table_error__Page_is_missing_a_reference_from_previous_page._Possible_chain_linkage_problem_1_5_Rule

Microsoft.SQLServer.2012.Table_error__Page_is_missing_references_from_parent__unknown__and_previous_nodes._Possible_bad_root_entry_in_sysindexes_1_5_Rule

Microsoft.SQLServer.2012.Table_error__page_is_out_of_the_range_of_this_database_1_5_Rule

Microsoft.SQLServer.2012.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.2012.Table_error__Parent_node_for_page_was_not_encountered_1_5_Rule

Microsoft.SQLServer.2012.Table_error__Slot_row_extends_into_free_space__1_5_Rule

Microsoft.SQLServer.2012.Table_error__Table_missing_or_invalid_key_in_index_for_the_row__1_5_Rule

Microsoft.SQLServer.2012.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.2012.Table_error__The_low_key_value_on_page__is_not_the_key_value_in_the_parent_1_5_Rule

Microsoft.SQLServer.2012.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.2012.Table_error__The_text_ntext_or_image_node_at_page__is_referenced_by_page_not_seen_in_the_scan_1_5_Rule

Microsoft.SQLServer.2012.Table_error__The_text_ntext_or_image_node_at_page_is_not_referenced_1_5_Rule

Microsoft.SQLServer.2012.Table_error__The_text_ntext_or_image_node_has_wrong_type_1_5_Rule

Microsoft.SQLServer.2012.Table_error__Wrong_PageId_in_the_page_header_1_5_Rule

Microsoft.SQLServer.2012.Table___No_columns_without_statistics_found_1_5_Rule

Microsoft.SQLServer.2012.Table__Creating_statistics_for_the_following_columns_1_5_Rule

Microsoft.SQLServer.2012.The_agent_is_suspect._No_response_within_last_minutes_1_5_Rule

Microsoft.SQLServer.2012.The_configuration_file_could_not_be_loaded_5_Rule

Microsoft.SQLServer.2012.The_configuration_file_could_not_be_saved_5_Rule

Microsoft.SQLServer.2012.The_database_cryptographic_key_could_not_be_loaded_5_Rule

Microsoft.SQLServer.2012.The_IO_operation_was_successful_after_retry_id825

Microsoft.SQLServer.2012.The_log_for_database_is_not_available_1_5_Rule

Microsoft.SQLServer.2012.The_Log_Reader_Agent_for_transactional_replication_encountered_an_invalid_log_sequence_number__LSN__when_reading_the_transaction_log_5_Rule

Microsoft.SQLServer.2012.The_LSN_passed_to_log_scan_in_database_is_invalid_5_Rule

Microsoft.SQLServer.2012.The_metadata_object_could_not_be_instantiated.__5_Rule

Microsoft.SQLServer.2012.The_metadata_object_could_not_be_linked.__5_Rule

Microsoft.SQLServer.2012.The_metadata_object_could_not_be_loaded_5_Rule

Microsoft.SQLServer.2012.The_MSSQLServer_service_terminated_unexpectedly_3_5_Rule

Microsoft.SQLServer.2012.The_OLE_DB_provider_reported_an_error_5_Rule

Microsoft.SQLServer.2012.The_operating_system_resource__event__could_not_be_created_during_initialization_of_the_lazy_writer.__5_Rule

Microsoft.SQLServer.2012.The_operating_system_resource__thread__could_not_be_created_during_the_initialization_of_the_lazy_writer_5_Rule

Microsoft.SQLServer.2012.The_package_restarted_from_checkpoint_file.__Package_was_configured_to_restart_from_checkpoint_and_it_did_5_Rule

Microsoft.SQLServer.2012.The_provider_reported_an_unexpected_catastrophic_failure_1_5_Rule

Microsoft.SQLServer.2012.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.2012.The_query_processor_could_not_start_the_necessary_thread_resources_for_parallel_query_execution_1_5_Rule

Microsoft.SQLServer.2012.The_server_is_too_busy_to_perform_the_backup_or_restore_operation_1_5_Rule

Microsoft.SQLServer.2012.The_Service_Broker_or_Database_Mirroring_Transport_has_started_5_Rule

Microsoft.SQLServer.2012.The_Service_Broker_Database_Mirroring_transport_cannot_listen_on_port_because_it_is_in_use_5_Rule

Microsoft.SQLServer.2012.The_Service_Broker_Database_Mirroring_Transport_could_not_listen_for_connections_due_to_an_error_5_Rule

Microsoft.SQLServer.2012.The_service_cannot_be_started_5_Rule

Microsoft.SQLServer.2012.The_SQL_Server_Service_Broker_or_Database_Mirroring_transport_is_disabled_or_not_configured_5_Rule

Microsoft.SQLServer.2012.The_trace_waited_too_long_for_the_TCP_rowset_sender_to_finish.__5_Rule

Microsoft.SQLServer.2012.The_user_is_not_allowed_to_truncate_the_system_table_1_5_Rule

Microsoft.SQLServer.2012.AlwaysOn.TotalLogRequiringUndo

Microsoft.SQLServer.2012.AlwaysOn.TransactionDelay

Microsoft.SQLServer.2012.Transaction_was_deadlocked_on_resources_with_another_process_and_has_been_chosen_as_the_deadlock_victim._Rerun_the_transaction_1_5_Rule

Microsoft.SQLServer.2012.Unable_to_connect_to_SQL_Server_1_5_Rule

Microsoft.SQLServer.2012.Unable_to_re_open_the_local_eventlog_1_5_Rule

Microsoft.SQLServer.2012.Unexpected_end_of_file_while_reading_beginning_of_backup_set_1_5_Rule

Microsoft.SQLServer.2012.Unique_table_computation_failed_1_5_Rule

Microsoft.SQLServer.2012.XML___Failed_to_instantiate_class._Make_sure_Msxml2.dll_exists_in_the_SQL_Server_installation_1_5_Rule

Microsoft.SQLServer.2012.XML___Failed_to_load_Msxml2.dll_1_5_Rule

Microsoft.SQLServer.2012.XML___FOR_XML_EXPLICIT_stack_overflow_occurred._Circular_parent_tag_relationships_are_not_allowed_1_5_Rule

Microsoft.SQLServer.2012.XML___Size_of_data_chunk_requested_from_the_stream_exceeds_allowed_limit_5_Rule

Microsoft.SQLServer.2012.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.2012.XML___XML_error_1_5_Rule

Microsoft.SQLServer.2012.XML___XML_parsing_error_1_5_Rule