The rule collects the current configuration for the LowMemoryLimit of the SSAS instance in gigabytes.
The rule collects the current configuration for the LowMemoryLimit of the SSAS instance in gigabytes.
TechNet documentation for Analysis Services memory properties
Target | Microsoft.SQLServer.2008.AnalysisServices.Instance |
Category | PerformanceCollection |
Enabled | True |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.2008.AnalysisServices.DataSource.ScheduledPerfomanceDataProvider | 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.Instance.LowMemoryLimit" 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.ScheduledPerfomanceDataProvider" RunAs="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.RunAsProfile.ASMonitoring">
<PrincipalName>$Target/Host/Property[Type='Windows!Microsoft.Windows.Computer']/PrincipalName$</PrincipalName>
<PerformanceCounterObjectName>$Target/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance']/PerformanceCounterObject$:Memory</PerformanceCounterObjectName>
<PerformanceCounterName>Memory Limit Low KB</PerformanceCounterName>
<PerformanceCounterInstanceName/>
<Divider>1048576</Divider>
<IntervalSeconds>900</IntervalSeconds>
<SyncTime/>
</DataSource>
</DataSources>
<ConditionDetection ID="Mapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SSAS Instance</ObjectName>
<CounterName>Low Memory Limit (GB)</CounterName>
<InstanceName>$Target/Property[Type="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.ServerRole"]/InstanceName$</InstanceName>
<Value>$Data/Property[@Name='Memory Limit Low KB']$</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>