Unanswered: SQL server 2012 Enabling service broker keeps CPU busy at 100%
In a customer environment, it was noticed that CPU is at 100% while enabling service broker. the queue has approx 1 million requests. Since CPU is at 100% the application is not usable.
what is the best way to clear all requests?
There are around 1.2 million records in sys.conversation_endpoints "where is_initiator = 1 and far_service = "<MyService>".
I was thinking to do END CONVERSATION for all these messages after disabling the broker queue. Is this advisable?