MSSQL 2014 : Activation Broker : Tâches démarrées par seconde

Microsoft.SQLServer.2014.SQLServer_Broker_Activation_Tasks_Started_sec__Total_15.0_minutes_5_Rule (Rule)

Ce compteur indique le nombre total de procédures stockées d'activation démarrées par seconde par tous les moniteurs de file d'attente de l'instance. Ce compteur est interrogé toutes les quinze minutes.

Knowledge Base article:

Résumé

Paramètres remplaçables

Nom	Description	Valeur par défaut
Activé		Oui
Fréquence	L'intervalle de temps récurrent en secondes pendant lequel le workflow est exécuté.	900
Génère des alertes		Non

Element properties:

Target	Microsoft.SQLServer.2014.DBEngine
Category	PerformanceCollection
Enabled	True
Instance Name	$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/PerformanceCounterObject$:Broker Activation
Counter Name	Tasks Started/sec
Frequency	900
Alert Generate	False
Remotable	True
Comment	Mom2014ID='{667C48FA-76AC-4CC0-84B3-BEECA4CD9163}';MOM2014GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}

Member Modules:

ID	Module Type	TypeId	RunAs
_CFABDD47_EABC_47D2_BCE3_60D7A5F8AF29_	DataSource	System.Performance.DataProvider	Default
PerfMapper	ConditionDetection	System.Performance.DataGenericMapper	Default
CollectPerfData	WriteAction	Microsoft.SystemCenter.CollectPerformanceData	Default
CollectPerfDataWarehouse	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData	Default

Source Code:

<Rule ID="Microsoft.SQLServer.2014.SQLServer_Broker_Activation_Tasks_Started_sec__Total_15.0_minutes_5_Rule" Target="SQL2014Core!Microsoft.SQLServer.2014.DBEngine" Enabled="true" ConfirmDelivery="false" Comment="Mom2014ID='{667C48FA-76AC-4CC0-84B3-BEECA4CD9163}';MOM2014GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="_CFABDD47_EABC_47D2_BCE3_60D7A5F8AF29_" Comment="{CFABDD47-EABC-47D2-BCE3-60D7A5F8AF29}" TypeID="SystemPerf!System.Performance.DataProvider">

      <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <CounterName>Tasks Started/sec</CounterName>

      <ObjectName>$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/PerformanceCounterObject$:Broker Activation</ObjectName>

      <InstanceName>_Total</InstanceName>

      <Frequency>900</Frequency>

    </DataSource>

  </DataSources>

  <ConditionDetection ID="PerfMapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">

    <ObjectName>SQL DB Engine:Broker Activation</ObjectName>

    <CounterName>$Data/CounterName$</CounterName>

    <InstanceName>$Data/InstanceName$</InstanceName>

    <Value>$Data/Value$</Value>

  </ConditionDetection>

  <WriteActions>

    <WriteAction ID="CollectPerfData" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>

    <WriteAction ID="CollectPerfDataWarehouse" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>

  </WriteActions>

</Rule>