patternsqlMinor
DBCC CheckDb on Secondary Asynchronous Replica
Viewed 0 times
asynchronousreplicadbccsecondarycheckdb
Problem
Can I run Ola Hallengren's CheckDB job on a Secondary Asynchronous Replica (DR) that is readable during business hours? Currently the Asynchronous Replica is not readable...
I have a primary server that is Live and I am doing a CheckDB on a secondary server during business hours / off hours.
- First question is if it is possible.
- Secondly, is it safe?
I have a primary server that is Live and I am doing a CheckDB on a secondary server during business hours / off hours.
Solution
Can I run Ola Hallengren CheckDb job on a Secondary Asynchronous Replica (DR) that is readable during business hours?
Sure, assuming the routine doesn't try to update any command or history tables in that database (since it's read-only).
... and secondly if is safe as I have a primary server that is Live and I am doing a checkdb on a secondary during business hours/ off hours.
Much like sp_BlitzErik has stated, we can't tell you if it's "safe". This is going to depend on a host of factors such as disk space, redo queue size, send queue size on the primary, memory, current load, etc. Your best bet is to try it and see if you have no other metrics to go by - if people complain, you have your answer. If the website goes down, you have your answer. If no one says a word and everything goes well - you have your answer.
Sure, assuming the routine doesn't try to update any command or history tables in that database (since it's read-only).
... and secondly if is safe as I have a primary server that is Live and I am doing a checkdb on a secondary during business hours/ off hours.
Much like sp_BlitzErik has stated, we can't tell you if it's "safe". This is going to depend on a host of factors such as disk space, redo queue size, send queue size on the primary, memory, current load, etc. Your best bet is to try it and see if you have no other metrics to go by - if people complain, you have your answer. If the website goes down, you have your answer. If no one says a word and everything goes well - you have your answer.
Context
StackExchange Database Administrators Q#217419, answer score: 8
Revisions (0)
No revisions yet.