October 19, 2016 at 5:31 am
Hi Everybody,
We have a Database whose size is around 76 GB. DBCC CHECKDB is taking around 15 hours to complete and the step at which it takes a long long time is DBCC SSB CHECK.
Has anybody encountered such issues?
Looking forward for some help on this case.
With Thanks,
Satnam
October 19, 2016 at 6:10 am
I am not sure what your issue is but this happened to me, it eventually finished (with corruption). All I can think of is that it was doing a "deep-dive" hence why it was taking longer than normal.
I would suggest to let it complete.
October 19, 2016 at 8:39 am
satnam.singh 44358 (10/19/2016)
Hi Everybody,We have a Database whose size is around 76 GB. DBCC CHECKDB is taking around 15 hours to complete and the step at which it takes a long long time is DBCC SSB CHECK.
Has anybody encountered such issues?
Looking forward for some help on this case.
With Thanks,
Satnam
Are you completely patched up? Some significant shortcomings with CHECKDB have been found and fixed over the last year+. Also, find and read Argenis Fernandez/Paul Randal posts about CHECKDB issues/performance findings/fixes. There are things you can do and issues you can have in your database that can crush the server.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply