• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1043
  • Last Modified:

Service broker enabled on tempdb and msdb

When looking at the wait types on sql server, I noticed that BROKER_EVENTHANDLER accounts for about 65% of all the waits.  The only two databases that have Service Broker enabled are tempdb and msdb databases.  Should those two be disabled in order to reduce the wait time for BROKER_EVENTHANDLER?
1 Solution
Barry CunneyCommented:
Database Mail depends on Service Broker being enabled in msdb
[from msdn]
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail.
Event Notifications, Query Notifications, SqlDependency, SQL database mail etc. work with Service Broker functionality.
You need Service Broker enabled on msdb.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now