Home
  •  

MSSQL 2014: SQL Server Service Broker or Database Mirroring Transport stopped

Microsoft.SQLServer.2014.SQL_Server_Service_Broker_or_Database_Mirroring_Transport_stopped_5_Rule (Rule)

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.

Knowledge Base article:

Summary

This message indicates that at least one of the endpoints in a SQL Server Service Broker conversation has stopped listening for connections. The Windows application log will specify whether the error was logged by Service Broker or Database Mirroring. This message is logged in the Windows application log MSSQLSERVER event ID 9691.

Resolutions

This message is informational. There is no action required.

If this rule is not a concern for the database:

Overrideable Parameters

Name

Description

Default Value

Enabled

 

No

Generates Alerts

 

Yes

Priority

 

0

Severity

 

2

Element properties:

TargetMicrosoft.SQLServer.2014.DBEngine
CategoryEventCollection
EnabledFalse
Event_ID9691
Event Source$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/ServiceName$
Alert GenerateTrue
Alert SeverityError
Alert PriorityLow
RemotableTrue
Alert Message
MSSQL 2014: SQL Server Service Broker or Database Mirroring Transport stopped
{0}
Event LogApplication
CommentMom2014ID='{0A86AB27-41E2-49E1-B6DA-A2F71B2AA239}';MOM2014GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}

Member Modules:

ID Module Type TypeId RunAs 
_F6DA1507_12AF_11D3_AB21_00A0C98620CE_ DataSource Microsoft.Windows.EventProvider Default
GenerateAlert WriteAction System.Health.GenerateAlert Default

Source Code:

<Rule ID="Microsoft.SQLServer.2014.SQL_Server_Service_Broker_or_Database_Mirroring_Transport_stopped_5_Rule" Target="SQL2014Core!Microsoft.SQLServer.2014.DBEngine" Enabled="false" ConfirmDelivery="true" Remotable="true" Comment="Mom2014ID='{0A86AB27-41E2-49E1-B6DA-A2F71B2AA239}';MOM2014GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_F6DA1507_12AF_11D3_AB21_00A0C98620CE_" Comment="{F6DA1507-12AF-11D3-AB21-00A0C98620CE}" TypeID="Windows!Microsoft.Windows.EventProvider">

      <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <LogName>Application</LogName>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>9691</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/ServiceName$</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="SystemHealth!System.Health.GenerateAlert">

      <Priority>0</Priority>

      <Severity>2</Severity>

      <AlertMessageId>$MPElement[Name="Microsoft.SQLServer.2014.SQL_Server_Service_Broker_or_Database_Mirroring_Transport_stopped_5_Rule.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/EventDescription$</AlertParameter1>

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>