Home
  •  

SQL Server Database Space

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

SQL Server Database Space State monitor monitors the error event of SQL Server Database is full.

Knowledge Base article:

Summary

When a SQL Server database is created, a value for the maximum database size is set. Each database has a separate database size setting. Note that a Web application may be associated with one or many databases.

Causes

A SQL Server error occurred because the database size limit has been reached.

Resolutions

© 2000-2007 Microsoft Corporation, all rights reserved.

Element properties:

TargetMicrosoft.Windows.SharePoint.Services.3.0.WSS.Server
Parent MonitorMicrosoft.Windows.SharePoint.Services.3.0.SQL_Server_database_is_full.Monitor
CategoryStateCollection
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.Windows.SingleEventLogManualReset2StateMonitorType
RemotableTrue
AccessibilityPublic
Alert Message
SQL Server Database Space
SQL Server Database Space error raised from the client computer {0}.
RunAsDefault

Source Code:

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

  <Category>StateCollection</Category>

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

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

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

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Event" MonitorTypeStateID="EventRaised" HealthState="Error"/>

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

  </OperationalStates>

  <Configuration>

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

    <LogName>Application</LogName>

    <Expression>

      <And>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value>3758</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value>Windows SharePoint Services 3</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </Expression>

  </Configuration>

</UnitMonitor>