Current number of active Data Mining queries. This counter is polled every fifteen minutes.
Unlike most performance data collection rules, this rule requires administrator rights on the server in order for the data to be collected by the agent. As such this rule is configured to leverage the "SQL Server Monitoring Account" RunAs profile that is provided with the SQL. For systems where the default agent action account is not an administrator, you must configure the "SQL Server Monitoring Account" RunAs profile accordingly to ensure this performance data is collected.
Target | Microsoft.SQLServer.2008.AnalysisServices |
Category | PerformanceCollection |
Enabled | True |
Instance Name | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Data Mining Prediction |
Counter Name | Concurrent DM queries |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
Comment | Mom2008ID='{10F9E72D-BB0D-4FF0-BF6D-49F0BE4F1079}';MOM2008GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74} |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
_33B1BF62_E588_44C1_B302_481833D7A514_ | DataSource | System.Performance.DataProvider | Microsoft.SQLServer.SQLProbeAccount |
PerfMapper | ConditionDetection | System.Performance.DataGenericMapper | Default |
CollectPerfData | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
CollectPerfDataWarehouse | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.SQLServer.2008.MSAS_2008_Data_Mining_Prediction_Concurrent_DM_queries_15.0_minutes_5_Rule" Target="SQL2008Core!Microsoft.SQLServer.2008.AnalysisServices" Enabled="true" ConfirmDelivery="false" Comment="Mom2008ID='{10F9E72D-BB0D-4FF0-BF6D-49F0BE4F1079}';MOM2008GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="_33B1BF62_E588_44C1_B302_481833D7A514_" Comment="{33B1BF62-E588-44C1-B302-481833D7A514}" TypeID="SystemPerf!System.Performance.DataProvider" RunAs="SQL!Microsoft.SQLServer.SQLProbeAccount">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>Concurrent DM queries</CounterName>
<ObjectName>$Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Data Mining Prediction</ObjectName>
<Frequency>900</Frequency>
</DataSource>
</DataSources>
<ConditionDetection ID="PerfMapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SQL Analysis Services:Data Mining Prediction</ObjectName>
<CounterName>$Data/CounterName$</CounterName>
<InstanceName>$Data/InstanceName$</InstanceName>
<Value>$Data/Value$</Value>
</ConditionDetection>
<WriteActions>
<WriteAction ID="CollectPerfData" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="CollectPerfDataWarehouse" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>