Post reply

DBCC TABLE CHECK

  • March 1, 2012 at 9:19 am

    #265375

    I always see there are proceses in SQL about "DBCC TABLE CHECK"

    1. I am trying to find out what trigger this process

    2. is it the same or it come from DBCC check DB?

    Thanks,

  • March 1, 2012 at 9:27 am

    #1453722

    DBCC checkdb is executing dbcc cehcktable as this is a part of consistency checking opertaion. you can also run only dbcc checktable for checking on table level.

    java

  • March 1, 2012 at 9:27 am

    #1453723

    That's part of checkDB.

    Nothing 'triggers' it. It happens when a user or job runs DBCC CheckTable or DBCC CheckDB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 1, 2012 at 9:44 am

    #1453740

    Thanks for all the input., that what I thought about DBCC check TABLE is from DBCC CHECK DB. There was no user that had privilege to run DBCC check DB on this database and I have no DBCC check DB job shceduled.

    Do you know the way to trace who and why it run?

    Thanks again

  • March 1, 2012 at 9:46 am

    #1453742

    A normal profiler trace should do it, or look in the default trace (should be caught under Audit DBCC Event)

    Someone or something is running either CheckDB or CheckTable if you see that in running sessions, checkDB does not ever run by itself and nothing inside SQL will trigger it.

    p.s. You need to do something about not having a regular checkDB job.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 1, 2012 at 9:56 am

    #1453749

    I am planning to have checkDB weeekly but not running every 2-3 hours.

  • March 1, 2012 at 9:57 am

    #1453750

    Let me ask you this... Is this database accessed by a 3rd party application? The application itself may be sending this command.

    Jared
    CE - Microsoft

  • August 28, 2012 at 8:04 am

    #1530831

    In my environ, dbcc table check occurs, I believe due to backup option "checksum" which causes a page checksum calculation on every table's data prior to backup.

  • August 28, 2012 at 8:53 am

    #1530865

    Eric Stimpson (8/28/2012)

    In my environ, dbcc table check occurs, I believe due to backup option "checksum" which causes a page checksum calculation on every table's data prior to backup.

    Checksum and checktable are two different things. Backups don't run checktable or checkDB.

    The backup with checksum recalculates the checksums on each page backed up and then cacluates a checksum over the backup file.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 9 posts - 1 through 8 (of 8 total)

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