The rule collects the number of scheduled executions per minute for entire SSRS Deployment. The rule queries SSRS Catalog database to get the information.
The rule collects the number of scheduled executions per minute for entire SSRS Deployment. The rule queries SSRS Catalog database to get the information.
Scheduled executions are logged into the RS Catalog Database under ExecutionLogStorage table.
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.DeploymentWatcher |
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.DeploymentWatcher.ScheduledExecutions" Enabled="true" Target="SQLRS!Microsoft.SQLServer.2012.ReportingServices.DeploymentWatcher" 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.DeploymentWatcher"]/ServerFQDN$</DatabaseServerName>
<DatabaseInstanceName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2012.ReportingServices.DeploymentWatcher"]/DBInstanceName$</DatabaseInstanceName>
<DatabaseName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2012.ReportingServices.DeploymentWatcher"]/DBName$</DatabaseName>
<ServerName/>
<InstanceName/>
<TSQLCounterClassName>PerformanceStatistics</TSQLCounterClassName>
<TSQLCounterPropertyName>ScheduledExecutions</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 Deployment Watcher</ObjectName>
<CounterName>Scheduled executions/min</CounterName>
<InstanceName/>
<Value>$Data/Property[@Name='ScheduledExecutions']$</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>