Post reply

SQL server 2005 - msdb grows huge due to sysxmitqueue table

  • June 11, 2008 at 11:55 am

    #122125

    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)

  • June 11, 2008 at 6:58 pm

    #827612

    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