Service Broker freezes almost every night.


  • Hellow!


    I have got a main SQL Server with a database and many other SQL servers (~ 1500). From morning till evening it’s ok, but in the night Service Broker freezes. In this case sys.transmission_queue

    has many rows where transmission_status is empty. In the night 90% of SQL Servers are turned off.

    Why so?

    Thank you very much.

    Main server: Microsoft SQL Server 2012 (SP1) - 11.0.3368.0 (X64) 


    Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64)    or

    Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (Intel X86) 

    • Edited by IGBeaver Friday, January 03, 2014 7:07 AM
    Friday, January 03, 2014 6:58 AM

All replies