Benefits of DBCC Check DB and performance

• mohan.bndr

  SSCrazy

  Points: 2360

  More actions

  August 29, 2013 at 2:33 am

  #1645885

  GilaMonster (8/20/2013)

  ---

  Grant Fritchey (8/20/2013)

  ---

  I thought the internal/hidden snapshot was a different critter than the snapshots we create. But, hey, happy to be wrong.

  No, the same thing, same behaviour, same mechanics.

  The only difference with the CheckDB snapshot is that it's created on all editions (only on Enterprise can you create an explicit snapshot) and it puts the snapshot files into NTFS alternate streams.

  Thanks for understanding to get the Checkdb implementations with the snapshots. But here one more thing , will it DBCC Checkdb work on standard edition as i am not able to run DBCC Checkdb against database and the drive also having sufficient free space for datafile. Will it DBCC Checkdb creates snapshot in standard edition ? and Will it be possible to create snapshot by manually in standard edition?.... Please advise !

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  August 29, 2013 at 2:54 am

  #1645889

  Yes, checkDB works fine on Standard Edition, and all other editions. It does create the hidden snapshot on all editions.

  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

• HanShi

  SSC-Dedicated

  Points: 33519

  More actions

  August 29, 2013 at 3:14 am

  #1645895

  mohan.bndr (8/29/2013)

  ---

  ... as i am not able to run DBCC Checkdb against database and the drive also having sufficient free space for datafile....

  What is the error message you get when you execute the CHECKDB command?

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **