| | DisplayName | Description | ID | Target | Category | Enabled | Instance Name | Counter Name | Frequency | Event_ID | Event Source | Alert Generate | Alert Severity | Alert Priority | Remotable | Event Log |
|---|
 | [Deprecated] Agent shutdown. For more information, see the SQL Server Agent job history for job. | | Microsoft.SQLServer.2012.Agent_shutdown._For_more_information_see_the_SQL_Server_Agent_job_history_for_job_1_5_Rule | Microsoft.SQLServer.2012.Agent | EventCollection | True | | | 0 | 20557 | $Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Alert engine stopped due to unrecoverable local event log errors | | Microsoft.SQLServer.2012.Alert_engine_stopped_due_to_unrecoverable_local_eventlog_errors_1_5_Rule | Microsoft.SQLServer.2012.Agent | EventCollection | True | | | 0 | 317 | $Target/Property[Type="SQL!Microsoft.SQLServer.Agent"]/ServiceName$ | True | Warning | Normal | True | Application |
| An error occurred in an SQL Server Service Broker/Database Mirroring transport connection endpoint | | Microsoft.SQLServer.2012.An_error_occurred_in_a_SQL_Server_Service_Broker_Database_Mirroring_transport_connection_endpoint_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9642 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred in the Service Broker manager | | Microsoft.SQLServer.2012.An_error_occurred_in_the_Service_Broker_manager_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9645 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred in the Service Broker queue rollback handler | | Microsoft.SQLServer.2012.An_error_occurred_in_the_Service_Broker_queue_rollback_handler_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8405 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred in the SQL Server Service Broker message dispatcher | | Microsoft.SQLServer.2012.An_error_occurred_in_the_SQL_Server_Service_Broker_message_dispatcher_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9644 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred in the SQL Server Service Broker message transmitter | | Microsoft.SQLServer.2012.An_error_occurred_in_the_SQL_Server_Service_Broker_message_transmitter_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 28072 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred in the SQL Server Service Broker, or Database Mirroring transport manager | | Microsoft.SQLServer.2012.An_error_occurred_in_the_SQL_Server_Service_Broker_or_Database_Mirroring_transport_manager_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9643 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred in the timer event cache | | Microsoft.SQLServer.2012.An_error_occurred_in_the_timer_event_cache_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9646 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred when the service attempted to shrink the database connection pool | | Microsoft.SQLServer.2012.An_error_occurred_when_the_service_attempted_to_shrink_the_database_connection_pool__5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 14 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred while closing the trace output file | | Microsoft.SQLServer.2012.An_error_occurred_while_closing_the_trace_output_file_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 10 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred while data was being written to the query log | | Microsoft.SQLServer.2012.An_error_occurred_while_data_was_being_written_to_the_query_log_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | Application |
| An error occurred while processing SQL Server Service Broker mirroring routes | | Microsoft.SQLServer.2012.An_error_occurred_while_processing_SQL_Server_Service_Broker_mirroring_routes_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9789 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred while reading the log for database | | Microsoft.SQLServer.2012.An_error_occurred_while_processing_the_log_for_database_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9004 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | High | True | Application |
| An error occurred while starting the error log | | Microsoft.SQLServer.2012.An_error_occurred_while_starting_the_error_log_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 16 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred while starting the flight recorder | | Microsoft.SQLServer.2012.An_error_occurred_while_starting_the_flight_recorder_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | Application |
| An error occurred while starting the query log | | Microsoft.SQLServer.2012.An_error_occurred_while_starting_the_query_log_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | Application |
| An error occurred while stopping the error log | | Microsoft.SQLServer.2012.An_error_occurred_while_stopping_the_error_log_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 17 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred while stopping the query log | | Microsoft.SQLServer.2012.An_error_occurred_while_stopping_the_query_log_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 15 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred while the query log table was being created | | Microsoft.SQLServer.2012.An_error_occurred_while_the_query_log_table_was_being_created_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | Application |
| An error occurred while writing a trace event to the file | | Microsoft.SQLServer.2012.An_error_occurred_while_writing_a_trace_event_to_the_file_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 11 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| An error occurred while writing a trace event to the rowset | | Microsoft.SQLServer.2012.An_error_occurred_while_writing_a_trace_event_to_the_rowset_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 12 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| An SNI call failed during a Service Broker/Database Mirroring transport operation | | Microsoft.SQLServer.2012.An_SNI_call_failed_during_a_Service_Broker_Database_Mirroring_transport_operation_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 8471 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| An SQL Server Service Broker dialog caught an error | | Microsoft.SQLServer.2012.An_SQL_Server_Service_Broker_dialog_caught_an_error_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9736 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| App Domain failed to unload with error code | | Microsoft.SQLServer.2012.AppDomain_failed_to_unload_with_error_code_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6291 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Attempt to fetch logical page that belongs to different object | | Microsoft.SQLServer.2012.Attempt_to_fetch_logical_page_that_belongs_to_different_object_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 605 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | High | True | Application |
| AWE: Could not use Address Windowing Extensions because 'lock pages in memory' privilege was not granted | | Microsoft.SQLServer.2012.AWE__Could_not_use_Address_Windowing_Extensions_because__lock_pages_in_memory__privilege_was_not_granted_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17179 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| A default full-text catalog does not exist in the database, or user does not have permission to perform this action | | 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.DBEngine | EventCollection | True | | | 0 | 9967 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| A fatal error occurred in .NET Framework runtime | | Microsoft.SQLServer.2012.A_fatal_error_occurred_in_.NET_Framework_runtime_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6536 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| A security (SSPI) error occurred when connecting to another Service Broker, or Database Mirroring host | | Microsoft.SQLServer.2012.A_security__SSPI__error_occurred_when_connecting_to_another_Service_Broker_or_Database_Mirroring_host_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9649 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| An SQL job failed to complete successfully | | Microsoft.SQLServer.2012.A_SQL_job_failed_to_complete_successfully_1_5_Rule | Microsoft.SQLServer.2012.Agent | EventCollection | False | | | 0 | 0 | | True | Error | Normal | True | Application |
| An SQL Server Service Broker conversation closed due to an error | | Microsoft.SQLServer.2012.A_SQL_Server_Service_Broker_conversation_closed_due_to_an_error_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9761 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| An SQL Server Service Broker cryptographic operation failed | | Microsoft.SQLServer.2012.A_SQL_Server_Service_Broker_cryptographic_operation_failed_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9641 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| An SQL Server Service Broker procedure output results | | Microsoft.SQLServer.2012.A_SQL_Server_Service_Broker_procedure_output_results_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 9724 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Information | Low | True | Application |
| Background lazy processing failed due to an error | | Microsoft.SQLServer.2012.Background_lazy_processing_failed_because_of_an_error_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 20 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| Backup device failed - Operating system error | | Microsoft.SQLServer.2012.Backup_device_failed___Operating_system_error_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 18204 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| MSSQL 2012: Collect Buffer Cache Hit Ratio | Collects the Windows "Buffer Cache Hit Ratio" performance counter for each instance of SQL 2012 DB Engine. | Microsoft.SQLServer.2012.BufferCacheHitRatio | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Buffer Manager | Buffer cache hit ratio | 900 | 0 | | False | | | True | |
| Cannot determine the service account for SQL Server instance | | Microsoft.SQLServer.2012.Cannot_determine_the_service_account_for_SQL_Server_instance_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 14353 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Cannot open backup device. | | Microsoft.SQLServer.2012.Cannot_open_backup_device.__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3201 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Cannot open user default database. Login failed | | Microsoft.SQLServer.2012.Cannot_open_user_default_database._Login_failed_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 4064 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Cannot recover the master database. Exiting | | Microsoft.SQLServer.2012.Cannot_recover_the_master_database._Exiting_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3417 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Cannot start service broker activation manager | | Microsoft.SQLServer.2012.Cannot_start_service_broker_activation_manager_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9701 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Cannot start service broker manager | | Microsoft.SQLServer.2012.Cannot_start_service_broker_manager_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9694 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Cannot start service broker manager due to operating system error | | Microsoft.SQLServer.2012.Cannot_start_service_broker_manager_due_to_operating_system_error_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 28002 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Cannot start service broker security manager | | Microsoft.SQLServer.2012.Cannot_start_service_broker_security_manager_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9698 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Cannot start SQL Server Service Broker on Database | | Microsoft.SQLServer.2012.Cannot_start_SQL_Server_Service_Broker_on_Database_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9697 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| CHECKTABLE processing of object encountered page twice. Possible internal error or allocation fault | | Microsoft.SQLServer.2012.CHECKTABLE_processing_of_object_encountered_page_twice._Possible_internal_error_or_allocation_fault_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8973 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| CHECKTABLE terminated. A failure was detected while collecting facts. | Possibly tempdb out of space, or a system table is inconsistent. Check previous errors. | 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.DBEngine | EventCollection | True | | | 0 | 8921 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Checksum failure while page in cache | | Microsoft.SQLServer.2012.Check_sum_failure_while_page_in_cache_id832 | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 832 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | High | True | Application |
| Commit of internal MSDTC transaction failed | | Microsoft.SQLServer.2012.Commit_of_internal_MSDTC_transaction_failed_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8520 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Common Language Runtime (CLR) not installed properly | | Microsoft.SQLServer.2012.Common_Language_Runtime__CLR__not_installed_properly_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6510 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Conflict table does not exist | | Microsoft.SQLServer.2012.Conflict_table__does_not_exist_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 21286 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| 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. | 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.DBEngine | EventCollection | True | | | 0 | 1101 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Could not allocate space for object in database because the Filegroup is full | | Microsoft.SQLServer.2012.Could_not_allocate_space_for_object__in_database__because_the__filegroup_is_full_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 1105 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Could not connect to server because it is not defined as a remote login at the server | | 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.DBEngine | EventCollection | True | | | 0 | 18483 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Could not create an instance of OLE DB provider | | Microsoft.SQLServer.2012.Could_not_create_an_instance_of_OLE_DB_provider_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 7302 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Could not create App Domain manager | | Microsoft.SQLServer.2012.Could_not_create_AppDomain_manager_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 10303 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Could not create a statement object using OLE DB provider | | Microsoft.SQLServer.2012.Could_not_create_a_statement_object_using_OLE_DB_provider_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 7305 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Could not do cleanup for the killed process | | Microsoft.SQLServer.2012.Could_not_do_cleanup_for_the_killed_process_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6103 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Could not find CHECK constraint, although the table is flagged as having one | | Microsoft.SQLServer.2012.Could_not_find_CHECK_constraint_although_the_table_is_flagged_as_having_one_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 433 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Could not find Filegroup ID in sys.Filegroups for database | | Microsoft.SQLServer.2012.Could_not_find_filegroup_ID_in_sys.filegroups_for_database_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8932 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Could not find FOREIGN KEY constraints for table, although the table is flagged as having them | | 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.DBEngine | EventCollection | True | | | 0 | 439 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Could not mark database as suspect. Getnext NC scan on sysdatabases.dbid failed | | Microsoft.SQLServer.2012.Could_not_mark_database_as_suspect._Getnext_NC_scan_on_sysdatabases.dbid_failed_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3413 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Could not obtain exclusive lock on database | | Microsoft.SQLServer.2012.Could_not_obtain_exclusive_lock_on_database_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 1807 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Could not obtain information about Windows NT group/user | | Microsoft.SQLServer.2012.Could_not_obtain_information_about_Windows_NT_group_user_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 15404 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Failed to open primary database file | | Microsoft.SQLServer.2012.Could_not_open_device_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17204 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | High | True | Application |
| Could not open error log file | | Microsoft.SQLServer.2012.Could_not_open_error_log_file_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17058 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Invalid reference to File ID | | Microsoft.SQLServer.2012.Could_not_open_FCB_for_invalid_file_in_database__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 5180 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | High | True | Application |
| Could not open referenced table | | Microsoft.SQLServer.2012.Could_not_open_referenced_table_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 436 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Could not open tempdb. Cannot continue | | Microsoft.SQLServer.2012.Could_not_open_tempdb.__Cannot_continue_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 1619 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Could not read and latch page | | Microsoft.SQLServer.2012.Could_not_read_and_latch_page_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8966 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Could not recover database due to unresolved transaction outcomes | | Microsoft.SQLServer.2012.Could_not_recover_database_due_to_unresolved_transaction_outcomes_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3431 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Could not resolve the referenced column name in table | | Microsoft.SQLServer.2012.Could_not_resolve_the_referenced_column_name_in_table_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 437 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Could not write a CHECKPOINT record in database because the log is out of space | | Microsoft.SQLServer.2012.Could_not_write_a_CHECKPOINT_record_in_database_because_the_log_is_out_of_space_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3619 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| CREATE DATABASE failed. Could not allocate enough disk space for a new database on the named disks | | 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.DBEngine | EventCollection | True | | | 0 | 1803 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| MSSQL 2012: Collect DB Active Connections count | SQL 2012 DBs Active Connections performance collection rule | Microsoft.SQLServer.2012.Database.ActiveConnections.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Active Requests count | SQL 2012 DBs Active Requests performance collection rule | Microsoft.SQLServer.2012.Database.ActiveRequests.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Active Sessions count | SQL 2012 DBs Active Sessions performance collection rule | Microsoft.SQLServer.2012.Database.ActiveSessions.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Active Transactions count | SQL 2012 DBs Active Transactions performance collection rule | Microsoft.SQLServer.2012.Database.ActiveTransactionsDB.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | $Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Databases | Active Transactions | 900 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Allocated Free Space (MB) | SQL 2012 DBs Allocated Free Space (MB) performance collection rule | Microsoft.SQLServer.2012.Database.DBAllocatedFreeSpaceMB.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Disk Free Space (MB) | SQL 2012 DBs Disk Free Space (MB) performance collection rule | Microsoft.SQLServer.2012.Database.DBDiskFreeSpaceMB.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect Database Allocated Size (MB) | Collect database allocated size | Microsoft.SQLServer.2012.Database.DBSize.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect Database Total Free Space (MB) | The amount of space left in the database for all files in all Filegroups for this database in megabytes. Also includes space left on media hosting a file with autogrowth enabled.
Please note that this rule collects metrics for ROWS data only. Metrics for FILESTREAM and for In-Memory OLTP data are ignored. | Microsoft.SQLServer.2012.Database.DBSpaceFree.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect Database Total Free Space (\%) | The amount of space left in the database for all files in all Filegroups for this database in percentage terms. Also includes space left on media hosting a file with autogrowth enabled.
Please note that this rule collects metrics for ROWS data only. Metrics for FILESTREAM and for In-Memory OLTP data are ignored. | Microsoft.SQLServer.2012.Database.DBSpaceFreePercent.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Used Space (MB) | SQL 2012 DBs Used Space (MB) performance collection rule | Microsoft.SQLServer.2012.Database.DBUsedSpaceMB.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Disk Read Latency (ms) | SQL 2012 DB Disk Read Latency (ms) performance collection rule. Gets maximum read disk latency from all logical disk which host database files | Microsoft.SQLServer.2012.Database.DiskReadLatency.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Disk Write Latency (ms) | SQL 2012 DB Disk Write Latency (ms) performance collection rule. Gets maximum Write disk latency from all logical disk which host database files. | Microsoft.SQLServer.2012.Database.DiskWriteLatency.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect Transaction Log Free Space (\%) | Collect unused transaction log space reported by SQL Server as a percentage of total transaction log space | Microsoft.SQLServer.2012.Database.TransactionLogSpaceFreePercent.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Transactions per second count | SQL 2012 DBs Transactions per second performance collection rule | Microsoft.SQLServer.2012.Database.TransactionsPerSecDB.Collection | Microsoft.SQLServer.2012.Database | PerformanceCollection | True | $Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Databases | Transactions/sec | 900 | 0 | | False | | | True | |
| Database Backup Failed To Complete | | Microsoft.SQLServer.2012.Database_Backup_Failed_To_Complete_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3041 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details | | 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.DBEngine | EventCollection | True | | | 0 | 945 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Failure occurred during database recovery | | Microsoft.SQLServer.2012.Database_could_not_recover_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3414 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | High | True | Application |
| Database log file is full. Back up the transaction log for the database to free up some log space | | 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.DBEngine | EventCollection | True | | | 0 | 9002 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Database consistency errors found | | Microsoft.SQLServer.2012.DBCC_executed_found_and_not_repaired_errors_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | Application |
| Database consistency errors found and repaired | | Microsoft.SQLServer.2012.DBCC_executed_found_and_repaired_errors_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | Application |
| Database consistency check performed with no errors | | Microsoft.SQLServer.2012.DBCC_executed_found_no_errors_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 0 | | True | Information | Low | True | Application |
| MSSQL 2012: Collect DB Engine Average Wait Time (ms) | SQL 2012 DB Engine Average Wait Time performance collection rule | Microsoft.SQLServer.2012.DBEngine.AverageWaitTime.Collection | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Locks | Average Wait Time (ms) | 900 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Engine CPU Utilization (\%) | SQL 2012 DB Engine CPU Utilization (\%) performance collection rule. | Microsoft.SQLServer.2012.DBEngine.CPUUsagePercent.Collection | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Engine Page Life Expectancy (s) | SQL 2012 DB Engine Page Life Expectancy (s) performance collection rule | Microsoft.SQLServer.2012.DBEngine.PageLifeExpectancy.Collection | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Engine Stolen Server Memory (MB) | SQL 2012 DB Engine Stolen Server Memory (MB) performance collection rule | Microsoft.SQLServer.2012.DBEngine.StolenServerMemory.Collection | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Engine Thread Count | SQL 2012 DB Engine Thread Count performance collection rule | Microsoft.SQLServer.2012.DBEngine.ThreadCount.Collection | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| SQL Server 2012 DB Engine is restarted | Detects SQL Server 2012 DB Engine restart. | Microsoft.SQLServer.2012.DBEngineServiceRestart | Microsoft.SQLServer.2012.DBEngine | AvailabilityHealth | False | | | 0 | 0 | | True | Warning | Normal | True | |
| MSSQL 2012: Collect DB File Allocated Free Space (MB) | The amount of space left in a file in megabytes. Does not include space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.2012.DBFile.FileAllocatedSpaceLeftMB.Collection | Microsoft.SQLServer.2012.DBFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB File Allocated Free Space (\%) | The amount of space left in a file in percentage terms. Does not include space left on media hosting a file with autogrowth enabled | Microsoft.SQLServer.2012.DBFile.FileAllocatedSpaceLeftPercent.Collection | Microsoft.SQLServer.2012.DBFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB File Free Space (MB) | The amount of space left in a file in megabytes. Also includes space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.2012.DBFile.SpaceFreeMegabytes.Collection | Microsoft.SQLServer.2012.DBFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB File Free Space (\%) | The amount of space left in a file in percentage terms. Also includes space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.2012.DBFile.SpaceFreePercent.Collection | Microsoft.SQLServer.2012.DBFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Filegroup Allocated Free Space (MB) | The amount of space left in all files for this Filegroup in megabytes. Does not include space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.2012.DBFileGroup.FileGroupAllocatedSpaceLeftMB.Collection | Microsoft.SQLServer.2012.DBFileGroup | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Filegroup Allocated Free Space (\%) | The amount of space left in all files for this Filegroup in percentage terms. Does not include space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.2012.DBFileGroup.FileGroupAllocatedSpaceLeftPercent.Collection | Microsoft.SQLServer.2012.DBFileGroup | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Filegroup Free Space (MB) | The amount of space left in all files for this Filegroup in megabytes. Also includes space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.2012.DBFileGroup.SpaceFreeMegabytes.Collection | Microsoft.SQLServer.2012.DBFileGroup | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Filegroup Free Space (\%) | Collects free database Filegroup space in percentage terms. | Microsoft.SQLServer.2012.DBFileGroup.SpaceFreePercent.Collection | Microsoft.SQLServer.2012.DBFileGroup | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: DB FILESTREAM Filegroup Free Space Total (MB) | Collects free FILESTREAM Filegroup data container space in megabytes. | Microsoft.SQLServer.2012.DBFileStream.FileGroup.SpaceFreeMegabytes.Collection | Microsoft.SQLServer.2012.DBFileGroupFd | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: DB FILESTREAM Filegroup Free Space Total (\%) | Collects free FILESTREAM Filegroup data container space in percentage terms. | Microsoft.SQLServer.2012.DBFileStream.FileGroup.SpaceFreePercent.Collection | Microsoft.SQLServer.2012.DBFileGroupFd | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Log File Allocated Free Space (MB) | The amount of space left in all log files for this database in megabytes. Does not include space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.2012.DBLogFile.FileAllocatedSpaceLeftMB.Collection | Microsoft.SQLServer.2012.DBLogFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Log File Allocated Free Space (\%) | The amount of space left in all log files for this database in percentage terms. Does not include space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.2012.DBLogFile.FileAllocatedSpaceLeftPercent.Collection | Microsoft.SQLServer.2012.DBLogFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Log File Free Space (MB) | The amount of space left in all log files for this database in megabytes. Also includes space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.2012.DBLogFile.SpaceFreeMegabytes.Collection | Microsoft.SQLServer.2012.DBLogFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2012: Collect DB Log File Free Space (\%) | The amount of space left in all log files for this database in percentage terms. Also includes space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.2012.DBLogFile.SpaceFreePercent.Collection | Microsoft.SQLServer.2012.DBLogFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Descriptor for object in database not found in the hash table during attempt to unhash it | | 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.DBEngine | EventCollection | True | | | 0 | 617 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Distributed transaction aborted by MSDTC | | Microsoft.SQLServer.2012.Distributed_transaction_aborted_by_MSDTC_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8522 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Enlist of MSDTC transaction failed | | Microsoft.SQLServer.2012.Enlist_of_MSDTC_transaction_failed_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8510 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Error recovering database. Could not connect to MSDTC to check the completion status of transaction | | Microsoft.SQLServer.2012.Error_recovering_database_._Could_not_connect_to_MSDTC_to_check_the_completion_status_of_transaction_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3437 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Error reported from Message Manager. | | Microsoft.SQLServer.2012.Error_reported_from_Message_Manager.__5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | Application |
| Error while undoing logged operation in database | | Microsoft.SQLServer.2012.Error_while_undoing_logged_operation_in_database__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3314 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Failed to add column to table | sp_repladdcolumn failed to add the specified column to the table in the publication database. If another error is reported along with this one, the other error should indicate the reason the column could not be added. If no other error is reported, the problem could be that the owner-qualified table does not exist, or the data type is not one that can be added to a replicated table. The data type of the new column must either be an identity, computed, or timestamp column; allow nulls; or have a default. For more information about sp_repladdcolumn, see "Schema Changes on Publication Databases" in Books Online. | Microsoft.SQLServer.2012.Failed_to_add_column__to_table__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 21285 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Failed to allocate memory for Common Language Runtime (CLR) | | Microsoft.SQLServer.2012.Failed_to_allocate_memory_for_Common_Language_Runtime__CLR__5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6289 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Failed to create App Domain | | Microsoft.SQLServer.2012.Failed_to_create_AppDomain_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6517 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Failed to drop column from table | | Microsoft.SQLServer.2012.Failed_to_drop_column__from_table__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 21284 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Failed to finish full-text operation. The Filegroup is empty, read-only, or not online | | Microsoft.SQLServer.2012.Failed_to_finish_full_text_operation._The_filegroup_is_empty_read_only_or_not_online_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9964 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Failed to initialize the Common Language Runtime (CLR) due to memory pressure | | Microsoft.SQLServer.2012.Failed_to_initialize_the_Common_Language_Runtime__CLR__due_to_memory_pressure_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6513 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Failed to initialize the Common Language Runtime (CLR) with HRESULT | | Microsoft.SQLServer.2012.Failed_to_initialize_the_Common_Language_Runtime__CLR__with_HRESULT_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6511 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Failed to initialize the Common Language Runtime (CLR) with HRESULT | | Microsoft.SQLServer.2012.Failed_to_initialize_the_Common_Language_Runtime__CLR__with_HRESULT_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6512 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Failed to restore master database. Shutting down SQL Server | | Microsoft.SQLServer.2012.Failed_to_restore_master_database._Shutting_down_SQL_Server_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3151 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Full Text Search: An unknown full-text failure occurred | | Microsoft.SQLServer.2012.Full_Text_Search___An_unknown_full_text_failure_occurred_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 7608 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Full Text Search: Could not find full-text index for database | | Microsoft.SQLServer.2012.Full_Text_Search___Could_not_find_full_text_index_for_database_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 7606 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Full Text Search: Full-text catalog is in an unusable state. Drop and re-create this full-text catalog | | 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.DBEngine | EventCollection | True | | | 0 | 7624 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Full Text Search: Full-text catalog lacks sufficient disk space to complete this operation | | Microsoft.SQLServer.2012.Full_Text_Search___Full_text_catalog_lacks_sufficient_disk_space_to_complete_this_operation_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 7622 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Full Text Search: Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable Full-Text Search | | 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.DBEngine | EventCollection | True | | | 0 | 15601 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Full Text Search: Search on full-text catalog failed with unknown result | | Microsoft.SQLServer.2012.Full_Text_Search___Search_on_full_text_catalog_failed_with_unknown_result_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 7607 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| 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 the data in this database. | 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.DBEngine | EventCollection | True | | | 0 | 8908 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Internal Query Processor Error: The query processor could not obtain access to a required interface | | Microsoft.SQLServer.2012.Internal_Query_Processor_Error__The_query_processor_could_not_obtain_access_to_a_required_interface_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8601 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Internal Query Processor Error: The query processor encountered an internal limit overflow | | Microsoft.SQLServer.2012.Internal_Query_Processor_Error__The_query_processor_encountered_an_internal_limit_overflow_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8620 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Internal Query Processor Error: The query processor encountered an unexpected error during execution | | Microsoft.SQLServer.2012.Internal_Query_Processor_Error__The_query_processor_encountered_an_unexpected_error_during_execution_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8630 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Internal Query Processor Error: The query processor encountered an unexpected error during the processing of a remote query phase | | 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.DBEngine | EventCollection | True | | | 0 | 8680 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Internal Query Processor Error: The query processor ran out of stack space during query optimization | | Microsoft.SQLServer.2012.Internal_Query_Processor_Error__The_query_processor_ran_out_of_stack_space_during_query_optimization_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8621 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Invalid reference to LOB page | | Microsoft.SQLServer.2012.Invalid_reference_to_LOB_page_id7105 | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 7105 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | High | True | Application |
| MSSQL 2012: I/O Request Takes Longer To Complete | This rule generates an alert when In/Out request takes longer than 15 seconds to complete. The rule is disabled by default. | Microsoft.SQLServer.2012.IORequestsTakingLongerThen15SecondsToComplete | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 833 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| IO Completion Listener Worker appears to be non-yielding on Node | | Microsoft.SQLServer.2012.IO_Completion_Listener_Worker_appears_to_be_non_yielding_on_Node_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 17887 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| IS Package Failed | | Microsoft.SQLServer.2012.IS_Package_Failed_5_Rule | Microsoft.SQLServer.2012.IntegrationServices | EventCollection | True | | | 0 | 12291 | SQLISPackage110 | True | Error | Normal | True | Application |
| IS Service failed to load user defined Configuration file | | Microsoft.SQLServer.2012.IS_Service_failed_to_load_user_defined_Configuration_file_5_Rule | Microsoft.SQLServer.2012.IntegrationServices | EventCollection | True | | | 0 | 272 | SQLISService110 | True | Error | Normal | True | Application |
| IS Service has attempted to stop a running package | | Microsoft.SQLServer.2012.IS_Service_has_attempted_to_stop_a_running_package_5_Rule | Microsoft.SQLServer.2012.IntegrationServices | EventCollection | False | | | 0 | 336 | SQLISService110 | True | Error | Normal | True | Application |
| Job step cannot be run because the subsystem failed to load | | Microsoft.SQLServer.2012.Job_step_cannot_be_run_because_the_subsystem_failed_to_load_1_5_Rule | Microsoft.SQLServer.2012.Agent | EventCollection | True | | | 0 | 212 | $Target/Property[Type="SQL!Microsoft.SQLServer.Agent"]/ServiceName$ | True | Warning | Normal | True | Application |
| MSSQL 2012: Collect Number of Lockrequests Per Second | Collects the Windows "Number of Lockrequests Per Second" performance counter for each instance of SQL 2012 DB Engine. | Microsoft.SQLServer.2012.LockRequestsPerSecond | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Locks | Lock Requests/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Collect Lock Timeouts Per Second | Collects the Windows "Lock Timeouts Per Second" performance counter for each instance of SQL 2012 DB Engine. | Microsoft.SQLServer.2012.LockTimeoutsPerSecond | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Locks | Lock Timeouts/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Collect Number of Lockwaits Per Second | Collects the Windows "Number of Lockwaits Per Second" performance counter for each instance of SQL 2012 DB Engine. | Microsoft.SQLServer.2012.LockWaitsPerSecond | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Locks | Lock Waits/sec | 900 | 0 | | False | | | True | |
| Logical consistency error after performing I/O on page | | Microsoft.SQLServer.2012.Logical_consistency_error_after_performing_IO_on_page_id824 | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 824 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | High | True | Application |
| Logical page in database is already hashed | | Microsoft.SQLServer.2012.Logical_page_in_database_is_already_hashed_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 813 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| MSSQL 2012: Logins per Second | Total number of logins started per second. This does not include pooled connections. | Microsoft.SQLServer.2012.LoginsPerSecCollection | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:General Statistics | Logins/sec | 300 | 0 | | False | | | True | |
| Login failed. The workstation licensing limit for SQL Server access has already been reached | | Microsoft.SQLServer.2012.Login_failed._The_workstation_licensing_limit_for_SQL_Server_access_has_already_been_reached_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 18459 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| MSSQL 2012: Login failed | When a connection attempt is rejected because of an authentication failure that involves a bad password or user name, a message similar to the following is returned to the client: "Login failed for user 'user_name'. (Microsoft SQL Server, Error: 18456)".
Note: this rule might be noisy in some environments. Therefore, it is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.2012.Login_failed__Account | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 18456 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Login failed: Account locked out | | Microsoft.SQLServer.2012.Login_failed__Account_locked_out_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 18486 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Login failed: Error during validation | | Microsoft.SQLServer.2012.Login_failed__Error_during_validation_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 18468 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Login failed: Password cannot be used at this time | | Microsoft.SQLServer.2012.Login_failed__Password_cannot_be_used_at_this_time_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 18463 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Login failed: Password expired | | Microsoft.SQLServer.2012.Login_failed__Password_expired_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 18487 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Login failed: Password fails password filter DLL requirements | | Microsoft.SQLServer.2012.Login_failed__Password_fails_password_filter_DLL_requirements_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 18467 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Login failed: Password must be changed | | Microsoft.SQLServer.2012.Login_failed__Password_must_be_changed_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 18488 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Login failed: Password too long | | Microsoft.SQLServer.2012.Login_failed__Password_too_long_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 18465 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Login failed: Password too short | | Microsoft.SQLServer.2012.Login_failed__Password_too_short_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 18464 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Login failed: Password too simple | | Microsoft.SQLServer.2012.Login_failed__Password_too_simple_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 18466 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Log Backup Failed to Complete | | Microsoft.SQLServer.2012.Log_Backup_Failed_to_Complete_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3041 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Maximum limit for connections has been reached | | Microsoft.SQLServer.2012.Maximum_limit_for_connections_has_been_reached_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17809 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| SSAS 2012: Data Mining Model Processing: Current Models Processing | | Microsoft.SQLServer.2012.MSAS11_Data_Mining_Model_Processing_Current_models_processing_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Data Mining Model Processing | Current models processing | 900 | 0 | | False | | | True | |
| SSAS 2012: Data Mining Prediction: Concurrent DM Queries | | Microsoft.SQLServer.2012.MSAS11_Data_Mining_Prediction_Concurrent_DM_queries_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Data Mining Prediction | Concurrent DM queries | 900 | 0 | | False | | | True | |
| SSAS 2012: Memory: Memory Limit High (KB) | | Microsoft.SQLServer.2012.MSAS11_Memory_Memory_Limit_High_KB_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Memory | Memory Limit High KB | 900 | 0 | | False | | | True | |
| SSAS 2012: Proc: Rows Read Per Second | | Microsoft.SQLServer.2012.MSAS11_Proc_Rows_read_sec_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Processing | Rows read/sec | 900 | 0 | | False | | | True | |
| SSAS 2012: Proc: Rows Written Per Second | | Microsoft.SQLServer.2012.MSAS11_Proc_Rows_written_sec_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Processing | Rows written/sec | 900 | 0 | | False | | | True | |
| SSAS 2012: Query: Average Time Per Query | | Microsoft.SQLServer.2012.MSAS11_Query_Avg_time_query_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Storage Engine Query | Avg time/query | 900 | 0 | | False | | | True | |
| SSAS 2012: Query: Bytes Sent Per Second | | Microsoft.SQLServer.2012.MSAS11_Query_Bytes_sent_sec_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Storage Engine Query | Bytes sent/sec | 900 | 0 | | False | | | True | |
| SSAS 2012: Query: Rows Sent Per Second | | Microsoft.SQLServer.2012.MSAS11_Query_Rows_sent_sec_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Storage Engine Query | Rows sent/sec | 900 | 0 | | False | | | True | |
| MSDTC on server is unavailable | | Microsoft.SQLServer.2012.MSDTC_on_server__is_unavailable_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8501 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| No slots are free to keep buffers for table | | Microsoft.SQLServer.2012.No_slots_are_free_to_keep_buffers_for_table__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 654 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| MSSQL 2012: Collect Number of Deadlocks Per Second | Collects the Windows "Number of Deadlocks Per Second" performance counter for each instance of SQL 2012 DB Engine. | Microsoft.SQLServer.2012.NumberDeadlocksPerSecond | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Locks | Number of Deadlocks/sec | 900 | 0 | | False | | | True | |
| One or more indexes are damaged and must be repaired or dropped | | Microsoft.SQLServer.2012.One_or_more_indexes_are_damaged_and_must_be_repaired_or_dropped_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8956 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Failed to open database or transaction log file | | Microsoft.SQLServer.2012.Operating_system_error_during_creation_opening_of_physical_device_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17207 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | High | True | Application |
| Operating System error encountered | | Microsoft.SQLServer.2012.Operating_System_error_encountered_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17053 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Operating system error on a device | | Microsoft.SQLServer.2012.Operating_system_error_on_a_device_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17218 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Optimized concurrent query limit has been exceeded | | Microsoft.SQLServer.2012.Optimized_concurrent_query_limit_has_been_exceeded_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3629 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| OS Error occurred while performing I/O on page | | Microsoft.SQLServer.2012.OSError_Occurred_While_Performing_IO_onpage_id823 | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 823 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | High | True | Application |
| Package execution failed, because the checkpoint file cannot be loaded | | Microsoft.SQLServer.2012.Package_execution_failed_because_the_checkpoint_file_cannot_be_loaded_5_Rule | Microsoft.SQLServer.2012.IntegrationServices | EventCollection | True | | | 0 | 12550 | SQLISPackage110 | True | Error | Normal | True | Application |
| Permission denied on object | | Microsoft.SQLServer.2012.Permission_denied_on_object_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 229 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| MSSQL 2012: Physical File Access Error | This rule generates an alert when a file activation error occurs. The rule is disabled by default. | Microsoft.SQLServer.2012.PhysicalFileAccessErrorRule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 5105 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Potential deadlocks exist on all schedulers on Node | | Microsoft.SQLServer.2012.Potential_deadlocks_exist_on_all_schedulers_on_Node_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17884 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Process Worker appears to be non-yielding on Scheduler | | Microsoft.SQLServer.2012.Process_Worker_appears_to_be_non_yielding_on_Scheduler_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 17883 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Recovery of database detected possible identity value inconsistency in table | | Microsoft.SQLServer.2012.Recovery_of_database__detected_possible_identity_value_inconsistency_in_table_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3452 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| RESTORE could not start database | | Microsoft.SQLServer.2012.RESTORE_could_not_start_database_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3167 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| [Deprecated] Run As Account does not exist on the target system, or does not have enough permissions | A monitoring or discovery script doesn’t have permissions to connect to the database. This rule is considered to be obsolete in this Management Pack. | Microsoft.SQLServer.2012.Script_Failed_Database_Login | Microsoft.SQLServer.2012.DBEngine | Alert | False | | | 0 | 4001 | Health Service Script | True | Error | Normal | True | Operations Manager |
| Service Broker was not able to allocate memory for cryptographic operations | | Microsoft.SQLServer.2012.Service_Broker_was_not_able_to_allocate_memory_for_cryptographic_operations_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9634 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| MSSQL 2012: Collect SQL Compilations Per Second | Collects the Windows "SQL Compilations Per Second" performance counter for each instance of SQL 2012 DB Engine. | Microsoft.SQLServer.2012.SQLCompilationsPerSecond | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:SQL Statistics | SQL Compilations/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Collect SQL Re-Сompilations Per Second | Collects the Windows "SQL Recompiles Per Second" performance counter for each instance of SQL 2012 DB Engine. | Microsoft.SQLServer.2012.SQLRecompilesPerSecond | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:SQL Statistics | SQL Re-Compilations/sec | 900 | 0 | | False | | | True | |
| SQL Server Agent could not be started | | Microsoft.SQLServer.2012.SQLServerAgent_could_not_be_started_1_5_Rule | Microsoft.SQLServer.2012.Agent | EventCollection | True | | | 0 | 103 | $Target/Property[Type="SQL!Microsoft.SQLServer.Agent"]/ServiceName$ | True | Warning | Normal | True | Application |
| SQL Server Agent initiating self-termination | | Microsoft.SQLServer.2012.SQLServerAgent_initiating_self_termination_1_5_Rule | Microsoft.SQLServer.2012.Agent | EventCollection | True | | | 0 | 51 | $Target/Property[Type="SQL!Microsoft.SQLServer.Agent"]/ServiceName$ | True | Warning | Normal | True | Application |
| MSSQL 2012: Broker Activation: Stored Procedures Invoked Per Second | | Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Stored_Procedures_Invoked_sec__Total_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker Activation | Stored Procedures Invoked/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Activation: Tasks Aborted Per Second | | Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Tasks_Aborted_sec__Total_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker Activation | Tasks Aborted/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Activation: Tasks Started Per Second | | Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Tasks_Started_sec__Total_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker Activation | Tasks Started/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Activation: Task Limit Reached Per Second | | Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Task_Limit_Reached_sec__Total_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker Activation | Task Limit Reached/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Activation: Task Limit Reached | | Microsoft.SQLServer.2012.SQLServer_Broker_Activation_Task_Limit_Reached__Total_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker Activation | Task Limit Reached | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Statistics: Broker Transaction Rollbacks | | Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_Broker_Transaction_Rollbacks_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker Statistics | Broker Transaction Rollbacks | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Statistics: Enqueued Messages Per Second | | Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_Enqueued_Messages_sec_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker Statistics | Enqueued Messages/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Statistics: Enqueued Transport Messages Per Second | | Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_Enqueued_Transport_Msgs_sec_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker Statistics | Enqueued Transport Msgs/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Statistics: SQL RECEIVEs Per Second | | Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_SQL_RECEIVEs_sec_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker Statistics | SQL RECEIVEs/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Statistics: SQL SENDs Per Second | | Microsoft.SQLServer.2012.SQLServer_Broker_Statistics_SQL_SENDs_sec_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker Statistics | SQL SENDs/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Transport: Message Fragment Receives Per Second | | Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Message_Fragment_Receives_sec_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker/DBM Transport | Message Fragment Receives/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Transport: Message Fragment Sends Per Second | | Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Message_Fragment_Sends_sec_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker/DBM Transport | Message Fragment Sends/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Transport: Open Connection Count | | Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Open_Connection_Count_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker/DBM Transport | Open Connection Count | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Transport: Receive I/Os Per Second | | Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Receive_I_Os_sec_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker/DBM Transport | Receive I/Os/sec | 900 | 0 | | False | | | True | |
| MSSQL 2012: Broker Transport: Send I/Os Per Second | | Microsoft.SQLServer.2012.SQLServer_Broker_Transport_Send_I_Os_sec_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Broker/DBM Transport | Send I/Os/sec | 900 | 0 | | False | | | True | |
| SSIS 2012: Pipeline: Buffers Spooled | | Microsoft.SQLServer.2012.SQLServer_SSIS_Pipeline_Buffers_Spooled_15.0_minutes_2_Rule | Microsoft.SQLServer.2012.IntegrationServices | PerformanceCollection | True | SQLServer:SSIS Pipeline 11.0 | Buffers spooled | 900 | 0 | | False | | | True | |
| SSIS 2012: Pipeline: Rows Read | | Microsoft.SQLServer.2012.SQLServer_SSIS_Pipeline_Rows_Read_15.0_minutes_2_Rule | Microsoft.SQLServer.2012.IntegrationServices | PerformanceCollection | True | SQLServer:SSIS Pipeline 11.0 | Rows read | 900 | 0 | | False | | | True | |
| SSIS 2012: Pipeline: Rows Written | | Microsoft.SQLServer.2012.SQLServer_SSIS_Pipeline_Rows_Written_15.0_minutes_2_Rule | Microsoft.SQLServer.2012.IntegrationServices | PerformanceCollection | True | SQLServer:SSIS Pipeline 11.0 | Rows written | 900 | 0 | | False | | | True | |
| SQL Server Assertion | | Microsoft.SQLServer.2012.SQL_Server_Assertion_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17066 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| SQL Server Assertion | | Microsoft.SQLServer.2012.SQL_Server_Assertion_2_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17067 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| SQL Server Assertion | | Microsoft.SQLServer.2012.SQL_Server_Assertion_3_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17065 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| SQL Server cannot start the Service Broker event handler | | Microsoft.SQLServer.2012.SQL_Server_cannot_start_the_Service_Broker_event_handler_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9696 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| SQL Server could not allocate enough memory to start Service Broker task manager | | Microsoft.SQLServer.2012.SQL_Server_could_not_allocate_enough_memory_to_start_Service_Broker_task_manager_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9695 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| SQL Server Service Broker cannot use RC4 encryption algorithm when running in FIPS compliance mode | | Microsoft.SQLServer.2012.SQL_Server_Service_Broker_cannot_use_RC4_encryption_algorithm_when_running_in_FIPS_compliance_mode_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 28078 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| SQL Server Service Broker could not query the FIPS compliance mode flag from the registry | | Microsoft.SQLServer.2012.SQL_Server_Service_Broker_could_not_query_the_FIPS_compliance_mode_flag_from_the_registry_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 28076 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| SQL Server Service Broker Manager has shutdown | | Microsoft.SQLServer.2012.SQL_Server_Service_Broker_Manager_has_shutdown_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 9689 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Information | Normal | True | Application |
| SQL Server Service Broker, or Database Mirroring is running in FIPS compliance mode | | Microsoft.SQLServer.2012.SQL_Server_Service_Broker_or_Database_Mirroring_is_running_in_FIPS_compliance_mode_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 28077 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Information | Low | True | Application |
| SQL Server Service Broker, or Database Mirroring Transport stopped | | Microsoft.SQLServer.2012.SQL_Server_Service_Broker_or_Database_Mirroring_Transport_stopped_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 9691 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Low | True | Application |
| SQL Server Service Broker or Database Mirror cryptographic call failed | | Microsoft.SQLServer.2012.SQL_Server_Service_Broker_or_Database_Mirror_cryptographic_call_failed_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9650 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| SQL Server Service Broker transmitter shut down due to an exception or a lack of memory | | Microsoft.SQLServer.2012.SQL_Server_Service_Broker_transmitter_shut_down_due_to_an_exception_or_a_lack_of_memory_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 28073 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| SQL Server shutdown due to Ctrl-C or Ctrl-Break signal | | Microsoft.SQLServer.2012.SQL_Server_shutdown_due_to_Ctrl_C_or_Ctrl_Break_signal_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17676 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| SQL Server Service Broker attempted to use an unsupported encryption algorithm | | Microsoft.SQLServer.2012.SQL_Server_SQL_Server_Service_Broker_attempted_to_use_an_unsupported_encryption_algorithm_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 28060 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| SQL Server terminating because of system shutdown | | Microsoft.SQLServer.2012.SQL_Server_terminating_because_of_system_shutdown_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 17147 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Starting without recovery | | Microsoft.SQLServer.2012.Starting_without_recovery_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 17660 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Step of a job caused an exception in the subsystem | | Microsoft.SQLServer.2012.Step_of_a_job_caused_an_exception_in_the_subsystem_1_5_Rule | Microsoft.SQLServer.2012.Agent | EventCollection | True | | | 0 | 209 | $Target/Property[Type="SQL!Microsoft.SQLServer.Agent"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Allocation page has invalid page header values. | | Microsoft.SQLServer.2012.Table_error__Allocation_page_has_invalid__page_header_values.__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8946 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table error: B-tree chain linkage mismatch. | | Microsoft.SQLServer.2012.Table_error__B_tree_chain_linkage_mismatch.__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8936 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table error: B-tree level mismatch, page does not match level from parent | | Microsoft.SQLServer.2012.Table_error__B_tree_level_mismatch_page_does_not_match_level_from_parent__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8931 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table error: B-tree page has two parent nodes | | Microsoft.SQLServer.2012.Table_error__B_tree_page_has_two_parent_nodes__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8937 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table error: Column is not a valid complex column | | Microsoft.SQLServer.2012.Table_error__Column_is_not_a_valid_complex_column_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8960 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: cross-object chain linkage | | Microsoft.SQLServer.2012.Table_error__cross_object_chain_linkage_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8930 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table error: Cross object linkage. Page PGID->next is not in the same index | | Microsoft.SQLServer.2012.Table_error__Cross_object_linkage._Page_PGID_next_is_not_in_the_same_index_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8982 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table error: Cross object linkage | | Microsoft.SQLServer.2012.Table_error__Cross_object_linkage_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8925 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table error: Cross object linkage: Parent page in object next refer to page not in the same object | | 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.DBEngine | EventCollection | True | | | 0 | 8926 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table error: Extent object is beyond the range of this database | | Microsoft.SQLServer.2012.Table_error__Extent_object_is_beyond_the_range_of_this_database_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 2579 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Extra or invalid key | | Microsoft.SQLServer.2012.Table_error__Extra_or_invalid_key_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8952 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: IAM chain linkage error | | Microsoft.SQLServer.2012.Table_error__IAM_chain_linkage_error_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8969 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table error: IAM page is linked in the IAM chain for object | | Microsoft.SQLServer.2012.Table_error__IAM_page_is_linked_in_the_IAM_chain_for_object_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8959 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Index node page refers to child page and previous child, but they were not encountered | | 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.DBEngine | EventCollection | True | | | 0 | 8980 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Object, index, page Test failed. Slot - Offset is invalid | | Microsoft.SQLServer.2012.Table_error__Object_index_page_Test_failed._Slot___Offset_is__invalid_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8941 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table error: Page allocated to object was not seen. Page may be invalid or have incorrect object ID information in its header | | 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.DBEngine | EventCollection | True | | | 0 | 2533 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Page in its header is allocated by another object | | Microsoft.SQLServer.2012.Table_error__Page_in_its_header_is_allocated_by_another_object_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 2534 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Page is missing a reference from previous page. Possible chain linkage problem | | Microsoft.SQLServer.2012.Table_error__Page_is_missing_a_reference_from_previous_page._Possible_chain_linkage_problem_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8978 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Page is missing references from parent (unknown) and previous nodes. Possible bad root entry in sysindexes | | 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.DBEngine | EventCollection | True | | | 0 | 8979 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: page is out of the range of this database | | Microsoft.SQLServer.2012.Table_error__page_is_out_of_the_range_of_this_database_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8968 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Page was not seen in the scan although its parent and previous refer to it. Check any previous errors | | 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.DBEngine | EventCollection | True | | | 0 | 8976 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Parent node for page was not encountered | | Microsoft.SQLServer.2012.Table_error__Parent_node_for_page_was_not_encountered_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8977 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Slot, row extends into free space | | Microsoft.SQLServer.2012.Table_error__Slot_row_extends_into_free_space__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8943 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Table missing or invalid key in index for the row: | | Microsoft.SQLServer.2012.Table_error__Table_missing_or_invalid_key_in_index_for_the_row__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8951 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: The high key value on page is not less than the low key value in the parent, slot of the next page | | 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.DBEngine | EventCollection | True | | | 0 | 8934 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: The low key value on page is not the key value in the parent | | 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.DBEngine | EventCollection | True | | | 0 | 8933 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: The previous link on page does not match the previous page that the parent slot expects for this page | | 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.DBEngine | EventCollection | True | | | 0 | 8935 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: The text, ntext, or image node at page is not referenced | | Microsoft.SQLServer.2012.Table_error__The_text_ntext_or_image_node_at_page_is_not_referenced_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8964 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: The text, ntext, or image node at page is referenced by page not seen in the scan | | 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.DBEngine | EventCollection | True | | | 0 | 8965 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: The text, ntext, or image node has wrong type | | Microsoft.SQLServer.2012.Table_error__The_text_ntext_or_image_node_has_wrong_type_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8963 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table error: Wrong PageId in the page header | | Microsoft.SQLServer.2012.Table_error__Wrong_PageId_in_the_page_header_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8909 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Address is not aligned | | Microsoft.SQLServer.2012.Table_error___Address_is_not_aligned_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8940 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Test failed. Slot overlaps with the prior row | | Microsoft.SQLServer.2012.Table_error___Test_failed._Slot_overlaps_with_the_prior_row_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8942 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: The next pointer of refers to page. Neither its parent were encountered. Possible bad chain linkage | | 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.DBEngine | EventCollection | True | | | 0 | 8981 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Table error: Unexpected page type | | Microsoft.SQLServer.2012.Table_error___Unexpected_page_type__1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8938 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table: Creating statistics for the following columns | | Microsoft.SQLServer.2012.Table__Creating_statistics_for_the_following_columns_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 15018 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| Table: No columns without statistics found | | Microsoft.SQLServer.2012.Table___No_columns_without_statistics_found_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 15013 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| [Deprecated] The agent is suspect. No response within last minutes. | | Microsoft.SQLServer.2012.The_agent_is_suspect._No_response_within_last_minutes_1_5_Rule | Microsoft.SQLServer.2012.Agent | EventCollection | True | | | 0 | 20554 | $Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| The configuration file could not be loaded | | Microsoft.SQLServer.2012.The_configuration_file_could_not_be_loaded_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 21 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| The configuration file could not be saved | | Microsoft.SQLServer.2012.The_configuration_file_could_not_be_saved_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 22 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| The database cryptographic key could not be loaded | | Microsoft.SQLServer.2012.The_database_cryptographic_key_could_not_be_loaded_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 23 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| The I/O operation was successful after retry | | Microsoft.SQLServer.2012.The_IO_operation_was_successful_after_retry_id825 | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 825 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| The log for database is not available | | Microsoft.SQLServer.2012.The_log_for_database_is_not_available_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9001 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| [Deprecated] The Log Reader Agent for transactional replication encountered an invalid log sequence number (LSN) when reading the transaction log. | | 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.DBEngine | EventCollection | False | | | 0 | 18762 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| The LSN passed to log scan in database is invalid | | Microsoft.SQLServer.2012.The_LSN_passed_to_log_scan_in_database_is_invalid_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9003 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| The metadata object could not be instantiated. | | Microsoft.SQLServer.2012.The_metadata_object_could_not_be_instantiated.__5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 18 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| The metadata object could not be linked. | | Microsoft.SQLServer.2012.The_metadata_object_could_not_be_linked.__5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 24 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| The metadata object could not be loaded | | Microsoft.SQLServer.2012.The_metadata_object_could_not_be_loaded_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 19 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| The MSSQL Server service terminated unexpectedly | | Microsoft.SQLServer.2012.The_MSSQLServer_service_terminated_unexpectedly_3_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 14265 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| The OLE DB provider reported an error | | Microsoft.SQLServer.2012.The_OLE_DB_provider_reported_an_error_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | Application |
| The operating system resource (event) could not be created during initialization of the lazy writer. | | Microsoft.SQLServer.2012.The_operating_system_resource__event__could_not_be_created_during_initialization_of_the_lazy_writer.__5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | Application |
| The operating system resource (thread) could not be created during the initialization of the lazy writer | | Microsoft.SQLServer.2012.The_operating_system_resource__thread__could_not_be_created_during_the_initialization_of_the_lazy_writer_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | Application |
| The package restarted from checkpoint file. Package was configured to restart from checkpoint and it did | | Microsoft.SQLServer.2012.The_package_restarted_from_checkpoint_file.__Package_was_configured_to_restart_from_checkpoint_and_it_did_5_Rule | Microsoft.SQLServer.2012.IntegrationServices | EventCollection | True | | | 0 | 12558 | SQLISPackage110 | True | Error | Normal | True | Application |
| The provider reported an unexpected catastrophic failure | | Microsoft.SQLServer.2012.The_provider_reported_an_unexpected_catastrophic_failure_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 10001 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| The query has been canceled, because the estimated cost of this query exceeds the configured threshold. Contact the system administrator | | 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.DBEngine | EventCollection | True | | | 0 | 8649 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| The query processor could not start the necessary thread resources for parallel query execution | | Microsoft.SQLServer.2012.The_query_processor_could_not_start_the_necessary_thread_resources_for_parallel_query_execution_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 8642 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| The server is too busy to perform the backup or restore operation | | Microsoft.SQLServer.2012.The_server_is_too_busy_to_perform_the_backup_or_restore_operation_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3627 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| The Service Broker/Database Mirroring transport cannot listen on port because it is in use | | Microsoft.SQLServer.2012.The_Service_Broker_Database_Mirroring_transport_cannot_listen_on_port_because_it_is_in_use_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9692 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| The Service Broker/Database Mirroring Transport could not listen for connections due to an error | | Microsoft.SQLServer.2012.The_Service_Broker_Database_Mirroring_Transport_could_not_listen_for_connections_due_to_an_error_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 9693 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| The Service Broker, or Database Mirroring Transport has started | | Microsoft.SQLServer.2012.The_Service_Broker_or_Database_Mirroring_Transport_has_started_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 9690 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Information | Low | True | Application |
| The service cannot be started | | Microsoft.SQLServer.2012.The_service_cannot_be_started_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | Application |
| The SQL Server Service Broker, or Database Mirroring transport is disabled or not configured | | Microsoft.SQLServer.2012.The_SQL_Server_Service_Broker_or_Database_Mirroring_transport_is_disabled_or_not_configured_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | False | | | 0 | 9666 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | High | True | Application |
| The trace waited too long for the TCP rowset sender to finish. | | Microsoft.SQLServer.2012.The_trace_waited_too_long_for_the_TCP_rowset_sender_to_finish.__5_Rule | Microsoft.SQLServer.2012.AnalysisServices | EventCollection | True | | | 0 | 13 | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/ServiceName$ | True | Error | Normal | True | Application |
| The user is not allowed to truncate the system table | | Microsoft.SQLServer.2012.The_user_is_not_allowed_to_truncate_the_system_table_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 4709 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| MSSQL 2012: Collect Total Transactions Per Second | Collects the Windows "Transaction Per Second" performance counter for the _Total instance of the databases performance object for each instance of SQL 2012 DB Engine. | Microsoft.SQLServer.2012.TransactionsPerSecond | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Databases | Transactions/sec | 900 | 0 | | False | | | True | |
| Transaction was deadlocked on resources with another process, and has been chosen as the deadlock victim. Rerun the transaction | | 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.DBEngine | EventCollection | True | | | 0 | 1205 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Unable to connect to SQL Server | | Microsoft.SQLServer.2012.Unable_to_connect_to_SQL_Server_1_5_Rule | Microsoft.SQLServer.2012.Agent | EventCollection | True | | | 0 | 207 | $Target/Property[Type="SQL!Microsoft.SQLServer.Agent"]/ServiceName$ | True | Warning | Normal | True | Application |
| Unable to re-open the local event log | | Microsoft.SQLServer.2012.Unable_to_re_open_the_local_eventlog_1_5_Rule | Microsoft.SQLServer.2012.Agent | EventCollection | True | | | 0 | 313 | $Target/Property[Type="SQL!Microsoft.SQLServer.Agent"]/ServiceName$ | True | Warning | Normal | True | Application |
| Unexpected end of file while reading beginning of backup set | | Microsoft.SQLServer.2012.Unexpected_end_of_file_while_reading_beginning_of_backup_set_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 3208 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| Unique table computation failed | | Microsoft.SQLServer.2012.Unique_table_computation_failed_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 16959 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| MSSQL 2012: SQL User Connections | | Microsoft.SQLServer.2012.UserConnectionsCollection | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:General Statistics | User Connections | 300 | 0 | | False | | | True | |
| MSSQL 2012: Collect Learning Data for SQL User Connections Monitor | | Microsoft.SQLServer.2012.UserConnectionsCollectionLearning | Microsoft.SQLServer.2012.DBEngine | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:General Statistics | User Connections | 300 | 0 | | False | | | True | |
| XML: Failed to instantiate class. Make sure Msxml2.dll exists in the SQL Server installation | | Microsoft.SQLServer.2012.XML___Failed_to_instantiate_class._Make_sure_Msxml2.dll_exists_in_the_SQL_Server_installation_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6608 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| XML: Failed to load Msxml2.dll | | Microsoft.SQLServer.2012.XML___Failed_to_load_Msxml2.dll_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6610 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| XML: FOR XML EXPLICIT stack overflow occurred. Circular parent tag relationships are not allowed | | Microsoft.SQLServer.2012.XML___FOR_XML_EXPLICIT_stack_overflow_occurred._Circular_parent_tag_relationships_are_not_allowed_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6805 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| XML: Size of data chunk requested from the stream exceeds allowed limit | | Microsoft.SQLServer.2012.XML___Size_of_data_chunk_requested_from_the_stream_exceeds_allowed_limit_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6627 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| XML: XML document could not be created, because server memory is low. Use sp_xml_removedocument to release XML documents | | 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.DBEngine | EventCollection | True | | | 0 | 6624 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| XML: XML error | | Microsoft.SQLServer.2012.XML___XML_error_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6600 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Warning | Normal | True | Application |
| XML: XML parsing error | | Microsoft.SQLServer.2012.XML___XML_parsing_error_1_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6603 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| .NET Framework runtime was shut down by user code | | Microsoft.SQLServer.2012._.NET_Framework_runtime_was_shut_down_by_user_code_5_Rule | Microsoft.SQLServer.2012.DBEngine | EventCollection | True | | | 0 | 6537 | $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| SSAS 2012: Current Connections | | Microsoft.SQLServer.2012._MSAS11_Connection_Current_connections_15.0_minutes_5_Rule | Microsoft.SQLServer.2012.AnalysisServices | PerformanceCollection | True | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Connection | Current connections | 900 | 0 | | False | | | True | |
Home