So is there something I'm supposed to configure to allow activation to fire after a cluster failover. We have had three where I have noticed that activation does not automatically fire back up. i have to alter the queue to get it going. None of the values on sys.service_queues imply that is disabled, but messages just keep stacking up into the queue and are not being dealt with. Once I alter the queue to turn activation on; everything takes off and starts working normaly.
Obviously, this is less than desireable for an environment that requires High availability.
Regards
After failover when the queue is not being activated:
1. Do you see any Broker:Activation events in the profiler when messages are enqueued?
2. What is the state of the queue monitor? (sys.dm_broker_queue_monitors)
3. Are there any failures reported in the ERRORLOG?
Thanks,
Rushi
