We plan to incorporate Log Shipping for basic disaster recovery with reporting needs. Server A Source Database will log ship to Server B database. We will conduct log shipping every few hours.
Looking at setup, there is an option for "Use a Monitor Server Instance". Currently we do not have budget/time resources to setup third monitor server.
In that case, what is the second best recommendation for Monitor Server to store status/history of log shipping activities? On the source primary server or destination server ?
We are mildly concerned about performance/activity of Source Server. Sometimes CPU can get moderate high. So I think Destination Server is better option. Also, in case primary server fails, we have status/history of when last time transaction logs backup/shipped/restored. If monitor was on Primary server failed, we would not know this.
I am trying to research if there is any missing reason to place monitoring on Source Server.