Monitoring (Service Broker)
SQL Server provides dynamic management views, trace events, and performance objects to monitor Database Engine activity that is related to Service Broker.
The following dynamic management views let you monitor Service Broker activity.
Contains a row for each stored procedure activated by Service Broker.
Contains a row for each Service Broker network connection.
Contains a row for each Service Broker message that the SQL Server instance is in the process of forwarding.
Contains a row for each queue monitor in the instance. A queue monitor manages activation for a queue.
The following performance objects report on Service Broker activity.
Contains performance counters that report information on stored procedure activation.
Contains performance counters that report general Service Broker information.
Contains performance counters that report information related to Service Broker and database mirroring network activity.
SQL Server includes the Broker event category for monitoring Service Broker activity. The following table lists the events in the Broker event category:
An event generated when a queue monitor starts an activation stored procedure.
An event generated to report the status of a transport connection managed by Service Broker.
An event generated to report the progress of a conversation.
An event generated when the database creates or drops a conversation group.
An event generated to report that the database has received a corrupt message.
An event generated when SQL Server drops a Service Broker message that was to have been forwarded.
An event generated when SQL Server forwards a Service Broker message.
An event generated when Service Broker determines the routing for a message.
An event generated when Service Broker is unable to retain a received message that should have been delivered to a service in this instance.
An event generated when Service Broker sends or receives a message acknowledgement.