Question

When does BROKER_TO_FLUSH wait type event occur?

(a) When the Service Broker queue task handler tries to shut down the task

(b) When the Service Broker transmitter is waiting for work

(c) When the Service Broker lazy flusher flushes the in-memory transmission objects to a work table

(d) All of the mentioned

The question was posed to me during an interview.

I would like to ask this question from Wait States in portion Monitoring and Auditing of SQL Server

Answer 1

Correct answer is (c) When the Service Broker lazy flusher flushes the in-memory transmission objects to a work table

The best I can explain: BROKER_SHUTDOWN tries to shut down the task.