DBCC is taking ages and killing server performance

Hi Friends, DBCC takes 3 hours on my Secondary Replica where as it takes 10 hours on Primary replica. We are on 2012 AOAG SYNC mode How can i fix this please. Any suggestions ?

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock commented · Sep 06, 2017 at 06:50 AM

Hi, which DBCC command are you referring to?

1 ·

ThomasRushton ♦♦ commented · Sep 06, 2017 at 09:51 AM

When DBCC is running, have a look at the output from sp_WhoIsActive from http://whoisactive.com/ - that'll tell you what the server is waiting for (among other things).

0 ·

rehaan commented · Sep 16, 2017 at 09:16 PM

Thanks Thomas. I will monitor next time when it takes long time and keep you posted

0 ·

bernsteingreg commented · Sep 20, 2017 at 08:11 PM

In case you haven't checked already, see if there is another resource intensive job running at the same time such as an indexing and or statistics. I am also curious about your backups - are t log backups occurring on the primary?

0 ·

rehaan commented · Sep 28, 2017 at 02:51 PM

hi bemsteingreg Yes we have index maintenance job running at the same time and full backups job too. we have log backups running every 15 mins without any issues

0 ·

JohnM commented · Sep 28, 2017 at 03:28 PM

So you're running index maintenance AND DBCC CHECKDB (I'm assuming here since you don't specify which command) at the same time on the primary? A backup would introduce some I/O overhead but should be minimal as it has it's own single worker thread.

0 ·