Post reply

Can't remove rows from distribution database

  • November 10, 2009 at 10:11 am

    #211955

    Hi

    My distribution databas 70GB and MSrepl_commands growing by 25 millions a day. The cleanup job runs, but eventually times out. Plus, it looks like it's not actually doing anything. It runs every 10mins.

    Anyone have any advice?

    Andy

  • November 10, 2009 at 12:02 pm

    #1077430

    ever tried changing your cleanup to specify smaller portions?

    delete top 1000 from....

    and make it run every 10 mins as well.

    instead of

    delete from table...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

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

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