We have an OLTP application that heavily uses service broker to perform many of the more common tasks. One of our biggest (if not the biggest) clients we have is having an issue with service broker where it is constantly encountering deadlock errors
because of the inordinate amount of work it is trying to do. We're starting to look in to ways to better optimize use of service broker with our applicaiton. We've considered raising the MAX_QUEUE_READERS setting for the queues that have the greatest
number of messages (and most number of deadlocks) to mitigate the issue. What are some other ways in which we could tweak service broker to boost performance?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.