Script to analyse space usage by your Service Broker
I believe that service broker is one of the best features from SQL server 2005, well along with the xml data type, and I use service broker a lot for messaging between solutions. Over the years it has proven to be extremely reliable; only really stopping because of a poison message or other environment type issue outside the control of the broker.
Service broker itself uses a number of internal tables which it uses to store details regarding conversations and routing, and there are also any … more