March 14, 2019 at 3:17 am
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
March 14, 2019 at 4:02 am
CheckDb should be all replica. The memory error you need to capture the data to do further analysis.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
March 14, 2019 at 4:29 am
muthukkumaran Kaliyamoorthy - Thursday, March 14, 2019 4:02 AMCheckDb 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.
March 15, 2019 at 1:17 am
BrainDonor - Thursday, March 14, 2019 4:29 AMmuthukkumaran Kaliyamoorthy - Thursday, March 14, 2019 4:02 AMCheckDb 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 Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply