My production database suffers from a large Service Broker message queue. It is around 2 million. I would like to decrease it as small as possible.
I have tried
dbcc dbreindex('sys.queue_messages_245995913') from the DAC connection, based on the advice given by Remus Rusanu here.
But when I look at the queue properties, the queue size remains the same.