The rule collects the number of report executions per minute for the given SSRS Instance.
The rule collects the number of report executions per minute for the given SSRS Instance.
Name | Description | Default Value |
Enabled |
| 1 |
Generates Alerts |
| No |
Interval (seconds) | The recurring interval of time in seconds in which to run the workflow. | 900 |
Synchronization Time |
|
|
Time out for database connection | The workflow will fail and register an event if it cannot access the database during specified time interval. | 300 |
Target | Microsoft.SQLServer.2012.ReportingServices.Instance |
Category | PerformanceCollection |
Enabled | True |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.2012.ReportingServices.DataSource.TSQLCountersReportingServiceCustom | Microsoft.SQLServer.2012.ReportingServices.RunAsProfile.Monitoring |
Mapper | ConditionDetection | System.Performance.DataGenericMapper | Default |
WriteToDB | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Microsoft.SQLServer.2012.ReportingServices.RunAsProfile.Monitoring |
WriteToDW | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Microsoft.SQLServer.2012.ReportingServices.RunAsProfile.Monitoring |
<Rule ID="Microsoft.SQLServer.2012.ReportingServices.PerformanceRule.Instance.CountOfExecution" Enabled="true" Target="SQLRS!Microsoft.SQLServer.2012.ReportingServices.Instance" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.2012.ReportingServices.DataSource.TSQLCountersReportingServiceCustom" RunAs="SQLRS!Microsoft.SQLServer.2012.ReportingServices.RunAsProfile.Monitoring">
<DatabaseServerName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2012.ReportingServices.Instance"]/DatabaseServerFQDN$</DatabaseServerName>
<DatabaseInstanceName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2012.ReportingServices.Instance"]/DatabaseServerInstanceName$</DatabaseInstanceName>
<DatabaseName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2012.ReportingServices.Instance"]/DatabaseName$</DatabaseName>
<ServerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ServerName>
<InstanceName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2012.ReportingServices.Instance"]/InstanceName$</InstanceName>
<TSQLCounterClassName>InstancePerformanceStatistics</TSQLCounterClassName>
<TSQLCounterPropertyName>Executions</TSQLCounterPropertyName>
<TimeOut>300</TimeOut>
<IntervalSeconds>900</IntervalSeconds>
<DividerIfGreater>0</DividerIfGreater>
<Divider>1</Divider>
<SyncTime/>
</DataSource>
</DataSources>
<ConditionDetection ID="Mapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SQL RS Instance</ObjectName>
<CounterName>Executions/min</CounterName>
<InstanceName/>
<Value>$Data/Property[@Name='Executions']$</Value>
</ConditionDetection>
<WriteActions>
<WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData" RunAs="SQLRS!Microsoft.SQLServer.2012.ReportingServices.RunAsProfile.Monitoring"/>
<WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData" RunAs="SQLRS!Microsoft.SQLServer.2012.ReportingServices.RunAsProfile.Monitoring"/>
</WriteActions>
</Rule>