Archives / 2012 / April
  • 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 …