The rule collects current cost of memory as calculated by SSAS (cost per byte per unit of time) normalized and expressed on a scale from 0 to 1000.
The rule collects current cost of memory as calculated by SSAS (cost per byte per unit of time) normalized and expressed on a scale from 0 to 1000. This can allow the administrators to understand the server’s behavior regarding how aggressively it runs a thread, which removes data from the cache, based on the current estimate of this cost. When the cost is estimated to be higher, the cleaner thread will engage more aggressively and conversely; when lower, it will be less aggressive. Therefore, monitoring the server’s current cost estimate can allow the administrators to gauge this aspect SSAS instance health aspect.
TechNet documentation for Analysis Services memory properties
Configure Server Properties in Analysis Services
TechNet documentation for SSAS Performance Counters
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.AnalysisServices.Windows.Instance |
Category | PerformanceCollection |
Enabled | True |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.DataSource.ScheduledPerfomanceDataProvider | Microsoft.SQLServer.Core.RunAs.Monitoring |
Mapper | ConditionDetection | System.Performance.DataGenericMapper | Default |
WriteToDatabase | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
WriteToDW | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.PerformanceRule.Instance.MemoryCostPerfomance" Target="SQLAS!Microsoft.SQLServer.AnalysisServices.Windows.Instance" Enabled="true" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.AnalysisServices.Windows.Monitoring.DataSource.ScheduledPerfomanceDataProvider" RunAs="MSCL!Microsoft.SQLServer.Core.RunAs.Monitoring">
<PrincipalName>$Target/Host/Property[Type='Windows!Microsoft.Windows.Computer']/PrincipalName$</PrincipalName>
<PerformanceCounterObjectName>$Target/Property[Type='ASCore!Microsoft.SQLServer.AnalysisServices.Core.Instance']/PerformanceCounterObject$:Memory</PerformanceCounterObjectName>
<PerformanceCounterName>Cleaner Current Price</PerformanceCounterName>
<PerformanceCounterInstanceName/>
<Divider>1</Divider>
<IntervalSeconds>900</IntervalSeconds>
<SyncTime/>
<TimeoutSeconds>300</TimeoutSeconds>
</DataSource>
</DataSources>
<ConditionDetection ID="Mapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SSAS Instance:Memory</ObjectName>
<CounterName>Cleaner Current Price</CounterName>
<InstanceName/>
<Value>$Data/Property[@Name='Cleaner Current Price']$</Value>
</ConditionDetection>
<WriteActions>
<WriteAction ID="WriteToDatabase" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>