SSRS 2012 : Exécutions de rapports par minute

Microsoft.SQLServer.2012.ReportingServices.PerformanceRule.Instance.CountOfExecution (Rule)

La règle collecte le nombre d'exécutions de rapports par minute pour l'instance SSRS donnée.

Knowledge Base article:

Résumé

La règle collecte le nombre d'exécutions de rapports par minute pour l'instance SSRS donnée.

Paramètres remplaçables

Nom	Description	Valeur par défaut
Activé	Enables or disables the workflow	1
Génère des alertes	The recurring interval of time in seconds in which to run the workflow.	Non
Intervalle (en secondes)	L'intervalle de temps récurrent en secondes pendant lequel le workflow est exécuté.
Heure de synchronisation	The workflow will fail and register an event, if it cannot access the database during the specified period.	200
Délai d'expiration de la connexion à la base de données	Le workflow échouera et enregistrera un événement s'il ne peut pas accéder à la base de données durant l'intervalle de temps spécifié.	300

Element properties:

Target	Microsoft.SQLServer.2012.ReportingServices.Instance
Category	PerformanceCollection
Enabled	True
Alert Generate	False
Remotable	True

Member Modules:

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

Source Code:

<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>