DBCC CHECKDB is taking to long

  • I have a database in Simple Model Recovery. We only use this DB to load data from flat files. The full backup runs every Saturday and the differential runs every night (except Saturday).

    This weekend it performed the full backup with no problem at all. Sunday and Monday got an error in that specific database. The Job Process stayed in KILLED/ROLLBACK Status. I Killed the process and it took like 1 hour. My IT guy detected some use memory running. Probably this process, we are not sure.

    Since then, the DB takes awhile to run a simple select statement, even if its only one row set of result.

    I’m running a DBCC CHECKDB to verify that my database is not corrupted or any page damage. The DBCC has been running for 3 hours now. Not process are blocked, nothing else is running except this DBCC, I can do select in the database, but not inserts.

    The database has partition in 2 main tables and contains 25 files/filegroups.

    Is normal for the DBCC to take that long? This is my database sizes;

    database_namedatabase_sizeunallocated space

    Database723242.56 MB667442.68 MB

    reserved data index_sizeunused

    48320328 KB24344824 KB23971160 KB4344 KB

    Any advice?

  • How long will depend on the hardware, but a 700 Gig database will take a while to check. Hours doesn't sound outrageous to me.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • If DBCC CHECKDB is taking longer than usual, there must be something wrong.

    Please wait for CHECKDB to complete.

    Meanwhile check below link.

    http://www.microsoft.com/emea/teched2008/itpro/tv/default.aspx?vid=78

  • should I stop it?

    It has 3:23hours already

  • I would let it run to completion if at all possible.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • MTY-1082557 (12/7/2009)


    should I stop it?

    It has 3:23hours already

    No. Let it run to completion. Stopping it won't cause any problems, but you also won't get any results, essentially wasting the hours that it's been running

    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
  • @MTY-1082557

    Any update, did you resolve the issue. Please post output of CHECKDB

  • Hi all,

    I didnt have any chance to post the results 'cause we are with another issue.

    The CHECKDB never end. It was still a KILL/ROLLBACK process "running". So when we killed the process the CHECKDB stopped.

    We reboot out server and re run the CHECKDB again and only took 5 minutes with no error at all.

    Seems like the KIL/ROLLBACK process was blocking everything else.

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

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