SSAS: Database Free Space (\%)

Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalDatabase.FreeSpacePercent (Rule)

The rule collects the amount of free space on the drive, where the storage folder of the database is located, expressed as percentage of the sum of estimated database storage folder size and disk free space. The rule does not take into account partitions located in folders other than the DB storage folder.

Knowledge Base article:

Summary

The rule collects the amount of free space of the drive, where the storage folder of the database is located, expressed as percentage of the sum of estimated database storage folder size and disk free space. The rule does not take into account partitions located in folders other than the DB storage folder. If the data folder for SSAS instance has insufficient space during a processing operation, data corruption could occur.

Overridable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	Yes
Interval Seconds	The recurring interval of time in seconds in which to run the workflow.	900
Synchronization Time	The synchronization time specified by using a 24-hour format. May be omitted.
Timeout (seconds)	Specifies the time the workflow is allowed to run before being closed and marked as failed.	300

Element properties:

Target	Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase
Category	PerformanceCollection
Enabled	True
Alert Generate	False
Remotable	True

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.DataSource.DatabaseSpace	Microsoft.SQLServer.Core.RunAs.Monitoring
Mapper	ConditionDetection	Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.ConditionDetection.PropertyBagPerformanceDataMapper	Default
WriteToDatabase	WriteAction	Microsoft.SystemCenter.CollectPerformanceData	Default
WriteToDW	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData	Default

Source Code:

<Rule ID="Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.MultidimensionalDatabase.FreeSpacePercent" Enabled="true" Target="SQLAS!Microsoft.SQLServer.AnalysisServices.Windows.MultidimensionalDatabase" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.DataSource.DatabaseSpace" RunAs="MSCL!Microsoft.SQLServer.Core.RunAs.Monitoring">

      <ServiceName>$Target/Host/Property[Type='ASCore!Microsoft.SQLServer.AnalysisServices.Core.Instance']/ServiceName$</ServiceName>

      <DatabaseName>$Target/Property[Type='ASCore!Microsoft.SQLServer.AnalysisServices.Core.Database']/DatabaseName$</DatabaseName>

      <ConnectionString>$Target/Host/Property[Type='ASCore!Microsoft.SQLServer.AnalysisServices.Core.Instance']/ConnectionString$</ConnectionString>

      <DataDir>$Target/Host/Property[Type='ASCore!Microsoft.SQLServer.AnalysisServices.Core.Instance']/DataDir$</DataDir>

      <IntervalSeconds>900</IntervalSeconds>

      <SyncTime/>

      <TimeoutSeconds>300</TimeoutSeconds>

    </DataSource>

  </DataSources>

  <ConditionDetection ID="Mapper" TypeID="Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.ConditionDetection.PropertyBagPerformanceDataMapper">

    <ObjectName>SSAS Database</ObjectName>

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

    <InstanceName/>

    <PropertyName>DatabaseFreeSpacePercent</PropertyName>

  </ConditionDetection>

  <WriteActions>

    <WriteAction ID="WriteToDatabase" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>

    <WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>

  </WriteActions>

</Rule>