Percentage Change in DB \% Used Space

Microsoft.SQLServer.2008.Database.DBSizePercentageChangeMonitor (UnitMonitor)

Monitors for a large change in value of DB used space over a set number of sample periods. A rapid large change in value could indicate a problem

Knowledge Base article:

Summary

SQL 2008 DB Size change monitor. Monitors for a large change in value of DB used space over a set number of sample periods. A rapid large change in value could indicate a problem

Configuration

Frequency (sec) default 900.
NumSamples default 5 – Number of samples where the threshold has to be exceeded before an alert is raised.
Threshold1 default 25. Percentage of change for warning.
Threshold2 default 45. Percentage of change for error.

Element properties:

Target

Microsoft.SQLServer.2008.Database

Parent Monitor

System.Health.PerformanceState

Category

PerformanceHealth

Enabled

True

Alert Generate

True

Alert Severity

MatchMonitorHealth

Alert Priority

Normal

Alert Auto Resolve

True

Monitor Type

Microsoft.SQLServer.2008.DBPercentageChange

Remotable

True

Accessibility

Public

Alert Message

Percentage Change in DB \% Used Space

The database {2} in SQL instance {1} on computer {0} has experienced a significant change in free space

RunAs

Default

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.2008.Database.DBSizePercentageChangeMonitor" Accessibility="Public" Enabled="true" Target="SQL2008Core!Microsoft.SQLServer.2008.Database" ParentMonitorID="SystemHealth!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.2008.DBPercentageChange" ConfirmDelivery="false">

  <Category>PerformanceHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServer.2008.Database.DBSizePercentageChangeMonitor.AlertMessage">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

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

      <AlertParameter2>$Target/Host/Property[Type="SQL!Microsoft.SQLServer.ServerRole"]/InstanceName$</AlertParameter2>

      <AlertParameter3>$Target/Property[Type="SQL!Microsoft.SQLServer.Database"]/DatabaseName$</AlertParameter3>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="UnderThreshold1" MonitorTypeStateID="UnderThreshold1" HealthState="Success"/>

    <OperationalState ID="OverThreshold1UnderThreshold2" MonitorTypeStateID="OverThreshold1UnderThreshold2" HealthState="Warning"/>

    <OperationalState ID="OverThreshold2" MonitorTypeStateID="OverThreshold2" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <IntervalSeconds>900</IntervalSeconds>

    <SyncTime/>

    <ConnectionString>$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ConnectionString$</ConnectionString>

    <ObjectName>$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:Database</ObjectName>

    <CounterName>DB Free Space (%)</CounterName>

    <InstanceName>$Data/Property[@Name='Database']$</InstanceName>

    <DatabaseName>$Target/Property[Type="SQL!Microsoft.SQLServer.Database"]/DatabaseName$</DatabaseName>

    <Value>$Data/Property[@Name='DBPercentFree']$</Value>

    <Threshold1>25</Threshold1>

    <Threshold2>45</Threshold2>

    <NumSamples>5</NumSamples>

    <TimeoutSeconds>300</TimeoutSeconds>

  </Configuration>

</UnitMonitor>