What is Broker EventHandler Wait Event?
I keep seeing this wait stat “Broker_EventHandler” in the SQL Server wait stats with high duration times. What is Broker_Eventhandler? Why does it have high wait times?

Answer Question   |  March 23, 2011  7:13 PM
Event handlers, Service Broker, SQL, SQL Server, SQL Server 2008

Should I enable service broker on SQL Server 2008?
I am not too familiar with service broker, should I enable it on all databases on my production server? If yes why?

Answer Question   |  March 23, 2011  7:05 PM
Service Broker, SQL, SQL Server, SQL Server 2008, SQL Server Enterprise Edition