TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

SQL Server, Broker Activation Object

 

Applies To: SQL Server 2016

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 countersDescription
Stored Procedures Invoked/secThis counter reports the total number of activation stored procedures invoked by all queue monitors in the instance per second.
Task Limit ReachedThis 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/secThis 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/secThis 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 RunningThis counter reports the number of activation stored procedures that are currently running.
Tasks Started/secThis counter reports the number of activation stored procedures started per second by all queue monitors in the instance.

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

Community Additions

ADD
Show:
© 2016 Microsoft