| | DisplayName | Description | ID | Target | Category | Enabled | Instance Name | Counter Name | Frequency | Event_ID | Event Source | Alert Generate | Alert Severity | Alert Priority | Remotable | Event Log |
|---|
 | [Deprecated] Agent shutdown. For more information, see the SQL Server Agent job history for job. | | Microsoft.SQLServer.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 |
| 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 |
| [Deprecated] Another log reader is replicating the database | | Microsoft.SQLServer.2008.AnotherLogReaderIsReplicatingDatabaseRule | Microsoft.SQLServer.2008.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| [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 |
| 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 |
| 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 |
| 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 |
| 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 | |
| Article update successful | | Microsoft.SQLServer.2008.ArticleUpdateSuccessfulRule | Microsoft.SQLServer.2008.DBEngine | EventCollection | False | | | 0 | 0 | | True | Information | Low | True | |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| [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 | |
| 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 | |
| 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 |
| 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 |
| 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 |
| 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 |
| [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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| [Deprecated] Could not allocate memory for replication | | Microsoft.SQLServer.2008.CouldNotAllocateMemoryForReplicationRule | Microsoft.SQLServer.2008.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | High | True | |
| Could not clean up the distribution history tables | | Microsoft.SQLServer.2008.CouldNotCleanUpDistributionHistoryTablesRule | Microsoft.SQLServer.2008.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
| [Deprecated] Could not get replication information for table | | Microsoft.SQLServer.2008.CouldNotGetReplicationInformationForTableRule | Microsoft.SQLServer.2008.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | High | True | |
| Could not remove publication from Active Directory | | Microsoft.SQLServer.2008.CouldNotRemovePublicationFromADRule | Microsoft.SQLServer.2008.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| [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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| [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 |
| 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 |
| 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 |
| MSSQL 2008: Collect DB Active Connections count | SQL 2008 DBs Active Connections performance collection rule | Microsoft.SQLServer.2008.Database.ActiveConnections.Collection | Microsoft.SQLServer.2008.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2008: Collect DB Active Requests count | SQL 2008 DBs Active Requests performance collection rule | Microsoft.SQLServer.2008.Database.ActiveRequests.Collection | Microsoft.SQLServer.2008.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2008: Collect DB Active Sessions count | SQL 2008 DBs Active Sessions performance collection rule | Microsoft.SQLServer.2008.Database.ActiveSessions.Collection | Microsoft.SQLServer.2008.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2008: Collect DB Active Transactions count | SQL 2008 DBs 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 | |
| MSSQL 2008: Collect DB Allocated Free Space (MB) | SQL 2008 DBs Allocated Free Space (MB) performance collection rule | Microsoft.SQLServer.2008.Database.DBAllocatedFreeSpaceMB.Collection | Microsoft.SQLServer.2008.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2008: Collect DB Disk Free Space (MB) | SQL 2008 DBs Disk Free Space (MB) performance collection rule | Microsoft.SQLServer.2008.Database.DBDiskFreeSpaceMB.Collection | Microsoft.SQLServer.2008.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 | |
| 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 auto grow enabled. | Microsoft.SQLServer.2008.Database.DBSpaceFree.Collection | Microsoft.SQLServer.2008.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 auto grow enabled. | Microsoft.SQLServer.2008.Database.DBSpaceFreePercent.Collection | Microsoft.SQLServer.2008.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2008: Collect DB Used Space (MB) | SQL 2008 DBs Used Space (MB) performance collection rule | Microsoft.SQLServer.2008.Database.DBUsedSpaceMB.Collection | Microsoft.SQLServer.2008.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 | Microsoft.SQLServer.2008.Database.DiskReadLatency.Collection | Microsoft.SQLServer.2008.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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. | Microsoft.SQLServer.2008.Database.DiskWriteLatency.Collection | Microsoft.SQLServer.2008.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| [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 | |
| [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 | |
| 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 | |
| MSSQL 2008: Collect DB Transactions per second count | SQL 2008 DBs 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 | |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| [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 |
| 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 |
| 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 |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 auto grow enabled. | Microsoft.SQLServer.2008.DBFile.FileAllocatedSpaceLeftMB.Collection | Microsoft.SQLServer.2008.DBFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 auto grow enabled | Microsoft.SQLServer.2008.DBFile.FileAllocatedSpaceLeftPercent.Collection | Microsoft.SQLServer.2008.DBFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 auto grow enabled. | Microsoft.SQLServer.2008.DBFile.SpaceFreeMegabytes.Collection | Microsoft.SQLServer.2008.DBFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 auto grow enabled. | Microsoft.SQLServer.2008.DBFile.SpaceFreePercent.Collection | Microsoft.SQLServer.2008.DBFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 auto grow enabled. | Microsoft.SQLServer.2008.DBFileGroup.FileGroupAllocatedSpaceLeftMB.Collection | Microsoft.SQLServer.2008.DBFileGroup | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 auto grow enabled. | Microsoft.SQLServer.2008.DBFileGroup.FileGroupAllocatedSpaceLeftPercent.Collection | Microsoft.SQLServer.2008.DBFileGroup | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 auto grow enabled. | Microsoft.SQLServer.2008.DBFileGroup.SpaceFreeMegabytes.Collection | Microsoft.SQLServer.2008.DBFileGroup | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 | |
| 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 auto grow enabled. | Microsoft.SQLServer.2008.DBLogFile.FileAllocatedSpaceLeftMB.Collection | Microsoft.SQLServer.2008.DBLogFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 auto grow enabled. | Microsoft.SQLServer.2008.DBLogFile.FileAllocatedSpaceLeftPercent.Collection | Microsoft.SQLServer.2008.DBLogFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 auto grow enabled. | Microsoft.SQLServer.2008.DBLogFile.SpaceFreeMegabytes.Collection | Microsoft.SQLServer.2008.DBLogFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| 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 auto grow enabled. | Microsoft.SQLServer.2008.DBLogFile.SpaceFreePercent.Collection | Microsoft.SQLServer.2008.DBLogFile | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| Descriptor for object in database not found in the hash table during attempt to unhash it | | Microsoft.SQLServer.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 |
| 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 |
| 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 |
| 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 | |
| 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 |
| 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 |
| 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 |
| [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 | |
| Failed to add column to table | | 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 | |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| IS Package Failed | | Microsoft.SQLServer.2008.IS_Package_Failed_5_Rule | Microsoft.SQLServer.2008.IntegrationServices | EventCollection | True | | | 0 | 12291 | SQLISPackage100 | True | Error | Normal | True | Application |
| IS Service failed to load user defined Configuration file | | 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 |
| IS Service has attempted 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 |
| 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 |
| 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 | |
| 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 | |
| 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 | |
| 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 |
| 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 |
| 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 | |
| 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 | |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 | |
| 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 |
| 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 |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 |
| 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 |
| 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 | |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| [Deprecated] Replication: agent failed | | Microsoft.SQLServer.2008.ReplicationAgentFailedRule | Microsoft.SQLServer.2008.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | High | True | |
| [Deprecated] Replication: agent failure | | Microsoft.SQLServer.2008.ReplicationAgentFailureRule | Microsoft.SQLServer.2008.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | High | True | |
| [Deprecated] Replication: agent success | | Microsoft.SQLServer.2008.ReplicationAgentSuccessRule | Microsoft.SQLServer.2008.DBEngine | EventCollection | False | | | 0 | 0 | | True | Information | Low | True | |
| [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 | |
| [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 | |
| [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 | |
| [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 | |
| [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 | |
| [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 | |
| [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 | |
| [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 | |
| [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 | |
| [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 | |
| 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 |
| [Deprecated] Schema replication failed | | Microsoft.SQLServer.2008.SchemaReplicationFailedRule | Microsoft.SQLServer.2008.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | High | True | |
| [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 |
| 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 |
| [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 | |
| 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 | |
| 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 | |
| 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 |
| 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 |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 | |
| [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 | |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| [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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| [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.Agent | EventCollection | True | | | 0 | 20554 | $Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$ | True | Error | Normal | True | Application |
| The configuration file could not be loaded | | Microsoft.SQLServer.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 |
| 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 |
| 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 |
| 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 |
| 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 |
| [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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| [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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 | |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 | |
| 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 | |
| [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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| .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 |
| 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 | |
Home