Solved

Service broker enabled on tempdb and msdb

Posted on 2012-03-21
2
904 Views
Last Modified: 2013-04-25
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
Comment
Question by:yechan
2 Comments
 
LVL 17

Accepted Solution

by:
Barry Cunney earned 350 total points
Comment Utility
Database Mail depends on Service Broker being enabled in msdb
0
 

Expert Comment

by:3alt
Comment Utility
[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 Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
table fragmentation 40 73
SQL 2012 and SQL 2014 always on 9 23
Backup Job question 4 17
SQL query to summarize items per month 5 24
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now