MSSQL 2016: Broker Activation: Tasks Aborted Per Second

Microsoft.SQLServer.2016.SQLServer_Broker_Activation_Tasks_Aborted_sec__Total_15.0_minutes_5_Rule (Rule)

This counter reports the total number of activation stored procedure tasks that end with an error, or are aborted by a queue monitor for failing to receive messages. This counter is polled every fifteen minutes.

Knowledge Base article:

Summary

Overridable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	Yes
Frequency (seconds)	The recurring interval of time in seconds in which to run the workflow.	900

Element properties:

Target	Microsoft.SQLServer.2016.DBEngine
Category	PerformanceCollection
Enabled	True
Instance Name	$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/PerformanceCounterObject$:Broker Activation
Counter Name	Tasks Aborted/sec
Frequency	900
Alert Generate	False
Remotable	True
Comment	Mom2016ID='{1C2362E8-88A7-4AAD-B0A7-AB68F855F1BD}';MOM2016GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}

Member Modules:

ID	Module Type	TypeId	RunAs
_321B9948_9388_406B_9B47_5E3337AB5A0C_	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.2016.SQLServer_Broker_Activation_Tasks_Aborted_sec__Total_15.0_minutes_5_Rule" Target="SQL2016Core!Microsoft.SQLServer.2016.DBEngine" Enabled="true" ConfirmDelivery="false" Comment="Mom2016ID='{1C2362E8-88A7-4AAD-B0A7-AB68F855F1BD}';MOM2016GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="_321B9948_9388_406B_9B47_5E3337AB5A0C_" Comment="{321B9948-9388-406B-9B47-5E3337AB5A0C}" TypeID="SystemPerf!System.Performance.DataProvider">

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

      <CounterName>Tasks Aborted/sec</CounterName>

      <ObjectName>$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.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>