Post reply

dbcc checkDB

  • February 29, 2012 at 9:39 am

    #256744

    Is there a way for me to find out which trigger "dbcc checkDB" to run on my SQL instance? Based from the log, I see dbcc checkDB running every 2-3 hrs but I have no clue what triggers it to run.

    Thanks all,

  • February 29, 2012 at 9:42 am

    #1453254

    Check any maintenance job might be running the dbcc check db . IF execution the time is fixed then run a trace findout which session is executing this.

    java

  • February 29, 2012 at 10:17 am

    #1453287

    when I run sp_who, I found multiple processes with the same spid running DBCC CHECK TABLE (some of the processes are "suspended" and some are "runnable", I should be able to just kill the spid, right?

  • February 29, 2012 at 11:08 am

    #1453316

    Nothing will trigger a checkDB. The only way a checkDB could be running is if it's been run by a user or run from a job.

    You can kill a running checkDB, but you do need to run it sometime so if you eliminate this job, you need to add one in yourself to run checkDB on a regular basis (daily or weekly)

    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 4 posts - 1 through 3 (of 3 total)

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