Home
  •  

SSRS 2012: 분당 보고서 실행

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

규칙은 지정된 SSRS 인스턴스에 대해 분당 보고서 실행 수를 수집합니다.

Knowledge Base article:

요약

규칙은 지정된 SSRS 인스턴스에 대해 분당 보고서 실행 수를 수집합니다.

재정의 가능한 매개 변수

이름

설명

기본값

사용

Enables or disables the workflow

1

알림 생성

The recurring interval of time in seconds in which to run the workflow.

아니요

간격(초)

워크플로를 실행하는 반복 시간 간격(초)입니다.

 

동기화 시간

The workflow will fail and register an event, if it cannot access the database during the specified period.

200

데이터베이스 연결 시간 제한

지정된 시간 간격 동안 데이터베이스에 액세스할 수 없는 경우 워크플로가 작업을 수행하지 못하고 이벤트를 등록합니다.

300

Element properties:

TargetMicrosoft.SQLServer.2012.ReportingServices.Instance
CategoryPerformanceCollection
EnabledTrue
Alert GenerateFalse
RemotableTrue

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>