Service broker enabled on tempdb and msdb

yechan
yechan used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Mail depends on Service Broker being enabled in msdb

Commented:
[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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial