SQL Replication 14151 alerting rule

Microsoft.Amalga.UIS.2009.Monitoring.SQL.Replication.14151.Alerting.Rule (Rule)

Raise an alert when SQL Server replication 14151 events occur. This event is not currently captured by SQL Server management packs and has impact on Amalga deployments.

Knowledge Base article:

Summary

This rule generates an alert whenever a SQL replication issue (event id 14151) is detected. Replication issues can cause significant performance issues and other data integrity problems for Amalga deployments and should be addressed immediately for production environments.

Resolutions

For more information and resolution refer to the following link:

http://msdn.microsoft.com/en-us/library/ms151194(SQL.90).aspx

Element properties:

Target

Microsoft.SQLServer.DBEngine

Category

Alert

Enabled

True

Event_ID

14151

Event Source

MSSQLSERVER

Alert Generate

True

Alert Severity

Error

Alert Priority

High

Remotable

True

Alert Message

SQL Server replication error detected (event id 14151)

Immediate attention required. Data mismatch on all replicated servers for this db engine was detected. Event Description: {0} Replication Working Directory: {1}

Event Log

Application

Member Modules:

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

Source Code:

<Rule ID="Microsoft.Amalga.UIS.2009.Monitoring.SQL.Replication.14151.Alerting.Rule" Enabled="onEssentialMonitoring" Target="MicrosoftSQLServerLibrary!Microsoft.SQLServer.DBEngine" ConfirmDelivery="true" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>Alert</Category>

  <DataSources>

    <DataSource ID="DS" 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 Type="UnsignedInteger">EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value Type="UnsignedInteger">14151</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="String">PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value Type="String">MSSQLSERVER</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

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

      <Priority>2</Priority>

      <Severity>2</Severity>

      <AlertOwner/>

      <AlertMessageId>$MPElement[Name="Microsoft.Amalga.UIS.2009.Monitoring.SQL.Replication.14151.Alerting.Rule.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

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

        <AlertParameter2>$Target/Property[Type="MicrosoftSQLServerLibrary!Microsoft.SQLServer.DBEngine"]/ReplicationWorkingDirectory$</AlertParameter2>

      </AlertParameters>

      <Suppression>

        <SuppressionValue>$Data/EventDisplayNumber$</SuppressionValue>

        <SuppressionValue>$Data/PublisherName$</SuppressionValue>

        <SuppressionValue>$Data/LoggingComputer$</SuppressionValue>

        <SuppressionValue>$Data/EventDescription$</SuppressionValue>

      </Suppression>

      <Custom1/>

      <Custom2/>

      <Custom3/>

      <Custom4/>

      <Custom5/>

      <Custom6/>

      <Custom7/>

      <Custom8/>

      <Custom9/>

      <Custom10/>

    </WriteAction>

  </WriteActions>

</Rule>