dbcc repair_rebuild

• atulyan.aries

  SSCrazy

  Points: 2020

  More actions

  December 11, 2018 at 9:00 pm

  #416549

  I ran the above dbcc command and using sp_who2 to check status, its showing as suspended state
  Please let me know if I can kill the process and restart it

  Thanks

• muthukkumaran Kaliyamoorthy

  SSCoach

  Points: 19026

  More actions

  December 12, 2018 at 1:06 am

  #2016066

  atulyan.aries - Tuesday, December 11, 2018 9:00 PM

  I ran the above dbcc command and using sp_who2 to check status, its showing as suspended state
  Please let me know if I can kill the process and restart it

  Thanks

  Is there any corruption with the database? The suspended sate can be many reason, when the session lock and hold for the activity.

  Muthukkumaran Kaliyamoorthy
  https://www.sqlserverblogforum.com/