Results 1 to 3 of 3

Thread: DBCC CheckDB taking almost 12Hrs

  1. #1
    venakt Tudi Guest

    DBCC CheckDB taking almost 12Hrs

    Hello All!
    The size Database size is 20GB w/4processors and 256 MB RAM
    My DBCC CHECKDB is taking almost 12Hrs.
    Is this Normal?
    Can some one send me the configuration of the server where i can look at mine and compare..
    Venakt Tudi

  2. #2
    Brad Schuermann Guest

    DBCC CheckDB taking almost 12Hrs (reply)

    It sounds a little long, what else is going on at the time of the DBCC. Also do you have any text columns in the DB? If you do the time to run the DBCC will be longer then with out them.

    Brad

    ------------
    venakt Tudi at 6/17/99 1:11:23 PM

    Hello All!
    The size Database size is 20GB w/4processors and 256 MB RAM
    My DBCC CHECKDB is taking almost 12Hrs.
    Is this Normal?
    Can some one send me the configuration of the server where i can look at mine and compare..
    Venakt Tudi

  3. #3
    Craig Guest

    DBCC CheckDB taking almost 12Hrs (reply)

    First off, 256 meg of RAM for a 20 gig server is way short. I run 750 meg of RAM with a 4 gig server and could use more if I could get it.

    Second, put the NO_INDEX clause on the CHECKDB and it will run in half the time I bet. Restore your database somewhere local weekly and run the full DBCC there and not on your Production.


    ------------
    Brad Schuermann at 6/18/99 4:02:30 AM

    It sounds a little long, what else is going on at the time of the DBCC. Also do you have any text columns in the DB? If you do the time to run the DBCC will be longer then with out them.

    Brad

    ------------
    venakt Tudi at 6/17/99 1:11:23 PM

    Hello All!
    The size Database size is 20GB w/4processors and 256 MB RAM
    My DBCC CHECKDB is taking almost 12Hrs.
    Is this Normal?
    Can some one send me the configuration of the server where i can look at mine and compare..
    Venakt Tudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •