| DisplayName | Description | ID | Target | Category | Enabled | Instance Name | Counter Name | Frequency | Event_ID | Event Source | Alert Generate | Alert Severity | Alert Priority | Remotable | Event Log |
![Microsoft.SQLServer.Windows.CollectionRule.Agent.Alert_engine_stopped_due_to_unrecoverable_local_eventlog_errors_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Alert engine stopped due to unrecoverable local eventlog errors | SQL Server Agent was unable to open the local event log. | Microsoft.SQLServer.Windows.CollectionRule.Agent.Alert_engine_stopped_due_to_unrecoverable_local_eventlog_errors_1_5_Rule | Microsoft.SQLServer.Windows.Agent | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Agent.A_SQL_job_failed_to_complete_successfully_1_5_Rule](/images/Rule.png) | MSSQL on Windows: A SQL job failed to complete successfully | A SQL Server Agent Job Failed. The SQL Server Agent is responsible for running SQL Server tasks scheduled to occur at specific times or intervals as well as detecting specific conditions for which administrators have defined an action, such as alerting someone through pages or e-mail, or a task that will address the conditions. The SQL Server Agent is also used for running replication tasks defined by administrators. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.CollectionRule.Agent.A_SQL_job_failed_to_complete_successfully_1_5_Rule | Microsoft.SQLServer.Windows.Agent | EventCollection | False | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Agent.Job_step_cannot_be_run_because_the_subsystem_failed_to_load_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Job step cannot be run because the subsystem failed to load | A SQL Server job failed to run because the SQL Server Agent subsystem failed to load. | Microsoft.SQLServer.Windows.CollectionRule.Agent.Job_step_cannot_be_run_because_the_subsystem_failed_to_load_1_5_Rule | Microsoft.SQLServer.Windows.Agent | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Agent.SQLServerAgent_could_not_be_started_1_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Agent could not be started | A process or a person attempted to start the SQL Server Agent service, but the service did not start. | Microsoft.SQLServer.Windows.CollectionRule.Agent.SQLServerAgent_could_not_be_started_1_5_Rule | Microsoft.SQLServer.Windows.Agent | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Agent.SQLServerAgent_initiating_self_termination_1_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Agent initiating self-termination | SQL Server Agent has shut down the SQL Server Agent service. | Microsoft.SQLServer.Windows.CollectionRule.Agent.SQLServerAgent_initiating_self_termination_1_5_Rule | Microsoft.SQLServer.Windows.Agent | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Agent.Step_of_a_job_caused_an_exception_in_the_subsystem_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Step of a job caused an exception in the subsystem | A specific job step caused SQL Server Agent to write an error to the Windows Application log. The log will show the specific job and job step. | Microsoft.SQLServer.Windows.CollectionRule.Agent.Step_of_a_job_caused_an_exception_in_the_subsystem_1_5_Rule | Microsoft.SQLServer.Windows.Agent | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Agent.The_agent_is_suspect._No_response_within_last_minutes_1_5_Rule](/images/Rule.png) | MSSQL on Windows: The agent is suspect. No response within last minutes | This behavior occurs because the replication agent is too busy to respond when SQL Server Enterprise Manager polls the replication agent; therefore, SQL Server Enterprise Manager does not know the status of the replication agent and it cannot report whether the replication agent is functioning or not. | Microsoft.SQLServer.Windows.CollectionRule.Agent.The_agent_is_suspect._No_response_within_last_minutes_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Agent.Unable_to_connect_to_SQL_Server_1_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Agent is unable to connect to SQL Server | The SQL Server Agent Service could not connect to the instance of SQL Server. This error may occur when the SQL Server Agent service account does not have a valid login on SQL Server | Microsoft.SQLServer.Windows.CollectionRule.Agent.Unable_to_connect_to_SQL_Server_1_5_Rule | Microsoft.SQLServer.Windows.Agent | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Agent.Unable_to_re_open_the_local_eventlog_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Unable to re-open the local eventlog | SQL Server Agent was unable to open the local event log. | Microsoft.SQLServer.Windows.CollectionRule.Agent.Unable_to_re_open_the_local_eventlog_1_5_Rule | Microsoft.SQLServer.Windows.Agent | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.BytesReceivedFromReplicaPerSecond](/images/Rule.png) | MSSQL on Windows: Bytes Received from Replica / sec | Total number of bytes received from this replica over the network for the AG. | Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.BytesReceivedFromReplicaPerSecond | Microsoft.SQLServer.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.BytesSentToReplicaPerSecond](/images/Rule.png) | MSSQL on Windows: Bytes Sent to Replica / sec | The number of database message bytes enqueued to be send over the network to this replica. The bytes include messages for all databases in the AG. | Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.BytesSentToReplicaPerSecond | Microsoft.SQLServer.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.BytesSentToTransportPerSecond](/images/Rule.png) | MSSQL on Windows: Bytes Sent to Transport / sec | The total number of bytes send over the network to the replica. | Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.BytesSentToTransportPerSecond | Microsoft.SQLServer.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.FlowControlPerSecond](/images/Rule.png) | MSSQL on Windows: Flow Control / sec | Number of flow controls enabled for this replica per second. | Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.FlowControlPerSecond | Microsoft.SQLServer.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.FlowControlTimeSeconds](/images/Rule.png) | MSSQL on Windows: Flow Control Time (ms/sec) | The number of milliseconds flow control was enabled to this replica within the last second. | Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.FlowControlTimeSeconds | Microsoft.SQLServer.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.ReceivesFromReplicaPerSecond](/images/Rule.png) | MSSQL on Windows: Receives from Replica / sec | Total number of messages received from this replica for the AG. | Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.ReceivesFromReplicaPerSecond | Microsoft.SQLServer.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.ResentMessagesPerSecond](/images/Rule.png) | MSSQL on Windows: Resent Messages / sec | The rate per second to get acknowledgements for messages sent to the replica. | Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.ResentMessagesPerSecond | Microsoft.SQLServer.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.SendsToReplicaPerSecond](/images/Rule.png) | MSSQL on Windows: Sends to Replica / sec | Number of messages enqueued to be send over the network to this replica. | Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.SendsToReplicaPerSecond | Microsoft.SQLServer.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.SendsToTransportPerSecond](/images/Rule.png) | MSSQL on Windows: Sends to Transport / sec | Number of messages sent over the network to this replica. This account for all the messages sent from this replica including control messages. | Microsoft.SQLServer.Windows.CollectionRule.AvailabilityReplica.SendsToTransportPerSecond | Microsoft.SQLServer.Windows.AvailabilityReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Container.SpaceFreeMB](/images/Rule.png) | MSSQL on Windows: In-Memory OLTP Data Filegroup container free space (MB) | Collects the amount of free space available for the In-Memory OLTP Data Filegroup container (in Megabytes). | Microsoft.SQLServer.Windows.CollectionRule.Container.SpaceFreeMB | Microsoft.SQLServer.Windows.Container | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Container.SpaceFreePercent](/images/Rule.png) | MSSQL on Windows: In-Memory OLTP Data Filegroup container free space (\%) | Collects the amount of free space available in the In-Memory OLTP Data Filegroup container, expressed as percentage of the sum of disk free space and the size of data stored in the In-Memory OLTP Data Filegroup container. | Microsoft.SQLServer.Windows.CollectionRule.Container.SpaceFreePercent | Microsoft.SQLServer.Windows.Container | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.ActiveTransactions](/images/Rule.png) | MSSQL on Windows: DB Active Transactions Count | MSSQL on Windows DBs Active Transactions performance collection rule | Microsoft.SQLServer.Windows.CollectionRule.Database.ActiveTransactions | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.DBActiveConnectionsCount](/images/Rule.png) | MSSQL on Windows: DB Active Connections Count | SQL on Windows DBs Active Connections performance collection rule | Microsoft.SQLServer.Windows.CollectionRule.Database.DBActiveConnectionsCount | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.DBActiveRequestsCount](/images/Rule.png) | MSSQL on Windows: DB Active Requests Count | SQL on Windows DBs Active Requests performance collection rule | Microsoft.SQLServer.Windows.CollectionRule.Database.DBActiveRequestsCount | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.DBActiveSessionsCount](/images/Rule.png) | MSSQL on Windows: DB Active Sessions Count | SQL on Windows DBs Active Sessions performance collection rule | Microsoft.SQLServer.Windows.CollectionRule.Database.DBActiveSessionsCount | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.DBDiskReadLatency](/images/Rule.png) | MSSQL on Windows: DB Disk Read Latency (ms) | Collects maximum disk Read latency from all logical disks which host database files. | Microsoft.SQLServer.Windows.CollectionRule.Database.DBDiskReadLatency | Microsoft.SQLServer.Windows.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.DBDiskWriteLatency](/images/Rule.png) | MSSQL on Windows: DB Disk Write Latency (ms) | Collects maximum disk Write latency from all logical disks which host database files. | Microsoft.SQLServer.Windows.CollectionRule.Database.DBDiskWriteLatency | Microsoft.SQLServer.Windows.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.FilestreamSize](/images/Rule.png) | MSSQL on Windows: FILESTREAM Data Used Space (MB) | Collects used FILESTREAM Data space in megabytes. | Microsoft.SQLServer.Windows.CollectionRule.Database.FilestreamSize | Microsoft.SQLServer.Windows.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.FilestreamSpaceFreeMB](/images/Rule.png) | MSSQL on Windows: FILESTREAM Data Free Space (MB) | Collects free FILESTREAM Data space in megabytes. | Microsoft.SQLServer.Windows.CollectionRule.Database.FilestreamSpaceFreeMB | Microsoft.SQLServer.Windows.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.FilestreamSpaceFreePercent](/images/Rule.png) | MSSQL on Windows: FILESTREAM Data Free Space (\%) | Collects free FILESTREAM Data space in percentage terms. | Microsoft.SQLServer.Windows.CollectionRule.Database.FilestreamSpaceFreePercent | Microsoft.SQLServer.Windows.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.InMemoryOltpDiskSize](/images/Rule.png) | MSSQL on Windows: In-Memory OLTP Data Disk Used Space (MB) | Collects used In-Memory OLTP Data disk space in megabytes. | Microsoft.SQLServer.Windows.CollectionRule.Database.InMemoryOltpDiskSize | Microsoft.SQLServer.Windows.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.InMemoryOltpDiskSpaceFreeMB](/images/Rule.png) | MSSQL on Windows: In-Memory OLTP Data Disk Free Space (MB) | Collects the amount of free space available across all In-Memory OLTP Data containers in the DB (in Megabytes). | Microsoft.SQLServer.Windows.CollectionRule.Database.InMemoryOltpDiskSpaceFreeMB | Microsoft.SQLServer.Windows.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.InMemoryOltpDiskSpaceFreePercent](/images/Rule.png) | MSSQL on Windows: In-Memory OLTP Data Disk Free Space (\%) | Collects the amount of free space available across all In-Memory OLTP Data containers in the DB, expressed as percentage of the sum of disk free space and the size of data stored in the In-Memory OLTP Data containers. | Microsoft.SQLServer.Windows.CollectionRule.Database.InMemoryOltpDiskSpaceFreePercent | Microsoft.SQLServer.Windows.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.RowsAllocatedFreeSpaceMB](/images/Rule.png) | MSSQL on Windows: DB Allocated Free Space (MB) | SQL on Windows DB Allocated Free Space (MB) performance collection rule | Microsoft.SQLServer.Windows.CollectionRule.Database.RowsAllocatedFreeSpaceMB | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.RowsDiskFreeSpaceMB](/images/Rule.png) | MSSQL on Windows: DB Free Outer Space (MB) | SQL on Windows DBs Free Outer Space (MB) performance collection rule | Microsoft.SQLServer.Windows.CollectionRule.Database.RowsDiskFreeSpaceMB | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.RowsSize](/images/Rule.png) | MSSQL on Windows: DB Allocated Space (MB) | Collect database allocated size | Microsoft.SQLServer.Windows.CollectionRule.Database.RowsSize | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.RowsSpaceFree](/images/Rule.png) | MSSQL on Windows: DB Free Space Total (MB) | The amount of space left in database for all files in all Filegroups for this database in megabytes. Also, includes space left on media hosting a file with autogrowth enabled.
Please note that this rule collects metrics for ROWS data only. Metrics for FILESTREAM and for Memory-Optimized Data data are ignored. | Microsoft.SQLServer.Windows.CollectionRule.Database.RowsSpaceFree | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.RowsSpaceFreePercent](/images/Rule.png) | MSSQL on Windows: DB Free Space Total (\%) | The amount of space left in database for all files in all Filegroups for this database in percentage terms. Also, includes space left on media hosting a file with autogrowth enabled.
Please note that this rule collects metrics for ROWS data only. Metrics for FILESTREAM and for Memory-Optimized Data data are ignored. | Microsoft.SQLServer.Windows.CollectionRule.Database.RowsSpaceFreePercent | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.RowsUsedSpaceMB](/images/Rule.png) | MSSQL on Windows: DB Allocated Space Used (MB) | SQL on Windows DBs Allocated Space Used (MB) performance collection rule | Microsoft.SQLServer.Windows.CollectionRule.Database.RowsUsedSpaceMB | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.TransactionLogSpaceFreeMB](/images/Rule.png) | MSSQL on Windows: LOG Free Space Total (MB) | Collects unused transaction log space reported by SQL Server in megabytes. | Microsoft.SQLServer.Windows.CollectionRule.Database.TransactionLogSpaceFreeMB | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.TransactionLogSpaceFreePercent](/images/Rule.png) | MSSQL on Windows: LOG Free Space Total (\%) | Collects unused transaction log space reported by SQL Server as a percentage of total transaction log space | Microsoft.SQLServer.Windows.CollectionRule.Database.TransactionLogSpaceFreePercent | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.TransactionsPerSec](/images/Rule.png) | MSSQL on Windows: DB Transactions per Second Count | SQL on Windows DBs Transactions per second performance collection rule | Microsoft.SQLServer.Windows.CollectionRule.Database.TransactionsPerSec | Microsoft.SQLServer.Windows.Database | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.Database.VLFCount](/images/Rule.png) | MSSQL on Windows: DB Virtual Log File Count | SQL on Windows DBs Virtual Log Files performance collection rule | Microsoft.SQLServer.Windows.CollectionRule.Database.VLFCount | Microsoft.SQLServer.Windows.Database | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.FileBytesReceivedPerSecond](/images/Rule.png) | MSSQL on Windows: File Bytes Received / sec | Amount of FILESTREAM data received by the secondary replica for the secondary database in the last second. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.FileBytesReceivedPerSecond | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.LogApplyPendingQueue](/images/Rule.png) | MSSQL on Windows: Log Apply Pending Queue | Number of log blocks pending to be applied to the database replica. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.LogApplyPendingQueue | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.LogApplyReadyQueue](/images/Rule.png) | MSSQL on Windows: Log Apply Ready Queue | Number of log blocks pending and ready to be applied to the database replica. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.LogApplyReadyQueue | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.LogBytesReceivedPerSecond](/images/Rule.png) | MSSQL on Windows: Log Bytes Received / sec | The number of log bytes received by this replica. This is valid only on the secondary replica. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.LogBytesReceivedPerSecond | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.LogRemainingForUndo](/images/Rule.png) | MSSQL on Windows: Log Remaining for undo | The amount of log that need to be undone in KB. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.LogRemainingForUndo | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.LogSendQueue](/images/Rule.png) | MSSQL on Windows: Log Send Queue | The size of the log send queue on this replica. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.LogSendQueue | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.MirroredWriteTransactionsPerSecond](/images/Rule.png) | MSSQL on Windows: Mirrored Write Transactions / sec | The number of transactions processed through synchronization commits. Dividing transaction delay by mirrored transactions to get delay per transaction. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.MirroredWriteTransactionsPerSecond | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.RecoveryQueue](/images/Rule.png) | MSSQL on Windows: Recovery Queue | Amount of log records in the log files of the secondary replica that has not yet been redone. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.RecoveryQueue | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.RedoBlockedSec](/images/Rule.png) | MSSQL on Windows: Redo blocked / sec | Number of times the REDO thread was blocked in this database since this database was brought ONLINE. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.RedoBlockedSec | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.RedoBytesRemaining](/images/Rule.png) | MSSQL on Windows: Redo Bytes Remaining | The amount of log bytes remaining to be redone to finish the reverting phase. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.RedoBytesRemaining | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.RedoneBytesPerSecond](/images/Rule.png) | MSSQL on Windows: Redone Bytes / sec | The rate at which log records are redone on the secondary replica. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.RedoneBytesPerSecond | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.TotalLogRequiringUndo](/images/Rule.png) | MSSQL on Windows: Total Log requiring undo | Total kilobytes of log that must be undone. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.TotalLogRequiringUndo | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.TransactionDelay](/images/Rule.png) | MSSQL on Windows: Transaction Delay | The total time for all transactions waited on the secondary acknowledgement. | Microsoft.SQLServer.Windows.CollectionRule.DatabaseReplica.TransactionDelay | Microsoft.SQLServer.Windows.DatabaseReplica | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.AverageWaitTime](/images/Rule.png) | MSSQL on Windows: DB Engine Average Wait Time (Milliseconds) | SQL DB Engine on Windows Average Wait Time performance collection rule | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.AverageWaitTime | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_StoredProceduresInvokedSec](/images/Rule.png) | MSSQL on Windows: Broker Activation: Stored Procedures Invoked per Second | Collects the "Broker Activation: Stored Procedures Invoked per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_StoredProceduresInvokedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_TaskLimitReached](/images/Rule.png) | MSSQL on Windows: Broker Activation: Task Limit Reached | Collects the "Broker Activation: Task Limit Reached" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_TaskLimitReached | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_TaskLimitReachedSec](/images/Rule.png) | MSSQL on Windows: Broker Activation: Task Limit Reached per Second | Collects the "Broker Activation: Task Limit Reached per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_TaskLimitReachedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_TasksAbortedSec](/images/Rule.png) | MSSQL on Windows: Broker Activation: Tasks Aborted per Second | Collects the "Broker Activation: Tasks Aborted per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_TasksAbortedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_TasksRunning](/images/Rule.png) | MSSQL on Windows: Broker Activation: Tasks Running | Collects the "Broker Activation: Tasks Running" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_TasksRunning | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_TasksStartedSec](/images/Rule.png) | MSSQL on Windows: Broker Activation: Tasks Started per Second | Collects the "Broker Activation: Tasks Started per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_TasksStartedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_CurrentBytesForRecvIO](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Current Bytes for Receive I/O | Collects the "Broker/DBM Transport: Current Bytes for Receive I/O" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_CurrentBytesForRecvIO | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_CurrentBytesForSendIO](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Current Bytes for Send I/O | Collects the "Broker/DBM Transport: Current Bytes for Send I/O" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_CurrentBytesForSendIO | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_CurrentMsgFragsForSendIO](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Current Message Fragments for Send I/O | Collects the "Broker/DBM Transport: Current Message Fragments for Send I/O" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_CurrentMsgFragsForSendIO | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP10SendsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment P10 Sends per Second | Collects the "Broker/DBM Transport: Message Fragment P10 Sends per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP10SendsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP1SendsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment P1 Sends per Second | Collects the "Broker/DBM Transport: Message Fragment P1 Sends per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP1SendsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP2SendsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment P2 Sends per Second | Collects the "Broker/DBM Transport: Message Fragment P2 Sends per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP2SendsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP3SendsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment P3 Sends per Second | Collects the "Broker/DBM Transport: Message Fragment P3 Sends per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP3SendsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP4SendsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment P4 Sends per Second | Collects the "Broker/DBM Transport: Message Fragment P4 Sends per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP4SendsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP5SendsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment P5 Sends per Second | Collects the "Broker/DBM Transport: Message Fragment P5 Sends per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP5SendsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP6SendsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment P6 Sends per Second | Collects the "Broker/DBM Transport: Message Fragment P6 Sends per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP6SendsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP7SendsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment P7 Sends per Second | Collects the "Broker/DBM Transport: Message Fragment P7 Sends per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP7SendsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP8SendsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment P8 Sends per Second | Collects the "Broker/DBM Transport: Message Fragment P8 Sends per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP8SendsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP9SendsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment P9 Sends per Second | Collects the "Broker/DBM Transport: Message Fragment P9 Sends per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentP9SendsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentReceivesSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment Receives per Second | Collects the "Broker/DBM Transport: Message Fragment Receives per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentReceivesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentSendsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment Sends per Second | Collects the "Broker/DBM Transport: Message Fragment Sends per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MessageFragmentSendsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MsgFragmentRecvSizeAvg](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment Receive Size Average | Collects the "Broker/DBM Transport:Message Fragment Receive Size Average" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MsgFragmentRecvSizeAvg | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MsgFragmentSendSizeAvg](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Message Fragment Send Size Average | Collects the "Broker/DBM Transport:Message Fragment Send Size Average" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_MsgFragmentSendSizeAvg | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_OpenConnectionCount](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Open Connection Count | Collects the "Broker/DBM Transport: Open Connection Count" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_OpenConnectionCount | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_PendingBytesForRecvIO](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Pending Bytes for Receive I/O | Collects the "Broker/DBM Transport: Pending Bytes for Receive I/O" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_PendingBytesForRecvIO | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_PendingBytesForSendIO](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Pending Bytes for Send I/O | Collects the "Broker/DBM Transport: Pending Bytes for Send I/O" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_PendingBytesForSendIO | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_PendingMsgFragsForRecvIO](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Pending Message Fragments for Receive I/O | Collects the "Broker/DBM Transport: Pending Message Fragments for Receive I/O" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_PendingMsgFragsForRecvIO | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_PendingMsgFragsForSendIO](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Pending Message Fragments for Send I/O | Collects the "Broker/DBM Transport: Pending Message Fragments for Send I/O" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_PendingMsgFragsForSendIO | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_ReceiveIOBytesSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Receive I/O Bytes per Second | Collects the "Broker/DBM Transport: Receive I/O Bytes per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_ReceiveIOBytesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_ReceiveIOLenAvg](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Receive I/O Len Average | Collects the "Broker/DBM Transport: Receive I/O Len Average" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_ReceiveIOLenAvg | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_ReceiveIOsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Receive I/Os per Second | Collects the "Broker/DBM Transport: Receive I/Os per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_ReceiveIOsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_RecvIOBufferCopiesBytesSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Receive I/O Buffer Copies bytes per Second | Collects the "Broker/DBM Transport:Receive I/O Buffer Copies bytes per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_RecvIOBufferCopiesBytesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_RecvIOBufferCopiesCount](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Receive I/O Buffer Copies Count | Collects the "Broker/DBM Transport:Receive I/O Buffer Copies Count" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_RecvIOBufferCopiesCount | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_SendIOBytesSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Send I/O Bytes per Second | Collects the "Broker/DBM Transport: Send I/O Bytes per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_SendIOBytesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_SendIOLenAvg](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Send I/O Len Average | Collects the "Broker/DBM Transport: Send I/O Len Average" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_SendIOLenAvg | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_SendIOsSec](/images/Rule.png) | MSSQL on Windows: Broker/DBM Transport: Send I/Os per Second | Collects the "Broker/DBM Transport: Send I/Os per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerDbmTransport_SendIOsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ActivationErrorsTotal](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Activation Errors Total | Collects the "Broker Statistics: Activation Errors Total" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ActivationErrorsTotal | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_BrokerTransactionRollbacks](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Broker Transaction Rollbacks | Collects the "Broker Statistics: Broker Transaction Rollbacks" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_BrokerTransactionRollbacks | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_CorruptedMessagesTotal](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Corrupted Messages Total | Collects the "Broker Statistics: Corrupted Messages Total" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_CorruptedMessagesTotal | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_DequeuedTransmissionqMsgsSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Dequeued TransmissionQ Messages per Second | Collects the "Broker Statistics: Dequeued TransmissionQ Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_DequeuedTransmissionqMsgsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_DialogTimerEventCount](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Dialog Timer Event Count | Collects the "Broker Statistics: Dialog Timer Event Count" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_DialogTimerEventCount | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_DroppedMessagesTotal](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Dropped Messages Total | Collects the "Broker Statistics: Dropped Messages Total" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_DroppedMessagesTotal | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedLocalMessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued Local Messages per Second | Collects the "Broker Statistics: Enqueued Local Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedLocalMessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedLocalMessagesTotal](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued Local Messages Total | Collects the "Broker Statistics: Enqueued Local Messages Total" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedLocalMessagesTotal | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedMessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued Messages per Second | Collects the "Broker Statistics: Enqueued Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedMessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedMessagesTotal](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued Messages Total | Collects the "Broker Statistics: Enqueued Messages Total" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedMessagesTotal | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP10MessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued P10 Messages per Second | Collects the "Broker Statistics: Enqueued P10 Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP10MessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP1MessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued P1 Messages per Second | Collects the "Broker Statistics: Enqueued P1 Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP1MessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP2MessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued P2 Messages per Second | Collects the "Broker Statistics: Enqueued P2 Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP2MessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP3MessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued P3 Messages per Second | Collects the "Broker Statistics: Enqueued P3 Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP3MessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP4MessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued P4 Messages per Second | Collects the "Broker Statistics: Enqueued P4 Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP4MessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP5MessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued P5 Messages per Second | Collects the "Broker Statistics: Enqueued P5 Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP5MessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP6MessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued P6 Messages per Second | Collects the "Broker Statistics: Enqueued P6 Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP6MessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP7MessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued P7 Messages per Second | Collects the "Broker Statistics: Enqueued P7 Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP7MessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP8MessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued P8 Messages per Second | Collects the "Broker Statistics: Enqueued P8 Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP8MessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP9MessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued P9 Messages per Second | Collects the "Broker Statistics: Enqueued P9 Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedP9MessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedTransmissionqMsgsSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued TransmissionQ Messages per Second | Collects the "Broker Statistics: Enqueued TransmissionQ Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedTransmissionqMsgsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedTransportMsgFragsSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued Transport Message Fragments per Second | Collects the "Broker Statistics: Enqueued Transport Message Fragments per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedTransportMsgFragsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedTransportMsgFragTot](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued Transport Message Frag Tot | Collects the "Broker Statistics: Enqueued Transport Message Frag Tot" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedTransportMsgFragTot | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedTransportMsgsSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued Transport Messages per Second | Collects the "Broker Statistics: Enqueued Transport Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedTransportMsgsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedTransportMsgsTotal](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Enqueued Transport Messages Total | Collects the "Broker Statistics: Enqueued Transport Messages Total" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_EnqueuedTransportMsgsTotal | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedMessagesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Forwarded Messages per Second | Collects the "Broker Statistics: Forwarded Messages per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedMessagesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedMessagesTotal](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Forwarded Messages Total | Collects the "Broker Statistics: Forwarded Messages Total" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedMessagesTotal | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedMsgBytesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Forwarded Message Bytes per Second | Collects the "Broker Statistics: Forwarded Message Bytes per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedMsgBytesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedMsgByteTotal](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Forwarded Message Byte Total | Collects the "Broker Statistics: Forwarded Message Byte Total" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedMsgByteTotal | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedMsgDiscardedTotal](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Forwarded Message Discarded Total | Collects the "Broker Statistics: Forwarded Message Discarded Total" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedMsgDiscardedTotal | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedMsgsDiscardedSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Forwarded Messages Discarded per Second | Collects the "Broker Statistics: Forwarded Messages Discarded per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedMsgsDiscardedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedPendingMsgBytes](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Forwarded Pending Message Bytes | Collects the "Broker Statistics: Forwarded Pending Message Bytes" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedPendingMsgBytes | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedPendingMsgCount](/images/Rule.png) | MSSQL on Windows: Broker Statistics: Forwarded Pending Message Count | Collects the "Broker Statistics: Forwarded Pending Message Count" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_ForwardedPendingMsgCount | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_SqlReceivesSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: SQL Receives per Second | Collects the "Broker Statistics: SQL Receives per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_SqlReceivesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_SqlReceiveTotal](/images/Rule.png) | MSSQL on Windows: Broker Statistics: SQL Receive Total | Collects the "Broker Statistics: SQL Receive Total" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_SqlReceiveTotal | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_SqlSendsSec](/images/Rule.png) | MSSQL on Windows: Broker Statistics: SQL Sends per Second | Collects the "Broker Statistics: SQL Sends per Second" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_SqlSendsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_SqlSendTotal](/images/Rule.png) | MSSQL on Windows: Broker Statistics: SQL Send Total | Collects the "Broker Statistics: SQL Send Total" performance counter for each instance of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerStatistics_SqlSendTotal | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BufferCacheHitRatio](/images/Rule.png) | MSSQL on Windows: Buffer Cache Hit Ratio | Collects the Windows "Buffer Cache Hit Ratio" performance counter for each instance of SQL DB Engine on Windows. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BufferCacheHitRatio | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.CPUUtilization](/images/Rule.png) | MSSQL on Windows: DB Engine CPU Utilization (\%) | MSSQL on Windows DB Engine CPU Utilization (\%) performance collection rule. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.CPUUtilization | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgBytesRead](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Average Bytes/Read | Collects the "HTTP Storage: Average Bytes/Read" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgBytesRead | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgBytesTransfer](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Average Bytes/Transfer | Collects the "HTTP Storage: Average Bytes/Transfer" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgBytesTransfer | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgBytesWrite](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Average Bytes/Write | Collects the "HTTP Storage: Average Bytes/Write" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgBytesWrite | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecRead](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Average Microseconds/Read | Collects the "HTTP Storage: Average Microseconds/Read" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecRead | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecReadComp](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Average Microseconds/Read Comp | Collects the "HTTP Storage: Average Microseconds/Read Comp" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecReadComp | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecTransfer](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Average Microseconds/Transfer | Collects the "HTTP Storage: Average Microseconds/Transfer" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecTransfer | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecWrite](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Average Microseconds/Write | Collects the "HTTP Storage: Average Microseconds/Write" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecWrite | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecWriteComp](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Average Microseconds/Write Comp | Collects the "HTTP Storage: Average Microseconds/Write Comp" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecWriteComp | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_HttpStorageIoFailedSec](/images/Rule.png) | MSSQL on Windows: HTTP Storage: HTTP Storage I/O Failed per Second | Collects the "HTTP Storage: HTTP Storage I/O Failed per Second" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_HttpStorageIoFailedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_HttpStorageIoRetrySec](/images/Rule.png) | MSSQL on Windows: HTTP Storage: HTTP Storage I/O Retry per Second | Collects the "HTTP Storage: HTTP Storage I/O Retry per Second" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_HttpStorageIoRetrySec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_OutstandingHttpStorageIo](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Outstanding HTTP Storage I/O | Collects the "HTTP Storage: Outstanding HTTP Storage I/O" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_OutstandingHttpStorageIo | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_ReadBytesSec](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Read Bytes per Second | Collects the "HTTP Storage: Read Bytes per Second" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_ReadBytesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_ReadsSec](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Reads per Second | Collects the "HTTP Storage: Reads per Second" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_ReadsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_TotalBytesSec](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Total Bytes per Second | Collects the "HTTP Storage: Total Bytes per Second" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_TotalBytesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_TransfersSec](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Transfers per Second | Collects the "HTTP Storage: Transfers per Second" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_TransfersSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_WriteBytesSec](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Write Bytes per Second | Collects the "HTTP Storage: Write Bytes per Second" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_WriteBytesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_WritesSec](/images/Rule.png) | MSSQL on Windows: HTTP Storage: Writes per Second | Collects the "HTTP Storage: Writes per Second" performance counter for SQL DB Engine that monitor Microsoft Azure Storage account. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.HTTPStorage_WritesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.LockRequestsPerSecond](/images/Rule.png) | MSSQL on Windows: Number of Lock Requests per Second | Collects the Windows "Number of Lock Requests per Second" performance counter for each instance of SQL DB Engine on Windows. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.LockRequestsPerSecond | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.LockTimeoutsPerSecond](/images/Rule.png) | MSSQL on Windows: Lock Timeouts per Second | Collects the Windows "Lock Timeouts per Second" performance counter for each instance of SQL DB Engine on Windows. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.LockTimeoutsPerSecond | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.LockWaitsPerSecond](/images/Rule.png) | MSSQL on Windows: Number of Lock Waits per Second | Collects the Windows "Number of Lock Waits per Second" performance counter for each instance of SQL DB Engine on Windows. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.LockWaitsPerSecond | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.LoginsPerSecond](/images/Rule.png) | MSSQL on Windows: Logins per Second | Total number of logins started per second. This does not include pooled connections. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.LoginsPerSecond | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.NumberDeadlocksPerSecond](/images/Rule.png) | MSSQL on Windows: Number of Deadlocks per Second | Collects the Windows "Number of Deadlocks per Second" performance counter for each instance of SQL DB Engine on Windows. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.NumberDeadlocksPerSecond | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.PageLifeExpectancy](/images/Rule.png) | MSSQL on Windows: DB Engine Page Life Expectancy (s) | SQL DB Engine on Windows Page Life Expectancy (s) performance collection rule | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.PageLifeExpectancy | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.SQLCompilationsPerSecond](/images/Rule.png) | MSSQL on Windows: SQL Compilations per Second | Collects the Windows "SQL Compilations per Second" performance counter for each instance of SQL DB Engine on Windows. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.SQLCompilationsPerSecond | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.SQLRecompilationsPerSecond](/images/Rule.png) | MSSQL on Windows: SQL Re-Compilations per Second | Collects the Windows "SQL Recompiles per Second" performance counter for each instance of SQL DB Engine on Windows. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.SQLRecompilationsPerSecond | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.StolenServerMemory](/images/Rule.png) | MSSQL on Windows: DB Engine Stolen Server Memory (MB) | SQL DB Engine Stolen Server Memory (MB) performance collection rule on Windows | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.StolenServerMemory | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.ThreadCount](/images/Rule.png) | MSSQL on Windows: DB Engine Thread Count | SQL DB Engine Thread Count performance collection rule | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.ThreadCount | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.TransactionsPerSecond](/images/Rule.png) | MSSQL on Windows: 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 DB Engine on Windows. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.TransactionsPerSecond | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.UserConnectionsCollection](/images/Rule.png) | MSSQL on Windows: SQL User Connections | Counts the number of users currently connected to SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.UserConnectionsCollection | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_CursorDeletesSec](/images/Rule.png) | MSSQL on Windows: Cursor deletes/sec | Collects the Windows "Cursor deletes/sec" performance counter for internal XTP engine cursors. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_CursorDeletesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_CursorInsertsSec](/images/Rule.png) | MSSQL on Windows: Cursor inserts/sec | Collects the Windows "Cursor inserts/sec" performance counter for internal XTP engine cursors. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_CursorInsertsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_CursorScansStartedSec](/images/Rule.png) | MSSQL on Windows: Cursor scans started/sec | Collects the Windows "Cursor scans started/sec" performance counter for internal XTP engine cursors. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_CursorScansStartedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_CursorUniqueViolationsSec](/images/Rule.png) | MSSQL on Windows: Cursor unique violations/sec | Collects the Windows "Cursor unique violations/sec" performance counter for internal XTP engine cursors. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_CursorUniqueViolationsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_CursorUpdatesSec](/images/Rule.png) | MSSQL on Windows: Cursor updates/sec | Collects the Windows "Cursor updates/sec" performance counter for internal XTP engine cursors. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_CursorUpdatesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_CursorWriteConflictsSec](/images/Rule.png) | MSSQL on Windows: Cursor write conflicts/sec | Collects the Windows "Cursor write conflicts/sec" performance counter for internal XTP engine cursors. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_CursorWriteConflictsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_DustyCornerScanRetriesSecUserIssued](/images/Rule.png) | MSSQL on Windows: Dusty corner scan retries/sec (user-issued) | Collects the Windows "Dusty corner scan retries/sec (user-issued)" performance counter for internal XTP engine cursors. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_DustyCornerScanRetriesSecUserIssued | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_ExpiredRowsRemovedSec](/images/Rule.png) | MSSQL on Windows: Expired rows removed/sec | Collects the Windows "Expired rows removed/sec" performance counter for internal XTP engine cursors. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_ExpiredRowsRemovedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_ExpiredRowsTouchedSec](/images/Rule.png) | MSSQL on Windows: Expired rows touched/sec | Collects the Windows "Expired rows touched/sec" performance counter for internal XTP engine cursors. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_ExpiredRowsTouchedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_RowsReturnedSec](/images/Rule.png) | MSSQL on Windows: Rows returned/sec | Collects the Windows "Rows returned/sec" performance counter for internal XTP engine cursors. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_RowsReturnedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_RowsTouchedSec](/images/Rule.png) | MSSQL on Windows: Rows touched/sec | Collects the Windows "Rows touched/sec" performance counter for internal XTP engine cursors. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_RowsTouchedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_TentativelyDeletedRowsTouchedSec](/images/Rule.png) | MSSQL on Windows: Tentatively-deleted rows touched/sec | Collects the Windows "Tentatively-deleted rows touched/sec" performance counter for internal XTP engine cursors. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpCursors_TentativelyDeletedRowsTouchedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_DustyCornerScanRetriesSecGcIssued](/images/Rule.png) | MSSQL on Windows: Dusty corner scan retries/sec (GC-issued) | Collects the Windows "Dusty corner scan retries/sec (GC-issued)" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_DustyCornerScanRetriesSecGcIssued | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_MainGcWorkItemsSec](/images/Rule.png) | MSSQL on Windows: Main GC work items/sec | Collects the Windows "Main GC work items/sec" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_MainGcWorkItemsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_ParallelGcWorkItemSec](/images/Rule.png) | MSSQL on Windows: Parallel GC work item/sec | Collects the Windows "Parallel GC work item/sec" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_ParallelGcWorkItemSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSec](/images/Rule.png) | MSSQL on Windows: Rows processed/sec | Collects the Windows "Rows processed/sec" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecFirstInBucket](/images/Rule.png) | MSSQL on Windows: Rows processed/sec (first in bucket) | Collects the Windows "Rows processed/sec (first in bucket)" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecFirstInBucket | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecFirstInBucketAndRemoved](/images/Rule.png) | MSSQL on Windows: Rows processed/sec (first in bucket and removed) | Collects the Windows "Rows processed/sec (first in bucket and removed)" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecFirstInBucketAndRemoved | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecMarkedForUnlink](/images/Rule.png) | MSSQL on Windows: Rows processed/sec (marked for unlink) | Collects the Windows "Rows processed/sec (marked for unlink)" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecMarkedForUnlink | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecNoSweepNeeded](/images/Rule.png) | MSSQL on Windows: Rows processed/sec (no sweep needed) | Collects the Windows "Rows processed/sec (no sweep needed)" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecNoSweepNeeded | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_SweepExpiredRowsRemovedSec](/images/Rule.png) | MSSQL on Windows: Sweep expired rows removed/sec | Collects the Windows "Sweep expired rows removed/sec" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_SweepExpiredRowsRemovedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_SweepExpiredRowsTouchedSec](/images/Rule.png) | MSSQL on Windows: Sweep expired rows touched/sec | Collects the Windows "Sweep expired rows touched/sec" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_SweepExpiredRowsTouchedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_SweepExpiringRowsTouchedSec](/images/Rule.png) | MSSQL on Windows: Sweep expiring rows touched/sec | Collects the Windows "Sweep expiring rows touched/sec" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_SweepExpiringRowsTouchedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_SweepRowsTouchedSec](/images/Rule.png) | MSSQL on Windows: Sweep rows touched/sec | Collects the Windows "Sweep rows touched/sec" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_SweepRowsTouchedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_SweepScansStartedSec](/images/Rule.png) | MSSQL on Windows: Sweep scans started/sec | Collects the Windows "Sweep scans started/sec" performance counter for the XTP engine's garbage collector. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpGarbageCollection_SweepScansStartedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpIoGovernor_InsufficientCreditsWaitsSec](/images/Rule.png) | MSSQL on Windows: Insufficient Credits Waits/sec | Collects the Windows "Insufficient Credits Waits/sec" performance counter for the XTP IO Rate Governor. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpIoGovernor_InsufficientCreditsWaitsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpIoGovernor_IoIssuedSec](/images/Rule.png) | MSSQL on Windows: Io Issued/sec | Collects the Windows "Io Issued/sec" performance counter for the XTP IO Rate Governor. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpIoGovernor_IoIssuedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpIoGovernor_LogBlocksSec](/images/Rule.png) | MSSQL on Windows: Log Blocks/sec | Collects the Windows "Log Blocks/sec" performance counter for the XTP IO Rate Governor. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpIoGovernor_LogBlocksSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpIoGovernor_MissedCreditSlots](/images/Rule.png) | MSSQL on Windows: Missed Credit Slots | Collects the Windows "Missed Credit Slots" performance counter for the XTP IO Rate Governor. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpIoGovernor_MissedCreditSlots | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpIoGovernor_StaleRateObjectWaitsSec](/images/Rule.png) | MSSQL on Windows: Stale Rate Object Waits/sec | Collects the Windows "Stale Rate Object Waits/sec" performance counter for the XTP IO Rate Governor. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpIoGovernor_StaleRateObjectWaitsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpIoGovernor_TotalRateObjectsPublished](/images/Rule.png) | MSSQL on Windows: Total Rate Objects Published | Collects the Windows "Total Rate Objects Published" performance counter for the XTP IO Rate Governor. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpIoGovernor_TotalRateObjectsPublished | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpPhantomProcessor_DustyCornerScanRetriesSecPhantomIssued](/images/Rule.png) | MSSQL on Windows: Dusty corner scan retries/sec (Phantom-issued) | Collects the Windows "Dusty corner scan retries/sec (Phantom-issued)" performance counter for the XTP engine's phantom processing subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpPhantomProcessor_DustyCornerScanRetriesSecPhantomIssued | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomExpiredRowsRemovedSec](/images/Rule.png) | MSSQL on Windows: Phantom expired rows removed/sec | Collects the Windows "Phantom expired rows removed/sec" performance counter for the XTP engine's phantom processing subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomExpiredRowsRemovedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomExpiredRowsTouchedSec](/images/Rule.png) | MSSQL on Windows: Phantom expired rows touched/sec | Collects the Windows "Phantom expired rows touched/sec" performance counter for the XTP engine's phantom processing subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomExpiredRowsTouchedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomExpiringRowsTouchedSec](/images/Rule.png) | MSSQL on Windows: Phantom expiring rows touched/sec | Collects the Windows "Phantom expiring rows touched/sec" performance counter for the XTP engine's phantom processing subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomExpiringRowsTouchedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomRowsTouchedSec](/images/Rule.png) | MSSQL on Windows: Phantom rows touched/sec | Collects the Windows "Phantom rows touched/sec" performance counter for the XTP engine's phantom processing subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomRowsTouchedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomScansStartedSec](/images/Rule.png) | MSSQL on Windows: Phantom scans started/sec | Collects the Windows "Phantom scans started/sec" performance counter for the XTP engine's phantom processing subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomScansStartedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_CheckpointsClosed](/images/Rule.png) | MSSQL on Windows: Checkpoints Closed | Collects the Windows "Checkpoints Closed" performance counter for the XTP engine's storage subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_CheckpointsClosed | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_CheckpointsCompleted](/images/Rule.png) | MSSQL on Windows: Checkpoints Completed | Collects the Windows "Checkpoints Completed" performance counter for the XTP engine's storage subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_CheckpointsCompleted | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_CoreMergesCompleted](/images/Rule.png) | MSSQL on Windows: Core Merges Completed | Collects the Windows "Core Merges Completed" performance counter for the XTP engine's storage subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_CoreMergesCompleted | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_MergePolicyEvaluations](/images/Rule.png) | MSSQL on Windows: Merge Policy Evaluations | Collects the Windows "Merge Policy Evaluations" performance counter for the XTP engine's storage subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_MergePolicyEvaluations | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_MergeRequestsOutstanding](/images/Rule.png) | MSSQL on Windows: Merge Requests Outstanding | Collects the Windows "Merge Requests Outstanding" performance counter for the XTP engine's storage subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_MergeRequestsOutstanding | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_MergesAbandoned](/images/Rule.png) | MSSQL on Windows: Merges Abandoned | Collects the Windows "Merges Abandoned" performance counter for the XTP engine's storage subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_MergesAbandoned | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_MergesInstalled](/images/Rule.png) | MSSQL on Windows: Merges Installed | Collects the Windows "Merges Installed" performance counter for the XTP engine's storage subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_MergesInstalled | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_TotalFilesMerged](/images/Rule.png) | MSSQL on Windows: Total Files Merged | Collects the Windows "Total Files Merged" performance counter for the XTP engine's storage subsystem. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpStorage_TotalFilesMerged | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactionLog_LogBytesWrittenSec](/images/Rule.png) | MSSQL on Windows: Log bytes written/sec | Collects the Windows "Log bytes written/sec" performance counter for XTP transaction logging in SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactionLog_LogBytesWrittenSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactionLog_LogRecordsWrittenSec](/images/Rule.png) | MSSQL on Windows: Log records written/sec | Collects the Windows "Log records written/sec" performance counter for XTP transaction logging in SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactionLog_LogRecordsWrittenSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_CascadingAbortsSec](/images/Rule.png) | MSSQL on Windows: Cascading aborts/sec | Collects the Windows "Cascading aborts/sec" performance counter for XTP engine transactions in SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_CascadingAbortsSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_CommitDependenciesTakenSec](/images/Rule.png) | MSSQL on Windows: Commit dependencies taken/sec | Collects the Windows "Commit dependencies taken/sec" performance counter for XTP engine transactions in SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_CommitDependenciesTakenSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_ReadOnlyTransactionsPreparedSec](/images/Rule.png) | MSSQL on Windows: Read-only transactions prepared/sec | Collects the Windows "Read-only transactions prepared/sec" performance counter for XTP engine transactions in SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_ReadOnlyTransactionsPreparedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_SavePointRefreshesSec](/images/Rule.png) | MSSQL on Windows: Save point refreshes/sec | Collects the Windows "Save point refreshes/sec" performance counter for XTP engine transactions in SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_SavePointRefreshesSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_SavePointRollbacksSec](/images/Rule.png) | MSSQL on Windows: Save point rollbacks/sec | Collects the Windows "Save point rollbacks/sec" performance counter for XTP engine transactions in SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_SavePointRollbacksSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_SavePointsCreatedSec](/images/Rule.png) | MSSQL on Windows: Save points created/sec | Collects the Windows "Save points created/sec" performance counter for XTP engine transactions in SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_SavePointsCreatedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_TransactionsAbortedByUserSec](/images/Rule.png) | MSSQL on Windows: Transactions aborted by user/sec | Collects the Windows "Transactions aborted by user/sec" performance counter for XTP engine transactions in SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_TransactionsAbortedByUserSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_TransactionsAbortedSec](/images/Rule.png) | MSSQL on Windows: Transactions aborted/sec | Collects the Windows "Transactions aborted/sec" performance counter for XTP engine transactions in SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_TransactionsAbortedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_TransactionsCreatedSec](/images/Rule.png) | MSSQL on Windows: Transactions created/sec | Collects the Windows "Transactions created/sec" performance counter for XTP engine transactions in SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_TransactionsCreatedSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_TransactionValidationFailuresSec](/images/Rule.png) | MSSQL on Windows: Transaction validation failures/sec | Collects the Windows "Transaction validation failures/sec" performance counter for XTP engine transactions in SQL Server. | Microsoft.SQLServer.Windows.CollectionRule.DBEngine.XtpTransactions_TransactionValidationFailuresSec | Microsoft.SQLServer.Windows.DBEngine | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFile.FileAllocatedSpaceLeftMB](/images/Rule.png) | MSSQL on Windows: ROWS Data Allocated Free Space (MB) | The amount of space left in a file in megabytes. Does not include space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.Windows.CollectionRule.DBFile.FileAllocatedSpaceLeftMB | Microsoft.SQLServer.Windows.DBFile | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFile.FileAllocatedSpaceLeftPercent](/images/Rule.png) | MSSQL on Windows: ROWS Data Allocated Free Space (\%) | The amount of space left in a file in percentage terms. Does not include space left on media hosting a file with autogrowth enabled | Microsoft.SQLServer.Windows.CollectionRule.DBFile.FileAllocatedSpaceLeftPercent | Microsoft.SQLServer.Windows.DBFile | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFile.SpaceFreeMegabytes](/images/Rule.png) | MSSQL on Windows: ROWS Data Free Space Total (MB) | The amount of space left in a file in megabytes. Also, includes space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.Windows.CollectionRule.DBFile.SpaceFreeMegabytes | Microsoft.SQLServer.Windows.DBFile | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFile.SpaceFreePercent](/images/Rule.png) | MSSQL on Windows: ROWS Data Free Space Total (\%) | The amount of space left in a file in percentage terms. Also, includes space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.Windows.CollectionRule.DBFile.SpaceFreePercent | Microsoft.SQLServer.Windows.DBFile | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroup.AllocatedSpaceLeftMB](/images/Rule.png) | MSSQL on Windows: ROWS Data Filegroup Allocated Free Space (MB) | The amount of space left in all files for this ROWS Data Filegroup in megabytes. Does not include space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroup.AllocatedSpaceLeftMB | Microsoft.SQLServer.Windows.DBFilegroup | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroup.AllocatedSpaceLeftPercent](/images/Rule.png) | MSSQL on Windows: ROWS Data Filegroup Allocated Free Space (\%) | The amount of space left in all files for this ROWS Data Filegroup in percentage terms. Does not include space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroup.AllocatedSpaceLeftPercent | Microsoft.SQLServer.Windows.DBFilegroup | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroup.SpaceFreeMegabytes](/images/Rule.png) | MSSQL on Windows: ROWS Data Filegroup Free Space Total (MB) | The amount of space left in all files for this ROWS Data Filegroup in megabytes. Also, includes space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroup.SpaceFreeMegabytes | Microsoft.SQLServer.Windows.DBFilegroup | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroup.SpaceFreePercent](/images/Rule.png) | MSSQL on Windows: ROWS Data Filegroup Free Space Total (\%) | Collects ROWS Data Filegroup free space in percentage terms. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroup.SpaceFreePercent | Microsoft.SQLServer.Windows.DBFilegroup | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFd.SpaceFreeMegabytes](/images/Rule.png) | MSSQL on Windows: FILESTREAM Data Filegroup Free Space Total (MB) | Collects free FILESTREAM Data Filegroup container space in megabytes. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFd.SpaceFreeMegabytes | Microsoft.SQLServer.Windows.DBFilegroupFd | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFd.SpaceFreePercent](/images/Rule.png) | MSSQL on Windows: FILESTREAM Data Filegroup Free Space Total (\%) | Collects free FILESTREAM Data Filegroup container space in percentage terms. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFd.SpaceFreePercent | Microsoft.SQLServer.Windows.DBFilegroupFd | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFileGroupFx.CheckpointFile.Active](/images/Rule.png) | MSSQL on Windows: Active Checkpoint File Pairs | Collects the number of active checkpoint file pairs in Memory-Optimized Data Filegroup. | Microsoft.SQLServer.Windows.CollectionRule.DBFileGroupFx.CheckpointFile.Active | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFileGroupFx.CheckpointFile.MergeTarget](/images/Rule.png) | MSSQL on Windows: Merge Target Checkpoint File Pairs | Collects the number of merge target checkpoint file pairs in Memory-Optimized Data Filegroup. | Microsoft.SQLServer.Windows.CollectionRule.DBFileGroupFx.CheckpointFile.MergeTarget | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFileGroupFx.CheckpointFile.Precreated](/images/Rule.png) | MSSQL on Windows: Precreated Checkpoint Files | Collects the number of Precreated Checkpoint Files in Memory-Optimized Data Filegroup. | Microsoft.SQLServer.Windows.CollectionRule.DBFileGroupFx.CheckpointFile.Precreated | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFileGroupFx.CheckpointFile.Stale](/images/Rule.png) | MSSQL on Windows: Checkpoint File Pairs Waiting For Log Truncation | Collects the number of Checkpoint Files Waiting For Log Truncation in Memory-Optimized Data Filegroup. | Microsoft.SQLServer.Windows.CollectionRule.DBFileGroupFx.CheckpointFile.Stale | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFileGroupFx.CheckpointFile.UnderConstruction](/images/Rule.png) | MSSQL on Windows: Checkpoint File Pairs Under Construction | Collects the number of checkpoint file pairs under construction in Memory-Optimized Data Filegroup. | Microsoft.SQLServer.Windows.CollectionRule.DBFileGroupFx.CheckpointFile.UnderConstruction | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.IndexesUsedMemoryMB](/images/Rule.png) | MSSQL on Windows: Memory Used By Indexes (MB) | Collects the amount of memory allocated for indexes defined for memory-optimized tables in the given SQL Server Database on Windows. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.IndexesUsedMemoryMB | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.SpaceFreeMegabytes](/images/Rule.png) | MSSQL on Windows: In-Memory OLTP Data Filegroup Free Space Total (MB) | Collects the amount of free space available across all containers in the In-Memory OLTP Data Filegroup (in Megabytes). | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.SpaceFreeMegabytes | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.SpaceFreePercent](/images/Rule.png) | MSSQL on Windows: In-Memory OLTP Data Filegroup Free Space Total (\%) | Collects the amount of free space available across all containers in the In-Memory OLTP Data Filegroup, expressed as percentage of the sum of disk free space and the size of data stored in the In-Memory OLTP Data Filegroup. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.SpaceFreePercent | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.TablesMemoryUsageMB](/images/Rule.png) | MSSQL on Windows: Memory Used By Tables (MB) | Collects the amount of memory allocated for memory-optimized tables in the given SQL Server Database on Windows. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.TablesMemoryUsageMB | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.XtpControllerDlcLatencyFetch](/images/Rule.png) | MSSQL on Windows: XTP Controller DLC Latency/Fetch | Collects the Windows "XTP Controller DLC Latency/Fetch" performance counter for SQL Database with Memory-Optimized tables. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.XtpControllerDlcLatencyFetch | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.XtpControllerDlcPeakLatency](/images/Rule.png) | MSSQL on Windows: XTP Controller DLC Peak Latency | Collects the Windows "XTP Controller DLC Peak Latency" performance counter for SQL Database with Memory-Optimized tables. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.XtpControllerDlcPeakLatency | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.XtpControllerLogProcessedSec](/images/Rule.png) | MSSQL on Windows: XTP Controller Log Processed/sec | Collects the Windows "XTP Controller Log Processed/sec" performance counter for SQL Database with Memory-Optimized tables. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.XtpControllerLogProcessedSec | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.XtpMemoryUsedKb](/images/Rule.png) | MSSQL on Windows: XTP Memory Used (KB) | Collects the Windows "XTP Memory Used (KB)" performance counter for SQL Database with Memory-Optimized tables. | Microsoft.SQLServer.Windows.CollectionRule.DBFilegroupFx.XtpMemoryUsedKb | Microsoft.SQLServer.Windows.DBFilegroupFx | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBLogFile.FileAllocatedSpaceLeftMB](/images/Rule.png) | MSSQL on Windows: DB Log File Allocated Free Space (MB) | The amount of space left in all log files for this database in megabytes. Does not include space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.Windows.CollectionRule.DBLogFile.FileAllocatedSpaceLeftMB | Microsoft.SQLServer.Windows.DBLogFile | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBLogFile.FileAllocatedSpaceLeftPercent](/images/Rule.png) | MSSQL on Windows: DB Log File Allocated Free Space (\%) | The amount of space left in all log files for this database in percentage terms. Does not include space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.Windows.CollectionRule.DBLogFile.FileAllocatedSpaceLeftPercent | Microsoft.SQLServer.Windows.DBLogFile | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBLogFile.SpaceFreeMegabytes](/images/Rule.png) | MSSQL on Windows: DB Log File Free Space Total (MB) | The amount of space left in all log files for this database in megabytes. Also, includes space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.Windows.CollectionRule.DBLogFile.SpaceFreeMegabytes | Microsoft.SQLServer.Windows.DBLogFile | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.DBLogFile.SpaceFreePercent](/images/Rule.png) | MSSQL on Windows: DB Log File Free Space Total (\%) | The amount of space left in all log files for this database in percentage terms. Also, includes space left on media hosting a file with autogrowth enabled. | Microsoft.SQLServer.Windows.CollectionRule.DBLogFile.SpaceFreePercent | Microsoft.SQLServer.Windows.DBLogFile | PerformanceCollection | False | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.ActiveMemoryGrantAmountKB](/images/Rule.png) | MSSQL on Windows: Number of query memory grants in the resource pool | Collects the Windows "Active Memory grant amount (KB)" performance counter for each resource pool of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.ActiveMemoryGrantAmountKB | Microsoft.SQLServer.Windows.ResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.ActiveMemoryGrantsCount](/images/Rule.png) | MSSQL on Windows: Total amount of granted memory in the resource pool (KB) | Collects the Windows "Active memory grants count" performance counter for each resource pool of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.ActiveMemoryGrantsCount | Microsoft.SQLServer.Windows.ResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.CacheMemoryTargetKB](/images/Rule.png) | MSSQL on Windows: Current memory target for cache memory (KB) | Collects the Windows "Cache memory target (KB)" performance counter for each resource pool of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.CacheMemoryTargetKB | Microsoft.SQLServer.Windows.ResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.CompileMemoryTargetKB](/images/Rule.png) | MSSQL on Windows: Current memory target for query compile (KB) | Collects the Windows "Compile Memory Target (KB)" performance counter for each resource pool of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.CompileMemoryTargetKB | Microsoft.SQLServer.Windows.ResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.MaxMemoryKB](/images/Rule.png) | MSSQL on Windows: Maximum amount of memory the resource pool can have based on the settings and server state (KB) | Collects the Windows "Max memory (KB)" performance counter for each resource pool of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.MaxMemoryKB | Microsoft.SQLServer.Windows.ResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.MemoryGrantsSec](/images/Rule.png) | MSSQL on Windows: Number of query memory grants per second occurring in the resource pool | Collects the Windows "Memory grants/sec" performance counter for each resource pool of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.MemoryGrantsSec | Microsoft.SQLServer.Windows.ResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.MemoryGrantTimeoutsSec](/images/Rule.png) | MSSQL on Windows: Number of query memory grant timeouts per second occurring in the resource pool | Collects the Windows "Memory grant timeouts/sec" performance counter for each resource pool of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.MemoryGrantTimeoutsSec | Microsoft.SQLServer.Windows.ResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.PendingMemoryGrantsCount](/images/Rule.png) | MSSQL on Windows: Number of queries waiting for memory grants in the resource pool. | Collects the Windows "Pending memory grants count" performance counter for each resource pool of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.PendingMemoryGrantsCount | Microsoft.SQLServer.Windows.ResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.QueryExecMemoryTargetKB](/images/Rule.png) | MSSQL on Windows: Current memory target for query execution memory grant (KB) | Collects the Windows "Query exec memory target (KB)" performance counter for each resource pool of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.QueryExecMemoryTargetKB | Microsoft.SQLServer.Windows.ResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.TargetMemoryKB](/images/Rule.png) | MSSQL on Windows: Target amount of memory the resource pool is trying to attain based on the settings and server state (KB) | Collects the Windows "Target memory (KB)" performance counter for each resource pool of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.TargetMemoryKB | Microsoft.SQLServer.Windows.ResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.UsedMemoryKB](/images/Rule.png) | MSSQL on Windows: Used amount of memory in the resource pool (KB) | Collects the Windows "Used memory (KB)" performance counter for each resource pool of SQL DB Engine. | Microsoft.SQLServer.Windows.CollectionRule.ResourcePool.UsedMemoryKB | Microsoft.SQLServer.Windows.ResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.UserResourcePool.MemoryConsumptionMB](/images/Rule.png) | MSSQL on Windows: User Resource Pool Memory Consumption (MB) | Collects amount of memory used by the resource pool (in Megabytes). | Microsoft.SQLServer.Windows.CollectionRule.UserResourcePool.MemoryConsumptionMB | Microsoft.SQLServer.Windows.UserResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.CollectionRule.UserResourcePool.MemoryConsumptionPercent](/images/Rule.png) | MSSQL on Windows: User Resource Pool Memory Consumption (\%) | Collects amount of memory used by the resource pool, expressed as a percentage of memory available for Memory-Optimized Data tables for the given Resource Pool. | Microsoft.SQLServer.Windows.CollectionRule.UserResourcePool.MemoryConsumptionPercent | Microsoft.SQLServer.Windows.UserResourcePool | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
![Microsoft.SQLServer.Windows.EventRule.AvailabilityReplica.AvailabilityGroupFailed](/images/Rule.png) | MSSQL on Windows: Availability Group Failed | This error occurs when an attempt to join the availability replica to the availability group has failed.
Note: this rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.AvailabilityReplica.AvailabilityGroupFailed | Microsoft.SQLServer.Windows.AvailabilityReplica | EventCollection | False | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.AvailabilityReplica.RoleChanged](/images/Rule.png) | MSSQL on Windows: Availability Replica Role Changed | This error occurs when Availability replica changes its role. | Microsoft.SQLServer.Windows.EventRule.AvailabilityReplica.RoleChanged | Microsoft.SQLServer.Windows.AvailabilityReplica | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.Database.Database_Backup_Failed_To_Complete_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Database Backup Failed To Complete | BACKUP failed to complete the command. | Microsoft.SQLServer.Windows.EventRule.Database.Database_Backup_Failed_To_Complete_1_5_Rule | Microsoft.SQLServer.Windows.Database | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.Database.Log_Backup_Failed_to_Complete_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Log Backup Failed to Complete | This error indicates that SQL Server could not complete the BACKUP of the specified database due to a previous error. The BACKUP command that failed is given at the end of the error message. This message also appears in the Windows application log. | Microsoft.SQLServer.Windows.EventRule.Database.Log_Backup_Failed_to_Complete_1_5_Rule | Microsoft.SQLServer.Windows.Database | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DatabaseReplica.RoleChanged](/images/Rule.png) | MSSQL on Windows: Database Replica Role Changed | This error occurs when Database replica changes its role. | Microsoft.SQLServer.Windows.EventRule.DatabaseReplica.RoleChanged | Microsoft.SQLServer.Windows.DatabaseReplica | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_a_SQL_Server_Service_Broker_Database_Mirroring_transport_connection_endpoint_1_5_Rule](/images/Rule.png) | MSSQL on Windows: An error occurred in a SQL Server Service Broker/Database Mirroring transport connection endpoint | SQL Server uses Service Broker and Database Mirroring endpoints for communication outside of the SQL Server instance. | Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_a_SQL_Server_Service_Broker_Database_Mirroring_transport_connection_endpoint_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_the_Service_Broker_manager_5_Rule](/images/Rule.png) | MSSQL on Windows: An error occurred in the Service Broker manager | The rule triggers an alert when an error occurred in the SQL Server Service Broker manager. | Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_the_Service_Broker_manager_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_the_Service_Broker_queue_rollback_handler_5_Rule](/images/Rule.png) | MSSQL on Windows: An error occurred in the Service Broker queue rollback handler | SQL Server Service Broker raises MSSQLSERVER event ID 8405 when an error prevents Service Broker from disabling a queue during a rollback. | Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_the_Service_Broker_queue_rollback_handler_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_the_SQL_Server_Service_Broker_message_dispatcher_5_Rule](/images/Rule.png) | MSSQL on Windows: An error occurred in the SQL Server Service Broker message dispatcher | An error occurred in the SQL Server Service Broker message dispatcher. The Windows application log or SQL Server error log may identify the specific error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_the_SQL_Server_Service_Broker_message_dispatcher_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_the_SQL_Server_Service_Broker_message_transmitter_5_Rule](/images/Rule.png) | MSSQL on Windows: An error occurred in the SQL Server Service Broker message transmitter | SQL Server Service Broker message transmitter detected an error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_the_SQL_Server_Service_Broker_message_transmitter_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_the_SQL_Server_Service_Broker_or_Database_Mirroring_transport_manager_5_Rule](/images/Rule.png) | MSSQL on Windows: An error occurred in the SQL Server Service Broker or Database Mirroring transport manager | An error occurred in the SQL Server Service Broker or Database Mirroring transport manager. The Windows application log or SQL Server error log may identify the specific error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_the_SQL_Server_Service_Broker_or_Database_Mirroring_transport_manager_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_the_timer_event_cache_5_Rule](/images/Rule.png) | MSSQL on Windows: An error occurred in the timer event cache | An error occurred in the SQL Server Service Broker transport layer timer event cache. The Windows application log or SQL Server error log may identify the specific error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_in_the_timer_event_cache_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_while_processing_SQL_Server_Service_Broker_mirroring_routes_5_Rule](/images/Rule.png) | MSSQL on Windows: An error occurred while processing SQL Server Service Broker mirroring routes | The rule triggers an alert when an error occurres while processing SQL Server Service Broker mirroring routes | Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_while_processing_SQL_Server_Service_Broker_mirroring_routes_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_while_processing_the_log_for_database_5_Rule](/images/Rule.png) | MSSQL on Windows: An error occurred while reading the log for database | This error indicates a failure while processing the transaction log during rollback, recovery, or replication. | Microsoft.SQLServer.Windows.EventRule.DBEngine.An_error_occurred_while_processing_the_log_for_database_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.An_SNI_call_failed_during_a_Service_Broker_Database_Mirroring_transport_operation_1_5_Rule](/images/Rule.png) | MSSQL on Windows: A SNI call failed during a Service Broker/Database Mirroring transport operation | The rule triggers an alert when a SNI call fails during a Service Broker/Database Mirroring transport operation. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.An_SNI_call_failed_during_a_Service_Broker_Database_Mirroring_transport_operation_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.An_SQL_Server_Service_Broker_dialog_caught_an_error_5_Rule](/images/Rule.png) | MSSQL on Windows: An SQL Server Service Broker dialog detected an error | The rule triggers an alert when a SQL Server Service Broker dialog detects an error | Microsoft.SQLServer.Windows.EventRule.DBEngine.An_SQL_Server_Service_Broker_dialog_caught_an_error_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.AppDomain_failed_to_unload_with_error_code_5_Rule](/images/Rule.png) | MSSQL on Windows: AppDomain failed to unload with error code | The rule triggers an application domain fails to unload because of some error. The Windows application log may contain an information about the original error code and other diagnostic details | Microsoft.SQLServer.Windows.EventRule.DBEngine.AppDomain_failed_to_unload_with_error_code_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Attempt_to_fetch_logical_page_that_belongs_to_different_object_5_Rule](/images/Rule.png) | MSSQL on Windows: Attempt to fetch logical page that belongs to different object | This error occurs when SQL Server detects that the allocation unit as stored on a database page does match the allocation unit associated with a specific operation, such as running a SELECT statement against a table. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Attempt_to_fetch_logical_page_that_belongs_to_different_object_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.AWE__Could_not_use_Address_Windowing_Extensions_because__lock_pages_in_memory__privilege_was_not_granted_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not use Address Windowing Extensions because 'lock pages in memory' privilege was not granted | The rule triggers an alert when SQL Server cannot use Address Windowing Extensions because 'lock pages in memory' because privilege was not granted. | Microsoft.SQLServer.Windows.EventRule.DBEngine.AWE__Could_not_use_Address_Windowing_Extensions_because__lock_pages_in_memory__privilege_was_not_granted_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.A_default_full_text_catalog_does_not_exist_in_the_database_or_user_does_not_have_permission_to_perform_this_action_5_Rule](/images/Rule.png) | MSSQL on Windows: A default full-text catalog does not exist in the database or user does not have permission to perform this action | The full-text catalog does not exist, or the user does not have the appropriate permission to create a full-text index in the catalog. | Microsoft.SQLServer.Windows.EventRule.DBEngine.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.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.A_fatal_error_occurred_in_.NET_Framework_runtime_5_Rule](/images/Rule.png) | MSSQL on Windows: A fatal error occurred in .NET Framework runtime | The rule triggers an alert when the .NET Framework shuts down due to an error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.A_fatal_error_occurred_in_.NET_Framework_runtime_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.A_security__SSPI__error_occurred_when_connecting_to_another_Service_Broker_or_Database_Mirroring_host_5_Rule](/images/Rule.png) | MSSQL on Windows: A security (SSPI) error occurred when connecting to another Service Broker or Database Mirroring host | When Service Broker transport security uses SSPI, the service account for the remote database must have CONNECT permission in master database. Remote SQL Server instance should allow Windows Authentication for the account being used by remote host. There are no requirements for the login to have other permissions or to own objects in any database. | Microsoft.SQLServer.Windows.EventRule.DBEngine.A_security__SSPI__error_occurred_when_connecting_to_another_Service_Broker_or_Database_Mirroring_host_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.A_SQL_Server_Service_Broker_conversation_closed_due_to_an_error_5_Rule](/images/Rule.png) | MSSQL on Windows: A SQL Server Service Broker conversation has been closed due to an error | The rule triggers an alert when a SQL Server Service Broker conversation has been closed due to an error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.A_SQL_Server_Service_Broker_conversation_closed_due_to_an_error_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.A_SQL_Server_Service_Broker_cryptographic_operation_failed_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Service Broker cryptographic operation failed | The rule triggers an alert when SQL Server Service Broker cryptographic operation fails. | Microsoft.SQLServer.Windows.EventRule.DBEngine.A_SQL_Server_Service_Broker_cryptographic_operation_failed_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.A_SQL_Server_Service_Broker_procedure_output_results_5_Rule](/images/Rule.png) | MSSQL on Windows: A SQL Server Service Broker procedure output results | A stored procedure, which was internally activated by SQL Server Service Broker, output results. Internal procedures should not output results. The event in the Windows application log contains the procedure name, the queue name, and the output results. The event is logged as MSSQLSERVER event ID 9724. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.A_SQL_Server_Service_Broker_procedure_output_results_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Information | Low | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Backup_device_failed___Operating_system_error_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Backup device failed - Operating system error | This message indicates that the operating system was unable to open or close a backup device (disk, tape, or pipe) specified as part of a BACKUP or RESTORE command. For more information on backup devices, refer to the Books Online topics, "Backup Devices" and "BACKUP." | Microsoft.SQLServer.Windows.EventRule.DBEngine.Backup_device_failed___Operating_system_error_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_determine_the_service_account_for_SQL_Server_instance_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Cannot determine the service account for SQL Server instance | This error occurs when a Transact-SQL statement contains mismatched single or double quotes. The SET QUOTED_IDENTIFIER setting will determine which combinations of single and double quotations marks are valid. For more information about SET QUOTED_IDENTIFIER, see "SET QUOTED_IDENTIFIER" in Books Online. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_determine_the_service_account_for_SQL_Server_instance_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_open_backup_device.__1_5_Rule](/images/Rule.png) | MSSQL on Windows: Cannot open backup device. | One or more of the files specified in a BACKUP or RESTORE command could not be opened. The potential reasons for this include: | Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_open_backup_device.__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_open_user_default_database._Login_failed_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Cannot open user default database. Login failed | When a client connects to a SQL Server instance without specifying a database context, the default database defined for its login is used. If that database is unavailable for any reason, the above message appears. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_open_user_default_database._Login_failed_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_recover_the_master_database._Exiting_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Cannot recover the master database. Exiting. | The master database is not in a recoverable state. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_recover_the_master_database._Exiting_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_start_service_broker_activation_manager_5_Rule](/images/Rule.png) | MSSQL on Windows: Cannot start service broker activation manager | The rule triggers an alert when service broker fails to start the activation manager. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_start_service_broker_activation_manager_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_start_service_broker_manager_5_Rule](/images/Rule.png) | MSSQL on Windows: Cannot start service broker manager | The rule triggers an alert when SQL Server cannot start service broker manager. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_start_service_broker_manager_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_start_service_broker_manager_due_to_operating_system_error_5_Rule](/images/Rule.png) | MSSQL on Windows: Cannot start service broker manager due to operating system error | The rule triggers an alert when SQL Server cannot start service broker manager due to operating system error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_start_service_broker_manager_due_to_operating_system_error_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_start_service_broker_security_manager_5_Rule](/images/Rule.png) | MSSQL on Windows: Cannot start service broker security manager | Service Broker security manger could not start. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_start_service_broker_security_manager_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_start_SQL_Server_Service_Broker_on_Database_5_Rule](/images/Rule.png) | MSSQL on Windows: Cannot start SQL Server Service Broker on a database | The rule triggers an alert when SQL Server cannot start Service Broker on a database. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Cannot_start_SQL_Server_Service_Broker_on_Database_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.CHECKTABLE_processing_of_object_encountered_page_twice._Possible_internal_error_or_allocation_fault_1_5_Rule](/images/Rule.png) | MSSQL on Windows: CHECKTABLE processing of object encountered page twice. Possible internal error or allocation fault | Page P_ID was encountered twice during the course of the scan. | Microsoft.SQLServer.Windows.EventRule.DBEngine.CHECKTABLE_processing_of_object_encountered_page_twice._Possible_internal_error_or_allocation_fault_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.CHECKTABLE_terminated._A_failure_was_detected_while_collecting_facts._Possibly_tempdb_out_of_space_or_a_system_table_is_inconsistent._Check_previous_errors_1_5_Rule](/images/Rule.png) | MSSQL on Windows: 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.Windows.EventRule.DBEngine.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.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Check_sum_failure_while_page_in_cache_id832](/images/Rule.png) | MSSQL on Windows: Checksum failure while page in cache | It is detected that a database page has been unexpectedly modified while in cache (by verifying the page checksum). | Microsoft.SQLServer.Windows.EventRule.DBEngine.Check_sum_failure_while_page_in_cache_id832 | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Commit_of_internal_MSDTC_transaction_failed_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Commit of internal MSDTC transaction failed | The rule triggers an error when COMMIT of internal MSDTC transaction failed | Microsoft.SQLServer.Windows.EventRule.DBEngine.Commit_of_internal_MSDTC_transaction_failed_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Common_Language_Runtime__CLR__not_installed_properly_5_Rule](/images/Rule.png) | MSSQL on Windows: Common Language Runtime (CLR) not installed properly | This installation of the Common Language Runtime (CLR) is corrupted. The CLR is installed with the Microsoft .NET Framework. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Common_Language_Runtime__CLR__not_installed_properly_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Conflict_table__does_not_exist_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Conflict table does not exist | This error occurs when you try to add or drop a column to a merge article, but the conflict table specified in sysmergearticles for the modified article does not actually exist in the database. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Conflict_table__does_not_exist_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_allocate_new_page_for_database_._There_are_no_more_pages_available_in_filegroup.1_5_Rule](/images/Rule.png) | MSSQL on Windows: 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.Windows.EventRule.DBEngine.Could_not_allocate_new_page_for_database_._There_are_no_more_pages_available_in_filegroup.1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_allocate_space_for_object__in_database__because_the__filegroup_is_full_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not allocate space for object in database because the Filegroup is full | The specified Filegroup has run out of free space. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_allocate_space_for_object__in_database__because_the__filegroup_is_full_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_connect_to_server_because_it_is_not_defined_as_a_remote_login_at_the_server_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not connect to server because it is not defined as a remote login at the server | Setting up security for executing remote procedure calls (RPC) against a remote server involves setting up login mappings in the remote server and possibly in the local server running an instance of Microsoft SQL Server. The mapping is specific to a given server\instance name, usually the NetBIOS name for a default instance and the NetBIOS name plus the instance name for a named instance. If the login mapping does not exist or if the name of the server specified in the connection string does not match the exact name in the sysremotelogins table, and the guest account does not have a mapping in sysremotelogins , you will receive this error. You will also see this error if the remote user is found to have a null or empty login name. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_connect_to_server_because_it_is_not_defined_as_a_remote_login_at_the_server_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_create_an_instance_of_OLE_DB_provider_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not create an instance of OLE DB provider | The rule triggers an alert when SQL Server could not create an instance of an OLE DB provider to connect to a linked server. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_create_an_instance_of_OLE_DB_provider_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_create_AppDomain_manager_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not create AppDomain manager | The rule triggers an alert when SQL Server fails to create an application domain manager | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_create_AppDomain_manager_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_create_a_statement_object_using_OLE_DB_provider_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not create a statement object using OLE DB provider | The rule triggers an alert when SQL Server fails to create a statement object with the OLE DB provider connected to a linked server. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_create_a_statement_object_using_OLE_DB_provider_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_do_cleanup_for_the_killed_process_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not do cleanup for the killed process | This error message occurs when another error caused a user connection to terminate abnormally. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_do_cleanup_for_the_killed_process_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_find_CHECK_constraint_although_the_table_is_flagged_as_having_one_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not find CHECK constraint, although the table is flagged as having one | This error can occur when the creation of a constraint failed but for some reason the creation was not completely rolled back. It can also be caused by data consistency issue with the system tables in the database where the table listed in the message resides. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_find_CHECK_constraint_although_the_table_is_flagged_as_having_one_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_find_filegroup_ID_in_sys.filegroups_for_database_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not find Filegroup ID in sys.Filegroups for database | The metadata for a table contains a column ID that is greater than the largest column ID ever used in the table. This is a fatal error if the table is a system table, because the checks cannot continue when metadata is corrupt. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_find_filegroup_ID_in_sys.filegroups_for_database_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_find_FOREIGN_KEY_constraints_for_table_although_the_table_is_flagged_as_having_them_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not find FOREIGN KEY constraints for table, although the table is flagged as having them | This error can occur when the creation of a constraint failed but for some reason the creation was not completely rolled back. It can also be caused by data consistency issue with the system tables in the database where the table listed in the message resides. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_find_FOREIGN_KEY_constraints_for_table_although_the_table_is_flagged_as_having_them_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_mark_database_as_suspect._Getnext_NC_scan_on_sysdatabases.dbid_failed_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not mark database as suspect. Getnext NC scan on sysdatabases.dbid failed | The SQL Server recovery process tried to turn on the suspect flag for the specified database, but it could not find the appropriate row in sysdatabases or could not update the database information in memory. The reason the database needs to be marked suspect should be indicated by other messages in the SQL Server error log or the Event Viewer. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_mark_database_as_suspect._Getnext_NC_scan_on_sysdatabases.dbid_failed_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_obtain_exclusive_lock_on_database_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not obtain exclusive lock on database | You may receive this error stating a lock could not be obtained for the model database if the model database is in use when you issue any CREATE DATABASE statement. Since a new database is copied from the model database, the model database has to be in a state with no activity. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_obtain_exclusive_lock_on_database_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_obtain_information_about_Windows_NT_group_user_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not obtain information about Windows NT group/user | A process executed within SQL Server or from the SQL Server Agent, such as the xp_logininfo stored procedure, a scheduled job, or a replication agent, needs to verify the credentials of a Windows-authenticated login. The attempt to retrieve those credentials on the domain failed for an unspecified reason. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_obtain_information_about_Windows_NT_group_user_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_open_device_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Failed to open primary database file | An operating system error occurred when opening the primary file of a database. The error message contains the specific operating system error encountered. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_open_device_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_open_error_log_file_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not open error log file | When installing Microsoft SQL Server on an NTFS partition, make sure that the NTFS file permissions allow read/write access. Otherwise, this error message may appear in the Microsoft Windows NT application log (for each installation attempt). | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_open_error_log_file_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_open_FCB_for_invalid_file_in_database__1_5_Rule](/images/Rule.png) | MSSQL on Windows: Invalid reference to File ID | This error occurs when SQL Server uses an invalid file ID while performing some operation. This error can occur for several different scenarios. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_open_FCB_for_invalid_file_in_database__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_open_referenced_table_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not open referenced table | You are trying to add, drop, or modify a constraint on a table that has a schema stability lock (LCK_M_SCH_S or Sch-S) held on it. The schema stability lock is not compatible with DDL. The lock may be held by a query involving this table that is taking a long time to compile. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_open_referenced_table_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_open_tempdb.__Cannot_continue_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not open tempdb. Cannot continue | The tempdb database could not be opened. The possible reasons for this could include: | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_open_tempdb.__Cannot_continue_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_read_and_latch_page_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not read and latch page | The page read failed for some reason (see any accompanying errors), or a latch could not be taken (there may be latch timeout messages on the error log). | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_read_and_latch_page_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_recover_database_due_to_unresolved_transaction_outcomes_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not recover database due to unresolved transaction outcomes | The recovery process found pending transactions for the specified database. These transactions were either distributed transactions that used Microsoft Distributed Transaction Coordinator (MS DTC), or the transactions were single instance cross-database transactions. There is not enough information available for the recovery process to either commit or roll back one or more of those transactions. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_recover_database_due_to_unresolved_transaction_outcomes_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_resolve_the_referenced_column_name_in_table_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not resolve the referenced column name in table | This error occurs when you try to modify data in a table with a foreign key that references a column that no longer exists in the referenced table. Merely renaming a column will not cause this error. Under normal circumstances, a column referenced by a foreign key cannot be dropped, so this error may indicate that unsupported direct system table updates have occurred. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_resolve_the_referenced_column_name_in_table_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_write_a_CHECKPOINT_record_in_database_because_the_log_is_out_of_space_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Could not write a CHECKPOINT record in database because the log is out of space | The transaction log for the specified database has reached its capacity. The limit could be due to a configuration setting or to the amount of physical space available for one or more of the files configured for this database. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Could_not_write_a_CHECKPOINT_record_in_database_because_the_log_is_out_of_space_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.CREATE_DATABASE_failed._Could_not_allocate_enough_disk_space_for_a_new_database_on_the_named_disks_1_5_Rule](/images/Rule.png) | MSSQL on Windows: CREATE DATABASE failed. Could not allocate enough disk space for a new database on the named disks | This error occurs when there is not enough space on the device to create the model database. | Microsoft.SQLServer.Windows.EventRule.DBEngine.CREATE_DATABASE_failed._Could_not_allocate_enough_disk_space_for_a_new_database_on_the_named_disks_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Database_cannot_be_opened_due_to_inaccessible_files_or_insufficient_memory_or_disk_space._See_the_SQL_Server_errorlog_for_details_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Database cannot be opened due to inaccessible files or insufficient memory or disk space | Error 945 is returned when the database is marked IsShutdown . This occurs when a database cannot be recovered due to missing files, or some other resource error that usually can be corrected easily. | Microsoft.SQLServer.Windows.EventRule.DBEngine.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.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Database_could_not_recover_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Failure occurred during database recovery | This error occurs when SQL Server fails to recover a database successfully when it is brought online. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Database_could_not_recover_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Database_log_file_is_full._Back_up_the_transaction_log_for_the_database_to_free_up_some_log_space_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Database log file is full. Back up the transaction log for the database to free up some log space | The specified transaction log file has run out of free space. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Database_log_file_is_full._Back_up_the_transaction_log_for_the_database_to_free_up_some_log_space_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.DBCC_executed_found_and_not_repaired_errors_Rule](/images/Rule.png) | MSSQL on Windows: Database consistency errors found | This message indicates a database consistency check has encountered errors and none or not all of the errors were repaired. | Microsoft.SQLServer.Windows.EventRule.DBEngine.DBCC_executed_found_and_not_repaired_errors_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.DBCC_executed_found_and_repaired_errors_Rule](/images/Rule.png) | MSSQL on Windows: Database consistency errors found and repaired | This message indicates a database consistency check has encountered errors and all of the errors were repaired. | Microsoft.SQLServer.Windows.EventRule.DBEngine.DBCC_executed_found_and_repaired_errors_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.DBCC_executed_found_no_errors_Rule](/images/Rule.png) | MSSQL on Windows: Database consistency check performed with no errors | This message indicates a database consistency check has been run but no errors were encountered. | Microsoft.SQLServer.Windows.EventRule.DBEngine.DBCC_executed_found_no_errors_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Information | Low | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Descriptor_for_object_in_database_not_found_in_the_hash_table_during_attempt_to_unhash_it_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Descriptor for object in database not found in the hash table during attempt to unhash it | A temporary table could not be found. The specific object ID will be available in the Windows application log as event ID 617. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Descriptor_for_object_in_database_not_found_in_the_hash_table_during_attempt_to_unhash_it_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Distributed_transaction_aborted_by_MSDTC_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Distributed transaction was aborted by MSDTC | The rule triggers an alert when Distributed transaction was aborted by MSDTC. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Distributed_transaction_aborted_by_MSDTC_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Enlist_of_MSDTC_transaction_failed_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Enlist of MSDTC transaction failed | The rule triggers an alert when SQL Server fails to enlist a new or existing distributed transaction. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Enlist_of_MSDTC_transaction_failed_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Error_recovering_database_._Could_not_connect_to_MSDTC_to_check_the_completion_status_of_transaction_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Error recovering database. Could not connect to MSDTC to check the completion status of transaction | When you are using MS DTC to manage a distributed transaction across multiple servers and a loss of connectivity occurs, the distributed transaction is left in an unknown or "in doubt" state. Common sources of interruptions are | Microsoft.SQLServer.Windows.EventRule.DBEngine.Error_recovering_database_._Could_not_connect_to_MSDTC_to_check_the_completion_status_of_transaction_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Error_while_undoing_logged_operation_in_database__1_5_Rule](/images/Rule.png) | MSSQL on Windows: Error while undoing logged operation in database | The recovery process could not undo (roll back) one or more transactions in the specified database. This error will be accompanied by a more specific error in the SQL Server error log and/or the event log. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Error_while_undoing_logged_operation_in_database__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.EventCollectionRule.DBEngine.CannotCreateFile](/images/Rule.png) | MSSQL on Windows: Cannot create file | SQL Server cannot create file because the file already exists. | Microsoft.SQLServer.Windows.EventRule.DBEngine.EventCollectionRule.DBEngine.CannotCreateFile | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.EventCollectionRule.DBEngine.CreateFileEncounteredOperatingSystemError](/images/Rule.png) | MSSQL on Windows: CREATE FILE encountered operating system error | CREATE FILE encountered operating system error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.EventCollectionRule.DBEngine.CreateFileEncounteredOperatingSystemError | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.EventCollectionRule.DBEngine.SQLServerOutOfMemory](/images/Rule.png) | MSSQL on Windows: SQL Server Out Of Memory | SQL Server has failed to allocate the sufficient amount of memory to run the query. | Microsoft.SQLServer.Windows.EventRule.DBEngine.EventCollectionRule.DBEngine.SQLServerOutOfMemory | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.EventCollectionRule.DBEngine.UnableToOpenThePhysicalFile](/images/Rule.png) | MSSQL on Windows: Unable to open the physical file | SQL Server has failed to open the physical file. | Microsoft.SQLServer.Windows.EventRule.DBEngine.EventCollectionRule.DBEngine.UnableToOpenThePhysicalFile | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_add_column__to_table__1_5_Rule](/images/Rule.png) | MSSQL on Windows: Failed to add column to table | sp_repladdcolumn failed to add the specified column to the table in the publication database. If another error is reported along with this one, the other error should indicate the reason the column could not be added. If no other error is reported, the problem could be that the owner-qualified table does not exist, or the data type is not one that can be added to a replicated table. The data type of the new column must be either an identity, computed, or timestamp column; allow nulls; or have a default. For more information about sp_repladdcolumn, see "Schema Changes on Publication Databases" in Books Online. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_add_column__to_table__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_allocate_memory_for_Common_Language_Runtime__CLR__5_Rule](/images/Rule.png) | MSSQL on Windows: Failed to allocate memory for Common Language Runtime (CLR) | The rule triggers an alert when SQL Server is unable to allocate memory for CLR. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_allocate_memory_for_Common_Language_Runtime__CLR__5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_create_AppDomain_5_Rule](/images/Rule.png) | MSSQL on Windows: Failed to create AppDomain | The rule triggers an alert when an application tried to create an application domain, but failed. This may be caused when there is not enough memory to start the application domain. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_create_AppDomain_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_drop_column__from_table__1_5_Rule](/images/Rule.png) | MSSQL on Windows: Failed to drop column from table | sp_repldropcolumn failed to drop the specified column on the publication database. The error could result from a failed system table update or from a failure of the underlying ALTER TABLE statement. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_drop_column__from_table__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_finish_full_text_operation._The_filegroup_is_empty_read_only_or_not_online_5_Rule](/images/Rule.png) | MSSQL on Windows: Failed to finish full-text operation. The Filegroup is empty, read-only, or not online | The full-text operation did not finish because the Filegroup is empty, read-only, or not online. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_finish_full_text_operation._The_filegroup_is_empty_read_only_or_not_online_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_initialize_the_Common_Language_Runtime__CLR__due_to_memory_pressure_5_Rule](/images/Rule.png) | MSSQL on Windows: Failed to initialize the Common Language Runtime (CLR) due to memory pressure | Windows could not allocate memory for the Microsoft Common Language Runtime (CLR) to initialize. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_initialize_the_Common_Language_Runtime__CLR__due_to_memory_pressure_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_initialize_the_Common_Language_Runtime__CLR__with_HRESULT_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Failed to initialize the Common Language Runtime (CLR) with HRESULT (6511) | The rule triggers an alert when an assembly or application fails to start and logs an HRESULT error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_initialize_the_Common_Language_Runtime__CLR__with_HRESULT_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_initialize_the_Common_Language_Runtime__CLR__with_HRESULT_5_Rule](/images/Rule.png) | MSSQL on Windows: Failed to initialize the Common Language Runtime (CLR) with HRESULT (6512) | The rule triggers an alert when an assembly or an application fails to start and logs an HRESULT error. The Windows application log may contain an information about specific HRESULT. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_initialize_the_Common_Language_Runtime__CLR__with_HRESULT_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_restore_master_database._Shutting_down_SQL_Server_5_Rule](/images/Rule.png) | MSSQL on Windows: Failed to restore master database. Shutting down SQL Server | The backup of the master database that you are restoring is not usable. The file itself may have been corrupted, or the original master database from which the backup was taken may have data integrity problems. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Failed_to_restore_master_database._Shutting_down_SQL_Server_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Full_Text_Search___An_unknown_full_text_failure_occurred_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Full Text Search: An unknown full-text failure occurred | This error can occur in various circumstances. It is often related to permissions or missing files. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Full_Text_Search___An_unknown_full_text_failure_occurred_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Full_Text_Search___Could_not_find_full_text_index_for_database_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Full Text Search: Could not find full-text index for database | The specified full-text index is unavailable. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Full_Text_Search___Could_not_find_full_text_index_for_database_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Full_Text_Search___Full_text_catalog_is_in_a_unusable_state._Drop_and_re_create_this_full_text_catalog_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Full Text Search: Full-text catalog is in an unusable state. Drop and re-create this full-text catalog | The full-text catalog is offline. The full-text directory has been deleted, is corrupt, or the path points to a location that is not valid. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Full_Text_Search___Full_text_catalog_is_in_a_unusable_state._Drop_and_re_create_this_full_text_catalog_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Full_Text_Search___Full_text_catalog_lacks_sufficient_disk_space_to_complete_this_operation_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Full Text Search: Full-text catalog lacks sufficient disk space to complete this operation | There is not enough disk space to hold the full-text catalog. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Full_Text_Search___Full_text_catalog_lacks_sufficient_disk_space_to_complete_this_operation_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Full_Text_Search___Full_Text_Search_is_not_enabled_for_the_current_database._Use_sp_fulltext_database_to_enable_Full_Text_Search_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Full Text Search: Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable Full-Text Search | You have attempted to perform a full-text indexing in a database that is not enabled for full-text indexing. The database may have never been enabled for full-text, or it may have been restored or attached, which will automatically disable full-text indexing. | Microsoft.SQLServer.Windows.EventRule.DBEngine.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.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Full_Text_Search___Search_on_full_text_catalog_failed_with_unknown_result_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Full Text Search: Search on full-text catalog failed with unknown result | The full-text query failed for an unspecified reason. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Full_Text_Search___Search_on_full_text_catalog_failed_with_unknown_result_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Indexed_view_does_not_contain_all_rows_that_the_view_definition_produces.__Refer_to_Books_Online_for_more_information_on_this_error.5_Rule](/images/Rule.png) | MSSQL on Windows: 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.Windows.EventRule.DBEngine.Indexed_view_does_not_contain_all_rows_that_the_view_definition_produces.__Refer_to_Books_Online_for_more_information_on_this_error.5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Internal_Query_Processor_Error__The_query_processor_could_not_obtain_access_to_a_required_interface_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Internal Query Processor Error: The query processor could not obtain access to a required interface | This is an internal query processor error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Internal_Query_Processor_Error__The_query_processor_could_not_obtain_access_to_a_required_interface_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Internal_Query_Processor_Error__The_query_processor_encountered_an_internal_limit_overflow_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Internal Query Processor Error: The query processor encountered an internal limit overflow | This is an internal query processor error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Internal_Query_Processor_Error__The_query_processor_encountered_an_internal_limit_overflow_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Internal_Query_Processor_Error__The_query_processor_encountered_an_unexpected_error_during_execution_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Internal Query Processor Error: The query processor encountered an unexpected error during execution | This is an internal query processor error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Internal_Query_Processor_Error__The_query_processor_encountered_an_unexpected_error_during_execution_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Internal_Query_Processor_Error__The_query_processor_encountered_an_unexpected_error_during_the_processing_of_a_remote_query_phase_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Internal Query Processor Error: The query processor encountered an unexpected error during the processing of a remote query phase | This is an internal query processor error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Internal_Query_Processor_Error__The_query_processor_encountered_an_unexpected_error_during_the_processing_of_a_remote_query_phase_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Internal_Query_Processor_Error__The_query_processor_ran_out_of_stack_space_during_query_optimization_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Internal Query Processor Error: The query processor ran out of stack space during query optimization | The Query Processor is using a large but limited memory stack when optimizing queries. In some extreme situations the stack size may become a limit for a given very large query--for example, a query containing an inlist with 100,000 constants. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Internal_Query_Processor_Error__The_query_processor_ran_out_of_stack_space_during_query_optimization_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Invalid_reference_to_LOB_page_id7105](/images/Rule.png) | MSSQL on Windows: Invalid reference to LOB page | This error occurs when SQL Server uses an invalid reference to a LOB page in an operation. This error may occur due to several different reasons. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Invalid_reference_to_LOB_page_id7105 | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.IORequestsTakingLongerThen15SecondsToComplete](/images/Rule.png) | MSSQL on Windows: I/O request taking longer than 15 seconds to complete | I/O request has taken longer than 15 seconds to complete. This may indicate an SQL Server I/O bottlenecks. SQL Server performance highly relies on the disk performance. Note: this rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.IORequestsTakingLongerThen15SecondsToComplete | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.IO_Completion_Listener_Worker_appears_to_be_non_yielding_on_Node_5_Rule](/images/Rule.png) | MSSQL on Windows: IO Completion Listener Worker appears to be non-yielding on Node | I/O completion ports are the mechanism by which Microsoft SQL Server uses a pool of threads that was created when the service was started to process asynchronous I/O requests. The message will specify what node the completion port is not yielding on. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.IO_Completion_Listener_Worker_appears_to_be_non_yielding_on_Node_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Logical_consistency_error_after_performing_IO_on_page_id824](/images/Rule.png) | MSSQL on Windows: Logical consistency error after performing I/O on page | A consistency check failed when reading or writing a database page or transaction log block. The error message contains the specific type of consistency check that failed. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Logical_consistency_error_after_performing_IO_on_page_id824 | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Logical_page_in_database_is_already_hashed_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Logical page in database is already hashed | This error occurs when SQL Server attempts to hash the logical page \%S_PGID of database ID\%d and the page is already in the SQL Server hash table. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Logical_page_in_database_is_already_hashed_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed._The_workstation_licensing_limit_for_SQL_Server_access_has_already_been_reached_5_Rule](/images/Rule.png) | MSSQL on Windows: Login failed. The workstation licensing limit for SQL Server access has already been reached | SQL Server will not provide connections to workstations after the licensing limit has been reached. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed._The_workstation_licensing_limit_for_SQL_Server_access_has_already_been_reached_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Account](/images/Rule.png) | MSSQL on Windows: Login failed | When a connection attempt is rejected because of an authentication failure that involves a bad password or user name, a message similar to the following is returned to the client: "Login failed for user 'user_name'. (Microsoft SQL Server, Error: 18456)". | Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Account | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Account_locked_out_5_Rule](/images/Rule.png) | MSSQL on Windows: Login failed: Account locked out | A user attempted to log into the network with an account that has been locked out. The Windows security log will identify the user name under MSSQLSERVER event ID 18486. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Account_locked_out_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Error_during_validation_5_Rule](/images/Rule.png) | MSSQL on Windows: Login failed: Error during validation | A user attempted to log in to SQL Server. An unexpected error occurred during validation. The Windows security log will identify the user name and error ID under MSSQLSERVER event ID 18468. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Error_during_validation_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_cannot_be_used_at_this_time_5_Rule](/images/Rule.png) | MSSQL on Windows: Login failed: Password cannot be used at this time | A user attempted to change the password, but the proposed password could not be used at this time. The Windows security log will identify the user name under MSSQLSERVER event ID 18463. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_cannot_be_used_at_this_time_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_expired_5_Rule](/images/Rule.png) | MSSQL on Windows: Login failed: Password expired | A user attempted to log into SQL Server with an expired password. The Windows security log will identify the user name under event ID 18487. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_expired_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_fails_password_filter_DLL_requirements_5_Rule](/images/Rule.png) | MSSQL on Windows: Login failed: Password fails password filter DLL requirements | A user tried to access SQL Server with a password that did not meet the requirements of the password filter DLL. Windows security log will identify the user name under MSSQLSERVER event ID 18467. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_fails_password_filter_DLL_requirements_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_must_be_changed_5_Rule](/images/Rule.png) | MSSQL on Windows: Login failed: Password must be changed | A user attempted to log into SQL Server with a password that was set to the MUST_CHANGE option. The user will be identified in the Windows security log under MSSQLSERVER event ID 18488. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_must_be_changed_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_too_long_5_Rule](/images/Rule.png) | MSSQL on Windows: Login failed: Password too long | A user attempted to create a password, but the proposed password was too long. The Windows security log will identify the user name under MSSQLSERVER event ID 18465. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_too_long_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_too_short_5_Rule](/images/Rule.png) | MSSQL on Windows: Login failed: Password too short | A user attempted to change the password, but the proposed password was too short. The Windows security log will identify the user name under MSSQLSERVER event ID 18464. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_too_short_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_too_simple_5_Rule](/images/Rule.png) | MSSQL on Windows: Login failed: Password too simple | A user attempted to create a password, but the proposed password did not meet the Windows password complexity requirements policy. These are defined in the Password must meet complexity requirements policy setting. The Windows security log will identify the user name under MSSQLSERVER event ID 18466. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Login_failed__Password_too_simple_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Maximum_limit_for_connections_has_been_reached_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Maximum limit for connections has been reached | By default, SQL Server dynamically manages the memory needed for user connections. However, the maximum number of connections can be set to a fixed value by setting the user connections configuration option to a value other than 0. Setting the user connections option to a non-zero value is not recommended. If this option is set to a non-zero value and the specified number of connections is exceeded, any additional login attempts will fail with the above message. If the value is set to 1, the SQL Server instance may not start. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Maximum_limit_for_connections_has_been_reached_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.MSDTC_on_server__is_unavailable_1_5_Rule](/images/Rule.png) | MSSQL on Windows: MSDTC on server is unavailable | The rule triggers an alert when MSDTC on the server is unavailable. | Microsoft.SQLServer.Windows.EventRule.DBEngine.MSDTC_on_server__is_unavailable_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.No_slots_are_free_to_keep_buffers_for_table__1_5_Rule](/images/Rule.png) | MSSQL on Windows: No slots are free to keep buffers for table | This is raised when SQL Server has an internal error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.No_slots_are_free_to_keep_buffers_for_table__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.One_or_more_indexes_are_damaged_and_must_be_repaired_or_dropped_1_5_Rule](/images/Rule.png) | MSSQL on Windows: One or more indexes are damaged and must be repaired or dropped | This error provides more details about the problem described in error 8952. See that error for an explanation. | Microsoft.SQLServer.Windows.EventRule.DBEngine.One_or_more_indexes_are_damaged_and_must_be_repaired_or_dropped_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Operating_system_error_during_creation_opening_of_physical_device_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Failed to open database or transaction log file | An operating system error occurred when opening a transaction log file or a secondary database file of a database. The error message contains the specific operating system error encountered. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Operating_system_error_during_creation_opening_of_physical_device_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Operating_System_error_encountered_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Operating System error encountered | This message indicates that an error of some sort was returned from the operating system to a process within SQL Server. The process listed at the beginning of the message indicates which function within SQL Server received the error from the operating system. The exact operating system error number and text at the end of the message will vary depending on what problem the operating system encountered. This error is usually seen in conjunction with other errors. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Operating_System_error_encountered_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Operating_system_error_on_a_device_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Operating system error on a device | The backup device cannot be opened. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Operating_system_error_on_a_device_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Optimized_concurrent_query_limit_has_been_exceeded_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Optimized concurrent query limit has been exceeded | You are using an edition of SQL Server that is licensed for a limited number of concurrent queries. This includes the Personal and Desktop editions. Those editions have a concurrent workload governor that limits them to a specific number of concurrent user queries plus a smaller number of concurrent system tasks. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Optimized_concurrent_query_limit_has_been_exceeded_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.OSError_Occurred_While_Performing_IO_onpage_id823](/images/Rule.png) | MSSQL on Windows: OS Error occurred while performing I/O on page | An operating system error occurred when reading or writing a database page. The error message contains the specific operating system error encountered. | Microsoft.SQLServer.Windows.EventRule.DBEngine.OSError_Occurred_While_Performing_IO_onpage_id823 | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Permission_denied_on_object_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Permission denied on object | This error occurs when a Microsoft SQL Server user attempts an action, such as executing a stored procedure, or reading or modifying a table, for which the user does not have the appropriate privileges. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Permission_denied_on_object_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.PhysicalFileAccessError](/images/Rule.png) | MSSQL on Windows: Physical file access error | A file activation error occurred. The physical file name may be incorrect while creating the database.
Note: this rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.PhysicalFileAccessError | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Potential_deadlocks_exist_on_all_schedulers_on_Node_5_Rule](/images/Rule.png) | MSSQL on Windows: Potential deadlocks exist on all schedulers on Node | This message is raised when the server fails to respond to new queries within a certain time limit. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Potential_deadlocks_exist_on_all_schedulers_on_Node_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Process_Worker_appears_to_be_non_yielding_on_Scheduler_5_Rule](/images/Rule.png) | MSSQL on Windows: Process Worker appears to be non-yielding on Scheduler | This error indicates that there is a possible problem with a thread not yielding on a scheduler. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Process_Worker_appears_to_be_non_yielding_on_Scheduler_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Recovery_of_database__detected_possible_identity_value_inconsistency_in_table_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Recovery of database detected possible identity value inconsistency in table | The database recovery process could not determine the current identity value for the specified table. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Recovery_of_database__detected_possible_identity_value_inconsistency_in_table_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.RESTORE_could_not_start_database_1_5_Rule](/images/Rule.png) | MSSQL on Windows: RESTORE could not start database | Internal structures could not be created during the database RESTORE. This is usually the side effect of another error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.RESTORE_could_not_start_database_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Rule.XTP.BackgroundThreadError](/images/Rule.png) | MSSQL on Windows: XTP Background Thread Error | The rule listens to event 41354 and raises a warning alert if the event is added to the log. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Rule.XTP.BackgroundThreadError | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Rule.XTP.BackgroundThreadErrorLog](/images/Rule.png) | MSSQL on Windows: XTP Background Thread Error Log | The rule listens to event 41355 and raises a warning alert if the event is added to the log. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Rule.XTP.BackgroundThreadErrorLog | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Rule.XTP.CompilerFailure](/images/Rule.png) | MSSQL on Windows: XTP Compiler Failure | The rule listens to event 41313 and raises a warning alert if the event is added to the log. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Rule.XTP.CompilerFailure | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Rule.XTP.InsufficientDiskSpace](/images/Rule.png) | MSSQL on Windows: XTP Insufficient Disk Space | The rule listens to event 41822 and raises a critical alert if the event is added to the log. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Rule.XTP.InsufficientDiskSpace | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Rule.XTP.UnableCallCompiler](/images/Rule.png) | MSSQL on Windows: XTP Unable Call Compiler | The rule listens to event 41312 and raises a warning alert if the event is added to the log. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Rule.XTP.UnableCallCompiler | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Rule.XTP.UnableLoadCompiledDll](/images/Rule.png) | MSSQL on Windows: XTP Unable Load Compiled Dll | The rule listens to event 41309 and raises a warning alert if the event is added to the log. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Rule.XTP.UnableLoadCompiledDll | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.ServiceRestart](/images/Rule.png) | MSSQL on Windows: SQL Server DB Engine is restarted | Detects SQL Server DB Engine restart. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.ServiceRestart | Microsoft.SQLServer.Windows.DBEngine | AvailabilityHealth | False | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Service_Broker_was_not_able_to_allocate_memory_for_cryptographic_operations_5_Rule](/images/Rule.png) | MSSQL on Windows: Service Broker was not able to allocate memory for cryptographic operations | The rule triggers an alert when SQL Server Service Broker is not able to allocate memory for cryptographic operations. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Service_Broker_was_not_able_to_allocate_memory_for_cryptographic_operations_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Assertion_1_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Assertion (17066) | SQL Server has raised an error. Under normal circumstances, SQL Server has posted a dump file in the log directory to help identify the actions that preceded the error. The error may have been caused by data corruption, an error in the client application, an error in SQL Server, network instability, or hardware failure. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Assertion_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Assertion_2_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Assertion (17067) | SQL Server has raised an error. Under normal circumstances, SQL Server has posted a dump file in the log directory to help identify the actions that preceded the error. The error may have been caused by data corruption, an error in the client application, an error in SQL Server, network instability, or hardware failure. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Assertion_2_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Assertion_3_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Assertion (17065) | SQL Server has raised an error. Under normal circumstances, SQL Server has posted a dump file in the log directory to help identify the actions that preceded the error. The error may have been caused by data corruption, an error in the client application, an error in SQL Server, network instability, or hardware failure. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Assertion_3_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_cannot_start_the_Service_Broker_event_handler_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server cannot start the Service Broker event handler | SQL Server Service Broker cannot start the Service Broker event handler. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_cannot_start_the_Service_Broker_event_handler_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_could_not_allocate_enough_memory_to_start_Service_Broker_task_manager_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server could not allocate enough memory to start Service Broker task manager | SQL Server Service Broker cannot start Service Broker task manager. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_could_not_allocate_enough_memory_to_start_Service_Broker_task_manager_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_cannot_use_RC4_encryption_algorithm_when_running_in_FIPS_compliance_mode_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Service Broker cannot use RC4 encryption algorithm when running in FIPS compliance mode | SQL Server Service Broker has a conversation where at least one endpoint has been configured to use RC4 encryption and the server is set for Federal Information Processing Standard (FIPS) compliance mode. RC4 encryption is not supported when running in FIPS compliance mode. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_cannot_use_RC4_encryption_algorithm_when_running_in_FIPS_compliance_mode_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_could_not_query_the_FIPS_compliance_mode_flag_from_the_registry_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Service Broker could not query the FIPS compliance mode flag from the registry | The rule triggers an alert when SQL Server Service Broker could not query the FIPS compliance mode flag from the registry. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_could_not_query_the_FIPS_compliance_mode_flag_from_the_registry_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_Manager_has_shutdown_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Service Broker Manager has shutdown | The rule triggers an alert when the SQL Server Service Broker Manager has shutdown. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_Manager_has_shutdown_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Information | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_or_Database_Mirroring_is_running_in_FIPS_compliance_mode_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Service Broker or Database Mirroring is running in FIPS compliance mode | The rule triggers an alert when SQL Server Service Broker or Database Mirroring is running in FIPS compliance mode. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_or_Database_Mirroring_is_running_in_FIPS_compliance_mode_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Information | Low | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_or_Database_Mirroring_Transport_stopped_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Service Broker or Database Mirroring Transport stopped | The rule triggers an alert when at least one of the endpoints in a SQL Server Service Broker conversation has stopped listening for connections. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_or_Database_Mirroring_Transport_stopped_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | Low | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_or_Database_Mirror_cryptographic_call_failed_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Service Broker or Database Mirror cryptographic call failed | SQL Server Service Broker or Database Mirror attempted to call an operating system cryptographic function. The cryptographic function returned an error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_or_Database_Mirror_cryptographic_call_failed_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_transmitter_shut_down_due_to_an_exception_or_a_lack_of_memory_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Service Broker transmitter shut down due to an exception or a lack of memory | The rule triggers an alert when SQL Server Service Broker transmitter stopped due to an error or a lack of memory. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_Service_Broker_transmitter_shut_down_due_to_an_exception_or_a_lack_of_memory_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_shutdown_due_to_Ctrl_C_or_Ctrl_Break_signal_1_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server shutdown due to Ctrl-C or Ctrl-Break signal | The SQL Server instance was started from a command prompt using sqlservr.exe, and now a Ctrl-C or Ctrl-Break command was issued from that prompt to stop the sqlservr.exe application. No checkpoints were performed during the shutdown. This message is written to the SQL Server error log and the application event log. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_shutdown_due_to_Ctrl_C_or_Ctrl_Break_signal_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_SQL_Server_Service_Broker_attempted_to_use_an_unsupported_encryption_algorithm_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server Service Broker attempted to use an unsupported encryption algorithm | The rule triggers an alert when SQL Server Service Broker tries to use an unsupported encryption algorithm. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_SQL_Server_Service_Broker_attempted_to_use_an_unsupported_encryption_algorithm_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_terminating_because_of_system_shutdown_1_5_Rule](/images/Rule.png) | MSSQL on Windows: SQL Server terminating because of system shutdown | SQL Server is shutting down because the server is shutting down. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.SQL_Server_terminating_because_of_system_shutdown_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Starting_without_recovery_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Starting without recovery | SQL Server is starting without recovery. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Starting_without_recovery_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Allocation_page_has_invalid__page_header_values.__1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Allocation page has invalid page header values. | The page specified has an invalid page header. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Allocation_page_has_invalid__page_header_values.__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__B_tree_chain_linkage_mismatch.__1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: B-tree chain linkage mismatch. | There is a break in the logical page chain at some level in the B-tree specified (this can happen at any level, including the leaf level). A page P_ID2 is pointed to by the next page pointer of page P_ID1, but page P_ID2's previous page pointer points to a different page, P_ID3. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__B_tree_chain_linkage_mismatch.__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__B_tree_level_mismatch_page_does_not_match_level_from_parent__1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: B-tree level mismatch, page does not match level from parent | There are two pages linked as parent (P_ID2) and child (P_ID1) in a B-tree. The level (LEVEL1) in the child page (P_ID1) does not comply with the level rules for B-trees, given the level (LEVEL2) in the parent page (P_ID2). | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__B_tree_level_mismatch_page_does_not_match_level_from_parent__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__B_tree_page_has_two_parent_nodes__1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: B-tree page has two parent nodes | The B-tree structure is corrupt because page P_ID1 is referenced as a child page by slots in two pages higher in the B-tree, P_ID2 and P_ID3. A page can only be referenced by a single parent. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__B_tree_page_has_two_parent_nodes__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Column_is_not_a_valid_complex_column_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Column is not a valid complex column | A column is marked as being a complex column in the record's variable length column section, but it is not a valid text pointer or in-row text root. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Column_is_not_a_valid_complex_column_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__cross_object_chain_linkage_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: cross-object chain linkage | The first phase of a DBCC CHECKDB is to do primitive checks on the data pages of critical system tables. If any errors are found, they cannot be repaired and so the DBCC CHECKDB terminates immediately. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__cross_object_chain_linkage_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Cross_object_linkage._Page_PGID_next_is_not_in_the_same_index_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Cross object linkage. Page PGID->next is not in the same index | Page P_ID is linked to page P_ID2 but the two pages are allocated to different indexes and/or objects. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Cross_object_linkage._Page_PGID_next_is_not_in_the_same_index_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Cross_object_linkage_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Cross object linkage | The page P_ID1 points, in a parent-child manner, to a page (P_ID2) in a different object. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Cross_object_linkage_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Cross_object_linkage__Parent_page_in_object_next_refer_to_page_not_in_the_same_object_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Cross object linkage: Parent page in object next refer to page not in the same object | The next page pointer of page P_ID2 and a child page pointer of page P_ID1 in a B-tree of the specified object points to a page (P_ID3) in a different object. Furthermore, pages P_ID1 and P_ID2 may themselves be in different objects. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Cross_object_linkage__Parent_page_in_object_next_refer_to_page_not_in_the_same_object_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Extent_object_is_beyond_the_range_of_this_database_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Extent object is beyond the range of this database | P_ID is a PageID of the form (filenum:pageinfile). The pageinfile of this extent is greater than the physical size of the file filenum of the database. The extent is marked allocated in an IAM page for the object/index ID indicated. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Extent_object_is_beyond_the_range_of_this_database_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Extra_or_invalid_key_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Extra or invalid key | Every data row in a table (heap or clustered index) must have exactly one matching index row in every non-clustered index over that table. This error means that a non-clustered index has an index row that does not match any data row. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Extra_or_invalid_key_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__IAM_chain_linkage_error_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: IAM chain linkage error | There is a break in the IAM chain for the index specified. A page P_ID2 is pointed to by the next page pointer of page P_ID1, but page P_ID2's previous page pointer points to a different page, P_ID3. Both error states mean the same, and only differ in where the corruption was discovered. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__IAM_chain_linkage_error_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__IAM_page_is_linked_in_the_IAM_chain_for_object_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: IAM page is linked in the IAM chain for object | All IAM pages for an index must have the same index ID on them. In this case, one of the IAM pages linked into the IAM chain for index I_ID2 has index ID I_ID1 on it. There are three possible states of this error; they all mean the same thing, but differ in where the discovery is made. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__IAM_page_is_linked_in_the_IAM_chain_for_object_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Index_node_page_refers_to_child_page_and_previous_child_but_they_were_not_encountered_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Index node page refers to child page and previous child, but they were not encountered | An index page (P_ID1) in a B-tree has child references to two neighboring lower-level pages (P_ID2 and P_ID3), but neither was seen. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Index_node_page_refers_to_child_page_and_previous_child_but_they_were_not_encountered_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Object_index_page_Test_failed._Slot___Offset_is__invalid_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Object, index, page Test failed. Slot - Offset is invalid | The slot specified has an invalid offset (ADDRESS) in the page, according to the slot array. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Object_index_page_Test_failed._Slot___Offset_is__invalid_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Page_allocated_to_object_was_not_seen.__Page_may_be_invalid_or_have_incorrect_object_ID_information_in_its_header_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Page allocated to object was not seen. Page may be invalid or have incorrect object ID information in its header | A page is allocated as specified, but was not seen with that object/index ID in its header. The page has a different index ID in its header, so there will be a matching 2534 (page allocated by another object) error for the page. The 2534 error corresponds to the object/index ID that is in the page's header. | Microsoft.SQLServer.Windows.EventRule.DBEngine.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.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Page_in_its_header_is_allocated_by_another_object_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Page in its header is allocated by another object | A page has the object/index ID specified but is not allocated by any of that index's IAM pages. The page has an incorrect object/index ID in its header, so there will be a matching 2533 (page not seen although allocated) error for the page. The 2533 error corresponds to the index the page is really allocated to. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Page_in_its_header_is_allocated_by_another_object_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Page_is_missing_a_reference_from_previous_page._Possible_chain_linkage_problem_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Page is missing a reference from previous page. Possible chain linkage problem | A page (P_ID2) in a B-tree was not seen, even though its neighbor (P_ID1) in the page chain points to it in its previous page link. This can happen in any level of the B-tree. Both error states mean the same thing; they differ only in where the error is discovered. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Page_is_missing_a_reference_from_previous_page._Possible_chain_linkage_problem_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Page_is_missing_references_from_parent__unknown__and_previous_nodes._Possible_bad_root_entry_in_sysindexes_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Page is missing references from parent (unknown) and previous nodes. Possible bad root entry in sysindexes | Page P_ID1 was seen, but is not linked into the B-tree it thinks it belongs to. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Page_is_missing_references_from_parent__unknown__and_previous_nodes._Possible_bad_root_entry_in_sysindexes_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__page_is_out_of_the_range_of_this_database_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: page is out of the range of this database | The page specified is marked as allocated, but is beyond the in-use portion of the file in which it resides (except in certain states, as described below). | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__page_is_out_of_the_range_of_this_database_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Page_was_not_seen_in_the_scan_although_its_parent_and_previous_refer_to_it._Check_any_previous_errors_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Page was not seen in the scan although its parent and previous refer to it. Check any previous errors | A page (P_ID1) in a B-tree was not seen, even though an index page (P_ID2) points to it as a child page and its previous page (P_ID3) in the page chain points to it as the next page in the chain. This can happen at any level of the B-tree. Both error states mean the same thing; they differ only in where the error was discovered. | Microsoft.SQLServer.Windows.EventRule.DBEngine.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.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Parent_node_for_page_was_not_encountered_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Parent node for page was not encountered | Page P_ID was seen in a B-tree, and is linked into the B-tree level it is at. However, no index page was seen that had a reference to the page as a child page. This can happen at any level of the B-tree. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Parent_node_for_page_was_not_encountered_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Slot_row_extends_into_free_space__1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Slot, row extends into free space | The end of the slot S_ID is past the persisted free space offset, ADDRESS. TEST is 'max <= m_freeData', where the persisted free space offset if 'm_freeData' and the end of slot S_ID is 'max'. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Slot_row_extends_into_free_space__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Table_missing_or_invalid_key_in_index_for_the_row__1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Table missing or invalid key in index for the row: | Every data row in a table (heap or clustered index) must have exactly one matching index row in every non-clustered index over that table. This error means that a non-clustered index is missing an index row. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Table_missing_or_invalid_key_in_index_for_the_row__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__The_high_key_value_on_page_is_not_less_than_the_low_key_value_in_the_parent_slot_of_the_next_page_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: The high key value on page is not less than the low-key value in the parent, slot of the next page | A B-tree tree-level page contains a record for each child page, along with a key value for that child page. If the child page is a leaf-level page, all records on the page must have key values greater than or equal to the key value in the parent page. If the child page is a tree-level page, all records must have key values greater than the key value in the parent, except the first record, which must have a key value that exactly matches that in the parent. | Microsoft.SQLServer.Windows.EventRule.DBEngine.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.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__The_low_key_value_on_page__is_not_the_key_value_in_the_parent_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: The low-key value on page is not the key value in the parent | A B-tree tree level page contains a record for each child page, along with a key value for that child page. If the child page is a leaf-level page (that is, level 0), all records on the page must have key values greater than or equal to the key value in the parent page. If the child page is a tree-level page (that is, level > 0), all records must have key values greater than the key value in the parent, except the first record, which must have a key value that exactly matches that in the parent. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__The_low_key_value_on_page__is_not_the_key_value_in_the_parent_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__The_previous_link_on_page_does_not_match_the_previous_page_that_the_parent_slot_expects_for_this_page_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: The previous link on page does not match the previous page that the parent, slot expects for this page | A B-tree is structured so that pages at a single level point to each other, in a doubly linked list. In addition, the pages' parent in the B-tree has a record for each of its children with their keys and page IDs. | Microsoft.SQLServer.Windows.EventRule.DBEngine.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.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__The_text_ntext_or_image_node_at_page_is_not_referenced_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: The text, ntext, or image node at page is not referenced | The text node was not referenced in any complex column in any heap or clustered index. It is effectively orphaned. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__The_text_ntext_or_image_node_at_page_is_not_referenced_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__The_text_ntext_or_image_node_at_page__is_referenced_by_page_not_seen_in_the_scan_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: The text, ntext, or image node at page is referenced by page not seen in the scan | The text node was not referenced in any complex column in any heap or clustered index. It is effectively orphaned. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__The_text_ntext_or_image_node_at_page__is_referenced_by_page_not_seen_in_the_scan_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__The_text_ntext_or_image_node_has_wrong_type_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: The text, ntext, or image node has wrong type | The text node is on the wrong text page type. If the parent (owner) of the node can be found, there will be an accompanying 8929 message providing details about the owner. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__The_text_ntext_or_image_node_has_wrong_type_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Wrong_PageId_in_the_page_header_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Wrong PageId in the page header | DBCC asked for page P_ID1. When the page was read from disk, the page ID in its header was found to be P_ID2. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error__Wrong_PageId_in_the_page_header_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error___Address_is_not_aligned_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Address is not aligned | The structure at address ADDRESS is not 4-byte aligned. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error___Address_is_not_aligned_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error___Test_failed._Slot_overlaps_with_the_prior_row_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Test failed. Slot overlaps with the prior row | Slot S_ID's offset in the slot offset array is not greater than or equal to the end of the previous slot, so they overlap. TEST is 'sorted [i].offset >= max', where the lhs of the expression is the ADDRESS, and 'max' is the end of the previous slot. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error___Test_failed._Slot_overlaps_with_the_prior_row_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error___The_next_pointer_of_refers_to_page._Neither_its_parent_were_encountered._Possible_bad_chain_linkage_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: The next pointer of refers to page. Neither its parent were encountered. Possible bad chain linkage | A page (P_ID1) references its next page in the page chain (P_ID2), but page P_ID2 was not seen and was not referenced by any parent page in the B-tree. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error___The_next_pointer_of_refers_to_page._Neither_its_parent_were_encountered._Possible_bad_chain_linkage_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error___Unexpected_page_type__1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table error: Unexpected page type | Page P_ID had a page type that was unexpected by the code trying to interpret it. The page is marked allocated, however, which is why the DBCC code is trying to interpret it. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table_error___Unexpected_page_type__1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table__Creating_statistics_for_the_following_columns_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table: Creating statistics for the following columns | sp_createstats has generated statistics for each eligible column in the current database. Computed columns and columns of the ntext, text, or image data types cannot be specified as statistics columns. Columns already having statistics are not touched (for example, the first column of an index or a column with explicitly created statistics). Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table__Creating_statistics_for_the_following_columns_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Table___No_columns_without_statistics_found_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Table: No columns without statistics found | There are no eligible columns in the current database on which to create statistics using sp_createstats . Computed columns and columns of the ntext, text, or image data types cannot be specified as statistics columns. Columns already having statistics are not touched (for example, the first column of an index or a column with explicitly created statistics). | Microsoft.SQLServer.Windows.EventRule.DBEngine.Table___No_columns_without_statistics_found_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_IO_operation_was_successful_after_retry_id825](/images/Rule.png) | MSSQL on Windows: The I/O operation was successful after retry | A read operation on a database page or transaction log block was successful but only after retrying the operation. While you may not need to take immediate action, you should research the cause of the error. | Microsoft.SQLServer.Windows.EventRule.DBEngine.The_IO_operation_was_successful_after_retry_id825 | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_log_for_database_is_not_available_1_5_Rule](/images/Rule.png) | MSSQL on Windows: The log for database is not available | An I/O error related to data integrity has occurred for the specified database. Either the log or data portion of the database could be damaged. SQL Server has made the log for that database unavailable to prevent further data integrity problems. The I/O error that led to the 9001 message should be reported in the SQL Server error log and/or the Windows event logs. | Microsoft.SQLServer.Windows.EventRule.DBEngine.The_log_for_database_is_not_available_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_LSN_passed_to_log_scan_in_database_is_invalid_5_Rule](/images/Rule.png) | MSSQL on Windows: The LSN passed to log scan in database is invalid | If you see this message during startup when the SQL Server process tries to recover the database or as a result of an ATTACH statement, the log file for the database is corrupted. If you see the message during a restore process, the backup file is corrupted. If you see this message during a replication process, the replication metadata may be incorrect. | Microsoft.SQLServer.Windows.EventRule.DBEngine.The_LSN_passed_to_log_scan_in_database_is_invalid_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_MSSQLServer_service_terminated_unexpectedly_3_5_Rule](/images/Rule.png) | MSSQL on Windows: The MSSQLServer service terminated unexpectedly | The error is reported by the SQL Server Agent service when it auto restarts SQL Server. SQL Server Agent will only auto restart SQL Server if SQL Server stopped for some reason other than an explicit stop command from a user or application, and if the “Auto restart SQL Server if it stops unexpectedly” option is selected in SQL Server Agent Advanced properties. During the restart of SQL Server, SQL Server Agent will write this message to the application event log on the computer hosting SQL Server. | Microsoft.SQLServer.Windows.EventRule.DBEngine.The_MSSQLServer_service_terminated_unexpectedly_3_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_provider_reported_an_unexpected_catastrophic_failure_1_5_Rule](/images/Rule.png) | MSSQL on Windows: The provider reported an unexpected catastrophic failure | The provider reported an unexpected catastrophic failure. | Microsoft.SQLServer.Windows.EventRule.DBEngine.The_provider_reported_an_unexpected_catastrophic_failure_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_query_has_been_canceled_because_the_estimated_cost_of_this_query_exceeds_the_configured_threshold._Contact_the_system_administrator_1_5_Rule](/images/Rule.png) | MSSQL on Windows: The query has been canceled because the estimated cost of this query exceeds the configured threshold. Contact the system administrator | The configuration setting for the query governor cost limit option is lower than the cost the SQL Server optimizer estimated for the specified query. By default, the query governor cost limit option is set to 0, which allows all queries to run. However, on this instance of SQL Server an upper limit was specified by setting the option to a number greater than 0. Query plans with an anticipated cost larger than this value are not started. | Microsoft.SQLServer.Windows.EventRule.DBEngine.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.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_query_processor_could_not_start_the_necessary_thread_resources_for_parallel_query_execution_1_5_Rule](/images/Rule.png) | MSSQL on Windows: The query processor could not start the necessary thread resources for parallel query execution | Thread resources are scarce in the server. | Microsoft.SQLServer.Windows.EventRule.DBEngine.The_query_processor_could_not_start_the_necessary_thread_resources_for_parallel_query_execution_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_server_is_too_busy_to_perform_the_backup_or_restore_operation_1_5_Rule](/images/Rule.png) | MSSQL on Windows: The server is too busy to perform the backup or restore operation | Failed to start a sub-process (a parallel query or parallel I/O) because no threads are available or too many sub-processes executing. | Microsoft.SQLServer.Windows.EventRule.DBEngine.The_server_is_too_busy_to_perform_the_backup_or_restore_operation_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_Service_Broker_Database_Mirroring_transport_cannot_listen_on_port_because_it_is_in_use_5_Rule](/images/Rule.png) | MSSQL on Windows: The Service Broker/Database Mirroring transport cannot listen on port because it is in use | When you create a Service Broker or Database Mirroring endpoint, SQL Server should be able to accept TCP/IP connections on the port that is specified in the endpoint configuration. The transport security requires authorization for connections to the port. If the server has a firewall enabled, the firewall configuration must allow both incoming and outgoing connections for the port that is used by the endpoint. | Microsoft.SQLServer.Windows.EventRule.DBEngine.The_Service_Broker_Database_Mirroring_transport_cannot_listen_on_port_because_it_is_in_use_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_Service_Broker_Database_Mirroring_Transport_could_not_listen_for_connections_due_to_an_error_5_Rule](/images/Rule.png) | MSSQL on Windows: The Service Broker/Database Mirroring Transport could not listen for connections due to an error | The rule triggers an alert when Service Broker cannot listen on the specified port. | Microsoft.SQLServer.Windows.EventRule.DBEngine.The_Service_Broker_Database_Mirroring_Transport_could_not_listen_for_connections_due_to_an_error_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_Service_Broker_or_Database_Mirroring_Transport_has_started_5_Rule](/images/Rule.png) | MSSQL on Windows: The Service Broker or Database Mirroring Transport has started | SQL Server Service Broker or Database Mirroring transport has started. The Windows application log specifies whether the error was recorded by Service Broker or Database Mirroring the application name. This message is logged in the Windows application log as MSSQLSERVER event ID 9690. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.The_Service_Broker_or_Database_Mirroring_Transport_has_started_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Information | Low | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_SQL_Server_Service_Broker_or_Database_Mirroring_transport_is_disabled_or_not_configured_5_Rule](/images/Rule.png) | MSSQL on Windows: The SQL Server Service Broker or Database Mirroring transport is disabled or not configured | The rule triggers an alert when the SQL Server Service Broker or Database Mirroring transport is disabled or not configured. Note: This rule is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Windows.EventRule.DBEngine.The_SQL_Server_Service_Broker_or_Database_Mirroring_transport_is_disabled_or_not_configured_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | False | | | 0 | 0 | | True | Error | High | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.The_user_is_not_allowed_to_truncate_the_system_table_1_5_Rule](/images/Rule.png) | MSSQL on Windows: The user is not allowed to truncate the system table | The TRUNCATE TABLE statement cannot be issued for a system table, even if the allow updates configuration option is enabled. | Microsoft.SQLServer.Windows.EventRule.DBEngine.The_user_is_not_allowed_to_truncate_the_system_table_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Transaction_was_deadlocked_on_resources_with_another_process_and_has_been_chosen_as_the_deadlock_victim._Rerun_the_transaction_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Transaction was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction | This error occurs when Microsoft SQL Server encounters a deadlock. A deadlock occurs when two (or more) processes attempt to access a resource that the other process holds a lock on. Because each process has a request for another resource, neither process can be completed. When a deadlock is detected, SQL Server rolls back the command that has the least processing time and returns error message 1205 to the client application. This error is not fatal and may not cause the batch to be terminated. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Transaction_was_deadlocked_on_resources_with_another_process_and_has_been_chosen_as_the_deadlock_victim._Rerun_the_transaction_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Unexpected_end_of_file_while_reading_beginning_of_backup_set_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Unexpected end of file while reading beginning of backup set | The RESTORE operation failed because it could not read some portion of the backup file specified in the FROM clause. This error generally indicates that the file specified is a pre-SQL Server 7.0 backup or that the file is damaged. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Unexpected_end_of_file_while_reading_beginning_of_backup_set_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.Unique_table_computation_failed_1_5_Rule](/images/Rule.png) | MSSQL on Windows: Unique table computation failed | Unique tables are used by the database client drivers, like Microsoft Access driver for SQL Server, to build updateable queries. For a given SELECT statement, the unique table identifies the table whose row values appear at most once in the result set. When reselecting a row from a result set, the values from the key columns of the unique table are enough to identify the row. This error is raised when the server is unable to compute the unique table. | Microsoft.SQLServer.Windows.EventRule.DBEngine.Unique_table_computation_failed_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___Failed_to_instantiate_class._Make_sure_Msxml2.dll_exists_in_the_SQL_Server_installation_1_5_Rule](/images/Rule.png) | MSSQL on Windows: XML: Failed to instantiate class. Make sure Msxml2.dll exists in the SQL Server installation | The Msxml2.dll file is missing from the computer where SQL Server is installed, or it could not be loaded from the system directory while processing an XML feature such as sp_xml_preparedocument. If the file exists, it may not be registered properly, or one of its dependencies may not exist. | Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___Failed_to_instantiate_class._Make_sure_Msxml2.dll_exists_in_the_SQL_Server_installation_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___Failed_to_load_Msxml2.dll_1_5_Rule](/images/Rule.png) | MSSQL on Windows: XML: Failed to load Msxml2.dll | The Msxml2.dll file is missing from the computer where SQL Server is installed, or it could not be loaded from the system directory while processing an XML feature such as sp_xml_preparedocument. If the file exists, it may not be registered properly, or one of its dependencies may not exist. | Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___Failed_to_load_Msxml2.dll_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___FOR_XML_EXPLICIT_stack_overflow_occurred._Circular_parent_tag_relationships_are_not_allowed_1_5_Rule](/images/Rule.png) | MSSQL on Windows: XML: FOR XML EXPLICIT stack overflow occurred. Circular parent tag relationships are not allowed | The XML is not well-formed because the element tag nesting level has exceeded the number of columns in the table, one or more tags is self-referencing, or both. For more information about FOR XML EXPLICIT, see "Using EXPLICIT Mode" in Books Online. | Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___FOR_XML_EXPLICIT_stack_overflow_occurred._Circular_parent_tag_relationships_are_not_allowed_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___Size_of_data_chunk_requested_from_the_stream_exceeds_allowed_limit_5_Rule](/images/Rule.png) | MSSQL on Windows: XML: Size of data chunk requested from the stream exceeds allowed limit | SQL Server received an XML document that exceeds the allowed limit. | Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___Size_of_data_chunk_requested_from_the_stream_exceeds_allowed_limit_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___XML_document_could_not_be_created_because_server_memory_is_low._Use_sp_xml_removedocument_to_release_XML_documents_1_5_Rule](/images/Rule.png) | MSSQL on Windows: XML: XML document could not be created because server memory is low. Use sp_xml_removedocument to release XML documents | When you execute sp_xml_preparedocument , a parsed XML document is stored in the internal cache of SQL Server 2000. The MSXML parser uses up to one-eighth the total memory available for SQL Server. There is not enough memory in the portion of cache allocated to MSXML to open the document specified in the sp_xml_preparedocument statement. This may be because the specified document is very large or because documents already in that memory space do not leave enough space for the new document. | Microsoft.SQLServer.Windows.EventRule.DBEngine.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.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___XML_error_1_5_Rule](/images/Rule.png) | MSSQL on Windows: XML: XML error | This message passes through XML errors generated outside of SQL Server. The text after "XML error:" will vary. The cause will depend on the exact XML error passed through. | Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___XML_error_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Warning | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___XML_parsing_error_1_5_Rule](/images/Rule.png) | MSSQL on Windows: XML: XML parsing error | This message passes through XML parsing errors. The text after "XML parsing error:" will vary. The cause will depend on the exact XML parsing error passed through. | Microsoft.SQLServer.Windows.EventRule.DBEngine.XML___XML_parsing_error_1_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.EventRule.DBEngine._.NET_Framework_runtime_was_shut_down_by_user_code_5_Rule](/images/Rule.png) | MSSQL on Windows: .NET Framework runtime was shut down by user code | The rule triggers an alert when a user defined type, user defined-function, or user-defined property in an assembly contains faulty code. | Microsoft.SQLServer.Windows.EventRule.DBEngine._.NET_Framework_runtime_was_shut_down_by_user_code_5_Rule | Microsoft.SQLServer.Windows.DBEngine | EventCollection | True | | | 0 | 0 | | True | Error | Normal | True | |
![Microsoft.SQLServer.Windows.Rule.MonitoringPoolAlertCollection.MonitoringError](/images/Rule.png) | MSSQL on Windows: Monitoring error | The rule traces monitoring workflows errors and generates error alerts. | Microsoft.SQLServer.Windows.Rule.MonitoringPoolAlertCollection.MonitoringError | Microsoft.SQLServer.Windows.MonitoringPoolAlertCollection | Alert | True | | | 0 | 0 | | True | Error | Normal | True | Operations Manager |
![Microsoft.SQLServer.Windows.Rule.MonitoringPoolAlertCollection.MonitoringWarning](/images/Rule.png) | MSSQL on Windows: Monitoring warning | The rule traces monitoring workflows warnings and generates warning alerts. | Microsoft.SQLServer.Windows.Rule.MonitoringPoolAlertCollection.MonitoringWarning | Microsoft.SQLServer.Windows.MonitoringPoolAlertCollection | Alert | True | | | 0 | 0 | | True | Warning | Normal | True | Operations Manager |