SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBBC Check on AG


DBBC Check on AG

Author
Message
tony28
tony28
SSCertifiable
SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)

Group: General Forum Members
Points: 6559 Visits: 1188
Hello,

I would like to have question,
how dbbc check works on AG ? should be on all replicas ? or only on primary ?
I am using Ola Hallengren scripts and now is on all replicas, normaly is working without problem, but now I got error problem with memory "There is insufficient memory available in the buffer pool"

It is after failover, before this "secondary" was "primary" and wasnt some problem with memory.

What can be this issue ?

Thanks



How to post data/code on a forum to get the best help: Option 1 / Option 2
Muthukkumaran kaliyamoorthy
Muthukkumaran kaliyamoorthy
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18506 Visits: 5629
CheckDb should be all replica. The memory error you need to capture the data to do further analysis.

Muthukkumaran KaliyamoorthyHelping SQL DBAs and Developers >>>SqlserverBlogForum
Steve Hall
Steve Hall
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18726 Visits: 13516
muthukkumaran Kaliyamoorthy - Thursday, March 14, 2019 4:02 AM
CheckDb should be all replica. The memory error you need to capture the data to do further analysis.

No. You need to check your primary too, because that is the source of the data and also possible source of corruptions.
Brent Ozar has a succinct piece on this.


Steve Hall
Linkedin
Blog Site
Muthukkumaran kaliyamoorthy
Muthukkumaran kaliyamoorthy
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18506 Visits: 5629
BrainDonor - Thursday, March 14, 2019 4:29 AM
muthukkumaran Kaliyamoorthy - Thursday, March 14, 2019 4:02 AM
CheckDb should be all replica. The memory error you need to capture the data to do further analysis.

No. You need to check your primary too, because that is the source of the data and also possible source of corruptions.
Brent Ozar has a succinct piece on this.

That's what I said. We need to run all replicas, if it is a VLDB, we should consider different options and methods.


Muthukkumaran KaliyamoorthyHelping SQL DBAs and Developers >>>SqlserverBlogForum
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search