The rule collects total memory usage in gigabytes on the server where the SSAS instance is located.
The rule collects total memory usage in gigabytes on the server where the SSAS instance is located.
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.ScheduledInstancePerfomanceDataProvider | 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.MemoryUsageOnTheServer" 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.ScheduledInstancePerfomanceDataProvider" RunAs="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.RunAsProfile.ASMonitoring">
<ServiceName>$Target/Property[Type='SQLAS!Microsoft.SQLServer.2008.AnalysisServices.Instance']/ServiceName$</ServiceName>
<PerformanceCounterClassName>ServerHardwareInfo</PerformanceCounterClassName>
<PerformanceCounterPropertyName>UsedPhysicalMemoryKB</PerformanceCounterPropertyName>
<DividerIfGreater>0</DividerIfGreater>
<Divider>1048576</Divider>
<IntervalSeconds>900</IntervalSeconds>
<SyncTime/>
</DataSource>
</DataSources>
<ConditionDetection ID="Mapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SSAS Instance</ObjectName>
<CounterName>Memory Usage on the Server (GB)</CounterName>
<InstanceName>$Target/Property[Type="SQLAS!Microsoft.SQLServer.2008.AnalysisServices.ServerRole"]/InstanceName$</InstanceName>
<Value>$Data/Property[@Name='UsedPhysicalMemoryKB']$</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>