SQL Server, Broker Activation Object
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
Reference
sys.dm_broker_activated_tasks (Transact-SQL)
sys.dm_broker_queue_monitors (Transact-SQL)