Home
  •  

SSAS 2008: Collect Instance Free Space (\%)

Microsoft.SQLServer.2008.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.

Element properties:

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

Member Modules:

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

Source Code:

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

  <Category>PerformanceCollection</Category>

  <DataSources>

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

      <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>

      <IntervalSeconds>900</IntervalSeconds>

      <SyncTime/>

    </DataSource>

  </DataSources>

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

    <ObjectName>SSAS Instance</ObjectName>

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

    <InstanceName>$Target/Property[Type="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.ServerRole"]/InstanceName$</InstanceName>

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

  </ConditionDetection>

  <WriteActions>

    <WriteAction ID="WriteToDatabase" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData" RunAs="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.RunAsProfile.ASMonitoring"/>

    <WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData" RunAs="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.RunAsProfile.ASMonitoring"/>

  </WriteActions>

</Rule>