Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vdavid70
Yak Posting Veteran
67 Posts |
 Posted - 2006-07-06 : 11:34:13
|
| Hello,Please correct me if i am wrong. I assume that the larger a database grows the longer time it will take for a dbcc checkdb procedure to run.secondly what could be the possible reason for a dbcc checkdb procedure to run longer on the same database for example it takes 9mins to run on a 5gig database and two weeks later the database is still the same size but it took the checkdb procedure 12 mins to do the same thingWhat could be the reason for this and what is the possible solution. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-07-06 : 11:45:09
|
| may be because of database fragmentation...since after series of operations data size may remain same but space allocations may be differentHarsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
arshadkhwaja
Starting Member
5 Posts |
Posted - 2006-07-08 : 03:32:43
|
| U can chk for tempDB as well restart the service for once |
|
|
|
|
|
|
DBCC CHECKDB