Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

SQL Server, Broker Activation Object

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft