Number of rows read from source database per second. 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" Run As 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" Run As profile accordingly to ensure this performance data is collected.
Note that SQL Server Analysis Services Windows service is not supported by any edition of SQL Server Express.
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Frequency (seconds) | The recurring interval of time in seconds in which to run the workflow. | 900 |
Target | Microsoft.SQLServer.2012.AnalysisServices |
Category | PerformanceCollection |
Enabled | True |
Instance Name | $Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Processing |
Counter Name | Rows read/sec |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
Comment | Mom2012ID='{781C7846-916C-4A0B-82CD-188BF3CBB973}';MOM2012GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74} |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
_E606126E_8B9F_44E7_9A3E_9EB2B565EAAA_ | 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.2012.MSAS11_Proc_Rows_read_sec_15.0_minutes_5_Rule" Target="SQL2012Core!Microsoft.SQLServer.2012.AnalysisServices" Enabled="true" ConfirmDelivery="false" Comment="Mom2012ID='{781C7846-916C-4A0B-82CD-188BF3CBB973}';MOM2012GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="_E606126E_8B9F_44E7_9A3E_9EB2B565EAAA_" Comment="{E606126E-8B9F-44E7-9A3E-9EB2B565EAAA}" TypeID="SystemPerf!System.Performance.DataProvider" RunAs="SQL!Microsoft.SQLServer.SQLProbeAccount">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>Rows read/sec</CounterName>
<ObjectName>$Target/Property[Type="SQL!Microsoft.SQLServer.AnalysisServices"]/PerformanceCounterObject$:Processing</ObjectName>
<Frequency>900</Frequency>
</DataSource>
</DataSources>
<ConditionDetection ID="PerfMapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SQL Analysis Services:Processing</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>