Número atual de consultas de Mineração de Dados ativas. Este contador é sondado a cada quinze minutos.
Diferente da maioria das regras de coleta de dados de desempenho, esta regra requer direitos de administrador no servidor para que os dados sejam coletados pelo agente. Sendo assim, ela é configurada para aproveitar o perfil RunAs "Conta de Monitoramento do SQL Server" que é fornecido com o SQL. Para os sistemas em que a conta de ação do agente padrão não é um administrador, você deve configurar o perfil RunAs "Conta de Monitoramento do SQL Server" apropriadamente para garantir que esses dados de desempenho sejam coletados.
Target | Microsoft.SQLServer.2005.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 | Mom2005ID='{10F9E72D-BB0D-4FF0-BF6D-49F0BE4F1079}';MOM2005GroupID={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.2005.MSAS_2005_Data_Mining_Prediction_Concurrent_DM_queries_15.0_minutes_5_Rule" Target="SQL2005Core!Microsoft.SQLServer.2005.AnalysisServices" Enabled="true" ConfirmDelivery="false" Comment="Mom2005ID='{10F9E72D-BB0D-4FF0-BF6D-49F0BE4F1079}';MOM2005GroupID={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>