Post reply

What is the best way to run dbcc checkdb on a server sothat it put least CPU overhead?

  • May 5, 2004 at 4:50 am

    #85319

    What is the best way to run dbcc checkdb on a server which has more number of databases sothat CPU overhaed should not be too high?

    I need to run it daily at present. I am using cursor but it utilizes more cpu overhead.

    Thanks in advance

    --sntiwary

  • May 5, 2004 at 5:51 am

    #505283

    There is an option in job schedule Start whenever the CPU(s) become idle. It also

    depends how long the job runs.

  • May 5, 2004 at 9:23 am

    #505323

    the jobs takes 5-10 mintutes but simultaneoulsy it should run daily at particular time. Any suggestions will be appreciated.

    --sntiwary

  • May 6, 2004 at 3:16 am

    #505430

    Hi,

    This is an abstract from the BOL:

    Recommendations for Good DBCC Performance

    1. Run CHECKDB when the system usage is low.

    2. Be sure that you are not performing other disk I/O operations, such as disk backups.

    3. Place tempdb on a separate disk system or a fast disk subsystem.

    4. Allow enough room for tempdb to expand on the drive. Use DBCC with ESTIMATE ONLY to estimate how much space will be needed for tempdb.

    5. Avoid running CPU-intensive queries or batch jobs.

    6. Reduce active transactions while a DBCC command is running.

    7. Use the NO_INFOMSGS option to reduce processing and tempdb usage significantly.

    Hope this helps

Viewing 4 posts - 1 through 3 (of 3 total)

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