The rule collects the size of free space on the drive, where the partition storage is located, expressed as percentage of the sum of the partition storage folder total size plus disk free space.
The rule collects the size of free space on the drive, where the partition storage is located, expressed as percentage of the sum of the partition storage folder total size plus disk free space. This allows the administrator to consider precisely, whether the free space available for the partition storage is appropriate for the environment.
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 |
Target | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalPartition |
Category | PerformanceCollection |
Enabled | True |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.2008.AnalysisServices.DataSource.MultidimensionalPartitionSpace | Microsoft.SQLServer.2008.AnalysisServices.RunAsProfile.ASMonitoring |
Mapper | ConditionDetection | Microsoft.SQLServer.2008.AnalysisServices.ConditionDetection.PropertyBagPerformanceDataMapper | Default |
WriteToDatabase | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
WriteToDW | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalPartition.FreeSpacePercent" Enabled="true" Target="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalPartition" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.2008.AnalysisServices.DataSource.MultidimensionalPartitionSpace" RunAs="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.RunAsProfile.ASMonitoring">
<ServiceName>$Target/Host/Host/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance']/ServiceName$</ServiceName>
<ConnectionString>$Target/Host/Host/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance']/ConnectionString$</ConnectionString>
<DatabaseName>$Target/Host/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Database']/DatabaseName$</DatabaseName>
<DataDir>$Target/Host/Host/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance']/DataDir$</DataDir>
<IntervalSeconds>900</IntervalSeconds>
<SyncTime/>
<TimeoutSeconds>300</TimeoutSeconds>
</DataSource>
</DataSources>
<ConditionDetection ID="Mapper" TypeID="Microsoft.SQLServer.2008.AnalysisServices.ConditionDetection.PropertyBagPerformanceDataMapper">
<ObjectName>SSAS Partition</ObjectName>
<CounterName>Partition Free Space (%)</CounterName>
<InstanceName/>
<PropertyName>PartitionFreeSpacePercent</PropertyName>
</ConditionDetection>
<WriteActions>
<WriteAction ID="WriteToDatabase" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>