Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1021
  • 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?
0
yechan
Asked:
yechan
1 Solution
 
Barry CunneyCommented:
Database Mail depends on Service Broker being enabled in msdb
0
 
3altCommented:
[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.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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