SQL server 2005 - msdb grows huge due to sysxmitqueue table

  • Hi ,

    In SQL server 2005 - msdb database grows huge because sysxmitqueue table do anyone know how to shrink and solve this issue completely with re-occuring ( Is this issue similar to loginqueue)

  • Service broker.... ?

    Qouting Shah_mm from here: "But after I deleted the service broker queue which was not used, it cleaned up automatically. Not suer what triggered that."

    Other Google results seem to confirm this action will do what you want. Seems that the table fills up because the Service Broker has been stopped or disabled and therefore does not get to process the queue


    The systems fine with no users loggged in. Can we keep it that way ?br>

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply