O'Reilly logo

Microsoft SQL Server 2012 Bible by Aaron Nelson, Jose Chinchilla, Patrick LeBlanc, Jorge Segarra, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Monitoring and Troubleshooting Service Broker

SQL Server has no user interface to monitor Service Broker activity. You can however make use of one or more of the following resources described in Table 25.1.

Table 25.1 Resources to Monitor Service Broker Activity

Resource Description
SQL Profiler SQL Profiler provides the same 13 trace events available since SQL Server 2005.
Extended Events Extended Events is the preferred method for troubleshooting and monitoring Service Broker activity. For a complete list and description of the Service Broker events available in SQL Server 2012, refer to http://technet.microsoft.com/en-us/library/ms186347.aspx.
ssbdiagnose Utility The ssbdiagnose utility introduced in SQL Server 2008R2 is still supported and is a great way to easily report issues in Service Broker conversations or service configuration issues. For more information on the ssbdiagnose utility, refer to http://msdn.microsoft.com/en-us/library/bb934450.aspx.
Catalog Views SQL Server 2012 provides 12 catalog views for Service Broker. Table 25.2 lists and describes each of these Catalog Views.
Dynamic Management Views (DMVs) SQL Server 2012 provides four basic DMVs to monitor tasks, messages, queues, and connections. Table 25.3 lists and describes each of these DMVs.

Table 25.2 describes the Service Broker Catalog Views available in SQL Server 2012.

Table 25.2 Service Broker Catalog Views

Catalog View Description
sys.conversation_endpoints This catalog view contains a ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required