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