Home
  •  

[Deprecated] Disk Free Space

Microsoft.SQLServer.2008.DBFile.DiskFreeSpace (UnitMonitor)

Monitors the free space percentage left on a disk drive.

Knowledge Base article:

Summary

Monitors the free space percentage left on a disk drive.

Causes

Unhealthy state is caused by the disk having low free space in percentage terms. This can be caused by:

Resolutions

This issue may be resolved by either:

See SQL Server Books Online: Files and Filegroups Architecture

Overrideable Parameters

Name

Description

Default Value

Alert Priority

Defines Alert Priority.

Normal

Alert Severity

Defines Alert Severity.

Error

Enabled

Enables or disables the workflow.

No

Frequency (seconds)

The recurring interval of time in seconds in which to run the workflow.

3600

Generates Alerts

Defines whether the workflow generates an Alert.

Yes

Threshold

The collected value will be compared against this parameter.

5

Element properties:

TargetMicrosoft.SQLServer.2008.DBFile
Parent MonitorSystem.Health.PerformanceState
CategoryPerformanceHealth
EnabledFalse
Instance NameLogicalDisk
Counter Name\% Free Space
Frequency3600
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeSystem.Performance.ThresholdMonitorType
RemotableTrue
AccessibilityPublic
Alert Message
Disk Space Is Getting Low
The "{0}" drive is running out of disk space. See “alert context” tab for more details.
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.2008.DBFile.DiskFreeSpace" Accessibility="Public" Enabled="false" Target="SQL2008Core!Microsoft.SQLServer.2008.DBFile" ParentMonitorID="SystemHealth!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="SystemPerf!System.Performance.ThresholdMonitorType" ConfirmDelivery="false">

  <Category>PerformanceHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServer.2008.DBFile.DiskFreeSpace.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type="SQL!Microsoft.SQLServer.DBFile"]/Drive$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

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

    <CounterName>% Free Space</CounterName>

    <ObjectName>LogicalDisk</ObjectName>

    <InstanceName>$Target/Property[Type="SQL!Microsoft.SQLServer.DBFile"]/Drive$</InstanceName>

    <Frequency>3600</Frequency>

    <Threshold>5</Threshold>

  </Configuration>

</UnitMonitor>