SSAS 2012: Collect Partition Used by Others (GB)

Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalPartition.UsedByOthers (Rule)

The rule collects the total amount of space in gigabytes on the drive where the storage folder of the partition is located, which is allocated by files and folders other than the storage folder of the partition.

Knowledge Base article:

Element properties:

Member Modules:

Source Code:

<Rule ID="Microsoft.SQLServer.2012.AnalysisServices.PerformanceRule.MultidimensionalPartition.UsedByOthers" Enabled="true" Target="SQLAS!Microsoft.SQLServer.2012.AnalysisServices.MultidimensionalPartition" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

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

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

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

      <DatabaseName>$Target/Host/Property[Type='SQLAS!Microsoft.SQLServer.2012.AnalysisServices.Database']/DatabaseName$</DatabaseName>

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

      <IntervalSeconds>900</IntervalSeconds>

      <SyncTime/>

    </DataSource>

  </DataSources>

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

    <ObjectName>Multidimensional Partition</ObjectName>

    <CounterName>Partition Used by Others (GB)</CounterName>

    <InstanceName>$Target/Property[Type="SQLAS!Microsoft.SQLServer.2012.AnalysisServices.Partition"]/PartitionName$</InstanceName>

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

  </ConditionDetection>

  <WriteActions>

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

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

  </WriteActions>

</Rule>