• Hello,

    as Kevin said your DELETE instruction lacks on a WHERE clause, I suppose you coded something like

    DELETE TOP 3000 FROM table WHERE too_old_record

    Do you need to run this delete process every few minutes?. Maybe you can schedule it to a point in time with few activity and execute it daily or weekly, avoiding run it on stressed working hours.

    Francesc