The rule collects the amount of free space in gigabytes on the drive where the storage folder of the database is located.
The rule collects the amount of free space in gigabytes on the drive where the storage folder of the database is located. If the data folder for the SSAS instance has insufficient space during a processing operation, data corruption could occur.
Target | Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase |
Category | PerformanceCollection |
Enabled | True |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.2008.AnalysisServices.DataSource.DatabaseSpace | 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 |
<Rule ID="Microsoft.SQLServer.2008.AnalysisServices.PerformanceRule.MultidimensionalDatabase.FreeSpace" Enabled="true" Target="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.MultidimensionalDatabase" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.2008.AnalysisServices.DataSource.DatabaseSpace" RunAs="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.RunAsProfile.ASMonitoring">
<ServiceName>$Target/Host/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance']/ServiceName$</ServiceName>
<DatabaseName>$Target/Property[Type="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Database"]/DatabaseName$</DatabaseName>
<ConnectionString>$Target/Host/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance']/ConnectionString$</ConnectionString>
<DataDir>$Target/Host/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>Multidimensional Database</ObjectName>
<CounterName>Database Free Space (GB)</CounterName>
<InstanceName>$Target/Property[Type="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Database"]/DatabaseName$</InstanceName>
<Value>$Data/Property[@Name='DatabaseFreeSpaceGB']$</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>