dbcc checkDB

• learningguy

  SSChasing Mays

  Points: 615

  More actions

  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,

• sumitagarwal781

  Default port

  Points: 1493

  More actions

  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

• learningguy

  SSChasing Mays

  Points: 615

  More actions

  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?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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