Have you heard about the new Service Broker functionality in SQL Server but don't know where to start with installing, understanding, or troubleshooting it? These links will help you get started.
References
KB Articles:
Case Studies:
Troubleshooting:
· Verify that the service setup, spelling, routes in sys.routes, etc are all correct. Check the SQL Server error log and event logs for any messages. Capture a profiler trace with the Broker events, Query Notifications, Security Broker events, errors/warnings, and RPC/Batch completed events. Query the Broker DMVs and catalog views, especially sys.dm_qn_subscriptions and transmission_status from sys.transmission_queue.
· Verify the database principal has correct permissions, especially
o RECEIVE on QueryNotificationErrorsQueue
o SUBSCRIBE on Query Notification
o SELECT and/or EXECUTE on underlying tables or views involved in the query
· Verify the endpoints don’t use any TCP ports that are in use by any local SQL Server instance or any other application.
· If the queries go across databases, has SET TRUSTWORTHY ON been set with ALTER DATABASE?
· Avoid restoring MSDB from another instance as the GUIDs might not be correct.