Default Storage Free Space

Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Instance.FreeSpace (UnitMonitor)

The monitor reports a warning when the available free space for the default storage for the instance drops below the Warning Threshold setting, expressed as percentage of the sum of estimated default storage folder (DataDir) size and disk free space. The monitor reports a critical alert when the available space drops below the Critical Threshold. The monitor does not take into account databases or partitions located in folders other than the default storage folder (DataDir).

Knowledge Base article:

Summary

The monitor reports a Warning when the available free space for the default storage for the instance drops below the Warning Threshold setting, expressed as percentage of the sum of estimated default storage folder (DataDir) size and disk free space. The monitor reports a critical alert when the available space drops below the Critical Threshold. The monitor does not take into account databases or partitions located in folders other than the default storage folder (DataDir).

Causes

When the available disk space as a percentage of the default storage folder (DataDir) size for the instance becomes low, the database can become unhealthy, negatively affecting performance or even causing the server to fail. A common cause for this behavior may be fast growing database(s), but could also occur due to other data sharing available disk space with the default storage folder (DataDir) for the instance.

Resolutions

The resolution(s) for disk space exhaustion depend upon the root causes, which must be investigated in each case when this issue occurs. The condition may be alleviated by any of many potential approaches:

External

Configure Server Properties in Analysis Services

SSAS Multidimensional Performance Guide

Element properties:

TargetMicrosoft.SQLServer.2008.AnalysisServices.Instance
Parent MonitorSystem.Health.PerformanceState
CategoryPerformanceHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServer.2008.AnalysisServices.MonitorType.Instance.FreeSpacePercent
RemotableTrue
AccessibilityPublic
Alert Message
SSAS 2008: Instance default storage lacks sufficient disk space.
Only {5}\% of free space is available for SSAS Instance default storage (DataDir). This value is less than the configured threshold for the storage folder“{0}”.

Drive (Mount Point): {4}
Data folder (DataDir): {0}
Disk size: {1} GB
Instance free space: {6} GB ({5}\%)
Data folder size: {2} GB
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Instance.FreeSpace" Accessibility="Public" Enabled="true" Target="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance" ParentMonitorID="SystemHealth!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.2008.AnalysisServices.MonitorType.Instance.FreeSpacePercent" ConfirmDelivery="false">
<Category>PerformanceHealth</Category>
<AlertSettings AlertMessage="Microsoft.SQLServer.2008.AnalysisServices.UnitMonitor.Instance.FreeSpace.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>Error</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Target/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance']/DataDir$</AlertParameter1>
<AlertParameter2>$Data/Context/Property[@Name='TotalOnInstanceDriveGB']$</AlertParameter2>
<AlertParameter3>$Data/Context/Property[@Name='InstanceDefaultForlderSizeGB']$</AlertParameter3>
<AlertParameter4>$Data/Context/Property[@Name='UsedOnInstanceDriveGB']$</AlertParameter4>
<AlertParameter5>$Target/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance']/MountPoint$</AlertParameter5>
<AlertParameter6>$Data/Context/Property[@Name='ASInstanceFreeSpacePercent']$</AlertParameter6>
<AlertParameter7>$Data/Context/Property[@Name='ASInstanceFreeSpaceGB']$</AlertParameter7>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="Success" MonitorTypeStateID="Above" HealthState="Success"/>
<OperationalState ID="Warning" MonitorTypeStateID="Between" HealthState="Warning"/>
<OperationalState ID="Error" MonitorTypeStateID="Below" HealthState="Error"/>
</OperationalStates>
<Configuration>
<ServiceName>$Target/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance']/ServiceName$</ServiceName>
<ConnectionString>$Target/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance']/ConnectionString$</ConnectionString>
<DataDir>$Target/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance']/DataDir$</DataDir>
<CriticalThreshold>5</CriticalThreshold>
<WarningThreshold>10</WarningThreshold>
<IntervalSeconds>900</IntervalSeconds>
<SyncTime/>
</Configuration>
</UnitMonitor>