The status of Service Broker is “disabled” on our production server, but as I monitor waits on the server, my highest wait time is always for BROKER_TASK_STOP.
We had Broker running in one iteration of our product, then decided to use Replication instead and we disabled Broker from running.
But, I still see these never-ending waits…
I thought of uninstalling Service Broker, but I’m not sure if SQL 2005 needs some of it’s functionality…plus I’d like to keep the option open for using Service Broker in case we decide to move forward with some work we’re contemplating.
In sp_who2 I see 4 BACKGROUND spids for sa, in master db, with command field of ‘BRKR TASK’ or BRKR EVENT HNDLR’. This is our production server, and I don’t want to kill these if they’re jobs executing for SQL Server (I may have heard the SQL Server uses ServiceBroker technolgies for some internal tasks – is that correct?) BROKER_TASK_STOP accounts for 35% of all my waits…Does everyone running 2005 see these waits? If not, how do you recommend I eliminate them?
Thanks in advance,
Normajean
