question

rehaan avatar image
rehaan asked

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 ?
performancedbcccpu
6 comments
10 |1200 characters needed characters left characters exceeded

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

Hi, which DBCC command are you referring to?
1 Like 1 ·
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 Likes 0 ·
Thanks Thomas. I will monitor next time when it takes long time and keep you posted
0 Likes 0 ·
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 Likes 0 ·
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 Likes 0 ·
Show more comments

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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