Post reply

DB maintenance after strong ''delete'' operation - Help

  • July 2, 2006 at 4:12 pm

    #173143

    I manage a large database with more than 500 tables.

    A frequent operation is to delete lots of record from some tables (records that are old).

    This is performed once a week.

    My question is:

    What of kind of maintenance is better run after this heavy operation (Delete); I have planned: DBREINDEX, UPDATE STATISTICS, DBCC SHRINKFILE.

    Do you suggest to add others operation for DB maintenance like:

    DBCC INDEXDEFRAG

    Others type of maintenance?

    Thank

  • July 3, 2006 at 4:40 am

    #647156

    Hi, I think the commands you are using are quite complete for your operation. I would rather consider using DBCC INDEXDEFRAG if you want to retain the indexes during defragmentation, otherwise you will drop them within the command DBCC REINDEX. This will cost you performance during the rebuild of the index.

    HTH, Jens Suessmeyer.

    ---

    http://www.sqlserver2005.de

    ---

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

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