Home
  •  

SSAS 2014: Instance Free Space (\%)

Microsoft.SQLServer.2014.AnalysisServices.PerformanceRule.Instance.FreeSpacePercent (Rule)

The rule collects the amount of free space on the drive where the default storage folder (DataDir) for the SSAS instance is located , expressed as percentage of the sum of estimated default storage folder (DataDir) size and disk free space.

Knowledge Base article:

Summary

The rule collects the amount of free space on the drive where the default storage folder (DataDir) for the SSAS instance is located , expressed as percentage of the sum of estimated default storage folder (DataDir) size and disk free space. This allows an administrator to more accurately judge whether the free space available for the storage is appropriate in the environment.

Overrideable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow

True

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.

 

Element properties:

TargetMicrosoft.SQLServer.2014.AnalysisServices.Instance
CategoryPerformanceCollection
EnabledTrue
Alert GenerateFalse
RemotableTrue

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2014.AnalysisServices.DataSource.InstanceSpace Microsoft.SQLServer.2014.AnalysisServices.RunAsProfile.ASMonitoring
Mapper ConditionDetection System.Performance.DataGenericMapper Default
WriteToDatabase WriteAction Microsoft.SystemCenter.CollectPerformanceData Default
WriteToDW WriteAction Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData Default

Source Code:

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

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Microsoft.SQLServer.2014.AnalysisServices.DataSource.InstanceSpace" RunAs="SQLAS!Microsoft.SQLServer.2014.AnalysisServices.RunAsProfile.ASMonitoring">

      <ServiceName>$Target/Property[Type='SQLAS!Microsoft.SQLServer.2014.AnalysisServices.Instance']/ServiceName$</ServiceName>

      <ConnectionString>$Target/Property[Type='SQLAS!Microsoft.SQLServer.2014.AnalysisServices.Instance']/ConnectionString$</ConnectionString>

      <DataDir>$Target/Property[Type='SQLAS!Microsoft.SQLServer.2014.AnalysisServices.Instance']/DataDir$</DataDir>

      <IntervalSeconds>900</IntervalSeconds>

      <SyncTime/>

    </DataSource>

  </DataSources>

  <ConditionDetection ID="Mapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">

    <ObjectName>SSAS Instance</ObjectName>

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

    <InstanceName/>

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

  </ConditionDetection>

  <WriteActions>

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

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

  </WriteActions>

</Rule>