SQL Server Performance

how can i schedule DBCC CHECKDB to run automatical

Discussion in 'Performance Tuning for DBAs' started by starocean, Dec 19, 2005.

  1. starocean New Member

    Hi everybody, is there any way which I can schedule DBCC CHECKDB to run every hour besides using the maintenance plan?

    Thanks.
    starocean, Dec 19, 2005
    #2

  2. FrankKalis Moderator

    FrankKalis, Dec 19, 2005
    #2

  3. satya Moderator

    You can create a fresh job and under the Steps pane for command line submit the DBCC CHECKDB by selecting the required database.

    Refer to the SQL server books online about scheduling jobs.
    BTW why do you want to run this DBCC statement every hour?

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Dec 19, 2005
    #2

  4. Luis Martin Moderator

    Even using Maintenance plan, you can run it every hour.

    Now, like Satya said, why?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Dec 19, 2005
    #2

  5. starocean New Member

    quote:Originally posted by LuisMartin

    Even using Maintenance plan, you can run it every hour.

    Now, like Satya said, why?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.





    i am backing up the transaction log every hour, just thinking about check the database before backing up the log. Will this be a good practice?
    starocean, Dec 20, 2005
    #2

  6. FrankKalis Moderator

    FrankKalis, Dec 21, 2005
    #2

  7. satya Moderator

    Yes and you are contributing more space to transaction log and that can take longer time to finish the transaction lgo backup. If you want to verify the backup you can do so by restoring them on to a standby server which can work as a HOT standby in case of any failures with current production.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Dec 21, 2005
    #2

  8. Luis Martin Moderator

    Is not a good practice, also impact performance.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Dec 21, 2005
    #2

  9. alimmia New Member

    Just create a job with a step (DBCC CHECKDB) for each database. Then, schedule the job as you wish. This is the simplest approach.

    Alim
    alimmia, Dec 27, 2005
    #2

Share This Page