Post reply

DBCC CHeckDB part of my maintenance plan

  • November 8, 2011 at 9:43 am

    #259649

    I am running the DBCC CHECKDB daily before my differential backup job runs (11:30PM). And today I have noticed the below sql in my monitoring table. What is the purpose of this sql? I dont see any blocking but it waits for few ms on BACKUPTHREAD and OLEDB wait types.

    DECLARE @BlobEater VARBINARY(8000)

    SELECT @BlobEater = CheckIndex (ROWSET_COLUMN_FACT_BLOB)

    FROM { IRowset 0xF05186D606000000 }

    GROUP BY ROWSET_COLUMN_FACT_KEY >> WITH ORDER BY

    ROWSET_COLUMN_FACT_KEY, ROWSET_COLUMN_SLOT_ID, ROWSET_COLUMN_COMBINED_ID,

    ROWSET_COLUMN_FACT_BLOB OPTION (ORDER GROUP)

    Thanks for your help.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • November 8, 2011 at 9:53 am

    #1404681

    That's the code that is run internally by checkdb().

    Both checkdb and backup are real heavy on the disks so it's quite likely that they are slowing each other down (not blocking).

  • November 8, 2011 at 9:56 am

    #1404684

    Shd i still consider it a best practice to have the checkdb run before my differential backup that runs every night (except friday night). I am running the checkdb even before a full backup that runs on a friday night.

    Thanks Ninja

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • November 8, 2011 at 10:00 am

    #1404686

    Sapen (11/8/2011)

    Shd i still consider it a best practice to have the checkdb run before my differential backup that runs every night (except friday night). I am running the checkdb even before a full backup that runs on a friday night.

    Thanks Ninja

    Yes it's best practice. I actually have the luxury to run it more than once daily here (almost overkill the way I'm setup).

    The other way to do this is running checkdb after doing the test restore. So you don't have to suck up the ressources of the prod server. Then run the delete old backups jobs after you've validated the new backup.

  • November 8, 2011 at 10:46 am

    #1404721

    Thanks for the info ninja

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

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

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