September 2, 2010 at 9:05 am
All:
I need EST for a testing plan that will run DBCC CHECKDB. There are some databases 2-9GB size. Is there just rough idea how long DBCC CHECKDB take for 2,5,9 GB databases?
Thanks
September 2, 2010 at 9:20 am
I don't think any estimate anyone could give would be remotely accurrate. It would entirely depend on the complexity of the data. Lets take two hypothetical situations for example.
there are two databases that are the exact same file size. One contains 4000 tables with simple data. Most tables have few columns and contains nothing more than simple varchar data.
the second database has less than 100 tables but contains several complex datasets with 100+ columns and includes XML fieled types and varchar(max) that is filled to the brim.
these two tables though they are identical file sizes would result in very different times.
the best scenario you could have would be to restore these databases to a test box if possible and then run DBCC against them in the test box.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply