MSSQL on Windows: Broker Activation: Task Limit Reached per Second

Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_TaskLimitReachedSec (Rule)

Collects the "Broker Activation: Task Limit Reached per Second" performance counter for each instance of SQL DB Engine.

Knowledge Base article:

Summary

The rule collects the "Broker Activation: Task Limit Reached per Second" performance counter for each instance of SQL DB Engine.

Service Broker Activation

"Broker Activation: Task Limit Reached per Second" - The number of times the activated task limit on a queue has been reached per second.

Overridable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	Yes
Interval (seconds)	The recurring interval of time in seconds in which to run the workflow.	900
Timeout (seconds)	Specifies the time the workflow is allowed to run before being closed and marked as failed.	300
Timeout for query execution (seconds)	The workflow will fail and register an event, if the query execution takes longer than the specified period.	60
Timeout for database connection (seconds)	The workflow will fail and register an event, if it cannot access the database during the specified period.	15

Element properties:

Target	Microsoft.SQLServer.Windows.DBEngine
Category	PerformanceCollection
Enabled	True
Alert Generate	False
Remotable	True

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.Windows.DataSource.SqlOsPerformanceReader	Default
PerfMapper	ConditionDetection	System.Performance.DataGenericMapper	Default
WriteToDB	WriteAction	Microsoft.SystemCenter.CollectPerformanceData	Default
WriteToDW	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData	Default

Source Code:

<Rule ID="Microsoft.SQLServer.Windows.CollectionRule.DBEngine.BrokerActivation_TaskLimitReachedSec" Target="SqlDiscW!Microsoft.SQLServer.Windows.DBEngine" Enabled="true">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Microsoft.SQLServer.Windows.DataSource.SqlOsPerformanceReader">

      <MachineName>$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/MachineName$</MachineName>

      <NetbiosComputerName>$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/NetbiosComputerName$</NetbiosComputerName>

      <InstanceName>$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/InstanceName$</InstanceName>

      <ConnectionString>$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/ConnectionString$</ConnectionString>

      <InstanceVersion>$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Version$</InstanceVersion>

      <InstanceEdition>$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Edition$</InstanceEdition>

      <MonitoringType>$Target/Property[Type="SqlDiscW!Microsoft.SQLServer.Windows.DBEngine"]/MonitoringType$</MonitoringType>

      <SqlExecTimeoutSeconds>60</SqlExecTimeoutSeconds>

      <SqlTimeoutSeconds>15</SqlTimeoutSeconds>

      <TimeoutSeconds>300</TimeoutSeconds>

      <IntervalSeconds>900</IntervalSeconds>

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

      <PerfInstanceName>_Total</PerfInstanceName>

      <PerfParams>

        <NameOfHandler>SqlOsPerfCounterReader</NameOfHandler>

        <PerformanceCounterObject>$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/PerformanceCounterObject$</PerformanceCounterObject>

        <CounterConfig>

          <CategoryName>Broker Activation</CategoryName>

          <CounterName>Task Limit Reached/sec</CounterName>

          <BaseCounterName/>

          <InstanceSelector>1</InstanceSelector>

          <NeedsPrefix>1</NeedsPrefix>

          <InstanceIndex>0</InstanceIndex>

        </CounterConfig>

      </PerfParams>

    </DataSource>

  </DataSources>

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

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

    <CounterName>Task Limit Reached/sec</CounterName>

    <InstanceName>_Total</InstanceName>

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

  </ConditionDetection>

  <WriteActions>

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

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

  </WriteActions>

</Rule>