none
sys.dm_broker_queue_monitors missing information after cluster failover

    Question

  • where does sys.dm_broker_queue_monitors get its information from? I see that it's created by

    CREATE VIEW sys.dm_broker_queue_monitors AS
        SELECT * FROM OpenRowset (TABLE SBQUEUEMONITORS)

    but can't seem to find information on SBQUEUEMONITORS. What is it?

    On a more practical level. The reason why I am looking into this is because when I failover a SQL server 2008 SP3 cluster all entries associated with the user database disappear from this view. sys.service_queues shows that activation is on, but activation SP doesn't react to new messages. only when I turn the activation off and on with alter queue does the system view get re-populated and activation works again.

    What could be the cause of this behavior?

    Thanks.


    Mordechai Danielov

    Friday, August 09, 2013 9:35 AM

All replies