ConfigMgr 2007 Component Health: SMS_DATABASE_NOTIFICATION_MONITOR state

SMSv4_Component_Health__SMS_DATABASE_NOTIFICATION_MONITOR_state_18_Rule (Rule)

Knowledge Base article:

Summary

SMS_SITE_VSS_WRITER is currently unhealthy.

Causes

The component is not responding. A heartbeat has not been received from the Configuration Manager SQL monitor component (SMS_SITE_VSS_WRITER) within its expected interval. This can be caused by high system processing loads and Configuration Manager processing loads, an extended wait on a request, or a deadlock on a shared resource.

Element properties:

Target	Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Primary_Site_Servers_Installation
Category	EventCollection
Enabled	True
Alert Generate	False
Remotable	True
Comment	Mom2005ID='{93C53C6C-A6CF-4EFC-AE69-2D495B5DBC1F}';MOM2005ComputerGroupID={CF9E6682-BEB2-48CA-A0A1-97A71472BD72}

Member Modules:

ID	Module Type	TypeId	RunAs
_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_	DataSource	System.Mom.BackwardCompatibility.FilteredEvent.DataProvider	Default
GenerateAlert	WriteAction	System.Mom.BackwardCompatibility.AlertResponse.WithServerRole	Default

Source Code:

<Rule ID="SMSv4_Component_Health__SMS_DATABASE_NOTIFICATION_MONITOR_state_18_Rule" Target="Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Primary_Site_Servers_Installation" Enabled="true" ConfirmDelivery="false" Comment="Mom2005ID='{93C53C6C-A6CF-4EFC-AE69-2D495B5DBC1F}';MOM2005ComputerGroupID={CF9E6682-BEB2-48CA-A0A1-97A71472BD72}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_" Comment="{F320DA51-13BF-11D3-B2CD-00A0C92A28B4}" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.FilteredEvent.DataProvider">

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="Integer">EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>1730</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

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

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>ConfigMgr 2007 Monitor Component Health</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="String">Params/Param[1]</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>SMS_DATABASE_NOTIFICATION_MONITOR</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="System.Mom.BackwardCompatibility.AlertResponse.WithServerRole">

      <GenerateAlert>true</GenerateAlert>

      <Owner/>

      <Description>

            $Data/LoggingComputer$

           - ConfigMgr 2007 Component Health: SMS_DATABASE_NOTIFICATION_MONITOR state.  

            $Data/EventDescription$

          </Description>

      <AlertLevel>50</AlertLevel>

      <ResolutionState/>

      <Source>

            $Data/PublisherName$

          </Source>

      <Name>ConfigMgr 2007 Component Health: SMS_DATABASE_NOTIFICATION_MONITOR state</Name>

      <ServerRole>SMS Server</ServerRole>

      <ServerRoleInstance>$Target/Host/Property[Type="WindowsLibrary!Microsoft.Windows.Computer"]/NetbiosComputerName$</ServerRoleInstance>

      <Component>SS</Component>

      <ProblemState>1</ProblemState>

      <InvokerType>0</InvokerType>

    </WriteAction>

  </WriteActions>

</Rule>