sql-server-broker-activation-object.md

title	SQL Server, Broker Activation Object | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql
ms.prod_service	database-engine
ms.component	performance-monitor
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	conceptual
helpviewer_keywords	SQLServer:Broker Activation Broker Activation object
ms.assetid	cd9b6880-c924-42c7-b333-09c303317c0b
caps.latest.revision	20
author	MikeRayMSFT
ms.author	mikeray
manager	craigg

SQL Server, Broker Activation Object

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] The SQLServer:BrokerActivation performance object contains performance counters that report information on stored procedure activation. The table below lists the counters that this object contains.

SQL Server Broker Activation counters	Description
Stored Procedures Invoked/sec	This counter reports the total number of activation stored procedures invoked by all queue monitors in the instance per second.
Task Limit Reached	This counter reports the total number of times that a queue monitor would have started a new task, but did not because the maximum number of tasks for the queue is already running.
Task Limit Reached/sec	This counter reports the number of times per second that a queue monitor would have started a new task, but did not because the maximum number of tasks for the queue is already running.
Tasks Aborted/sec	This counter reports the number of activation stored procedure tasks that end with an error, or are aborted by a queue monitor for failing to receive messages.
Tasks Running	This counter reports the number of activation stored procedures that are currently running.
Tasks Started/sec	This counter reports the number of activation stored procedures started per second by all queue monitors in the instance.

See Also

sys.dm_broker_activated_tasks (Transact-SQL)
sys.dm_broker_queue_monitors (Transact-SQL)
Monitor Resource Usage (System Monitor)