SQL Server Database Error

Microsoft.Windows.SharePoint.Services.3.0.SQL_Server_Database_Error.ServiceHealth (UnitMonitor)

SQL Server Database Error State monitor monitors the error event of SQL Server Database.

Knowledge Base article:

Summary

In a search-enabled server farm, the search server periodically writes to or reads from the SQL Server database. This alert indicates that an unexpected SQL Server database error occurred while the Windows SharePoint Services Search (SPSearch) attempted to communicate with the database.

Causes

Possible causes include:

Connectivity problems between a server in the server farm running the Windows SharePoint Services Search (SPSearch) service and the computer that is running SQL Server.
Disk on which the database is stored is full.
The SQL Server database connection is timing out.
Service account used to communicate with the SQL Server database has inadequate permissions.

Resolutions

Verify connectivity between the search server in the server farm running the Windows SharePoint Services Search (SPSearch) service and the SQL Server computer
Verify that the disk on which the configuration database is stored on the SQL Server computer is not full.
Profile your SQL usage and take steps to resolve SQL Server connection time-out issues.
Verify that the service account used by the Windows SharePoint Services Search (SPSearch) service has adequate permissions to communicate with the SQL Server database.

Element properties:

Target

Microsoft.Windows.SharePoint.Services.3.0.WSS.Server

Parent Monitor

Microsoft.Windows.SharePoint.Services.3.0.SQL_Server_Database_Error.Monitor

Category

StateCollection

Enabled

True

Alert Generate

True

Alert Severity

Warning

Alert Priority

Normal

Alert Auto Resolve

True

Monitor Type

Microsoft.Windows.RepeatedEventLogManualReset2StateMonitorType

Remotable

True

Accessibility

Public

Alert Message

SQL Server Database Error

SQL Server Database Error raised from the client computer {0}.

RunAs

Default

Source Code:

<UnitMonitor ID="Microsoft.Windows.SharePoint.Services.3.0.SQL_Server_Database_Error.ServiceHealth" Accessibility="Public" Enabled="onEssentialMonitoring" Target="Microsoft.Windows.SharePoint.Services.3.0.WSS.Server" ParentMonitorID="Microsoft.Windows.SharePoint.Services.3.0.SQL_Server_Database_Error.Monitor" Remotable="true" Priority="Normal" TypeID="MSWL!Microsoft.Windows.RepeatedEventLogManualReset2StateMonitorType" ConfirmDelivery="false">

  <Category>StateCollection</Category>

  <AlertSettings AlertMessage="Microsoft.Windows.SharePoint.Services.3.0.SQL_Server_Database_Error.ServiceHealth.StringResource">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Warning</AlertSeverity>

    <AlertParameters>

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

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="RepeatedEvent" MonitorTypeStateID="RepeatedEventRaised" HealthState="Warning"/>

    <OperationalState ID="ManualResetEvent" MonitorTypeStateID="ManualResetEventRaised" HealthState="Success"/>

  </OperationalStates>

  <Configuration>

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

    <RepeatedLogName>Application</RepeatedLogName>

    <RepeatedExpression>

      <And>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value>9511</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value>Windows SharePoint Services 3 Search</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </RepeatedExpression>

    <Consolidator>

      <ConsolidationProperties/>

      <TimeControl>

        <WithinTimeSchedule>

          <Interval>300</Interval>

        </WithinTimeSchedule>

      </TimeControl>

      <CountingCondition>

        <Count>25</Count>

        <CountMode>OnNewItemTestOutputRestart_OnTimerRestart</CountMode>

      </CountingCondition>

    </Consolidator>

  </Configuration>

</UnitMonitor>