SQL Server, Broker Activation object
Applies to:
SQL Server
The SQLServer:Broker Activation 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. |
Example
You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:
SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%Broker Activation%';
Related content
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें