SSRS 2014: esecuzioni report al minuto (Distribuzione)

Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.DeploymentWatcher.CountOfReportExecutions (Rule)

La regola raccoglie il numero totale di esecuzioni report al minuto per l'intera distribuzione di SQL Server Reporting Services. La regola esegue una query sul database di catalogo di SSRS per ottenere le informazioni.

Knowledge Base article:

Riepilogo

Parametri di cui è possibile eseguire l'override

Nome	Descrizione	Valore predefinito
Abilitato	Enables or disables the workflow	1
Genera avvisi	The recurring interval of time in seconds in which to run the workflow.	No
Intervallo (secondi)	Intervallo di tempo ricorrente in secondi in cui eseguire il flusso di lavoro.
Ora di sincronizzazione	The workflow will fail and register an event, if it cannot access the database during the specified period.	200
Timeout per la connessione di database	Il flusso di lavoro avrà esito negativo e registrerà un evento se non riesce ad accedere al database durante l'intervallo di tempo specificato.	300

Element properties:

Target	Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher
Category	PerformanceCollection
Enabled	True
Alert Generate	False
Remotable	True

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.2014.ReportingServices.DataSource.TSQLCountersReportingServiceCustom	Microsoft.SQLServer.2014.ReportingServices.RunAsProfile.Monitoring
Mapper	ConditionDetection	System.Performance.DataGenericMapper	Default
WriteToDB	WriteAction	Microsoft.SystemCenter.CollectPerformanceData	Microsoft.SQLServer.2014.ReportingServices.RunAsProfile.Monitoring
WriteToDW	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData	Microsoft.SQLServer.2014.ReportingServices.RunAsProfile.Monitoring

Source Code:

<Rule ID="Microsoft.SQLServer.2014.ReportingServices.PerformanceRule.DeploymentWatcher.CountOfReportExecutions" Enabled="true" Target="SQLRS!Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Microsoft.SQLServer.2014.ReportingServices.DataSource.TSQLCountersReportingServiceCustom" RunAs="SQLRS!Microsoft.SQLServer.2014.ReportingServices.RunAsProfile.Monitoring">

      <DatabaseServerName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher"]/ServerFQDN$</DatabaseServerName>

      <DatabaseInstanceName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher"]/DBInstanceName$</DatabaseInstanceName>

      <DatabaseName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2014.ReportingServices.DeploymentWatcher"]/DBName$</DatabaseName>

      <ServerName/>

      <InstanceName/>

      <TSQLCounterClassName>PerformanceStatistics</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 Deployment Watcher</ObjectName>

    <CounterName>Report executions/min</CounterName>

    <InstanceName/>

    <Value>$Data/Property[@Name='Executions']$</Value>

  </ConditionDetection>

  <WriteActions>

    <WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData" RunAs="SQLRS!Microsoft.SQLServer.2014.ReportingServices.RunAsProfile.Monitoring"/>

    <WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData" RunAs="SQLRS!Microsoft.SQLServer.2014.ReportingServices.RunAsProfile.Monitoring"/>

  </WriteActions>

</Rule>