We have HA setup and we are finding that the redo thread falls behind.
This tends to happen when there are large reporting workloads run against our secondary synchronous node.
Are there any options besides just "run fewer queries against the other node"?
If it was blocking we could address a specific query, but there is no blocking. We just notice that data transfer ramps up and sometimes replication falls behind during this heavy usage.
I don't really like MSFT's suggestions of just throttling queries, then I have SQL server I am paying for sitting idle.
Is there nothing that can be done to allow the redo thread to keep doing its thing? Make it a higher priority I suppose? *Set the governor to only limit queries IF the redo thread if wanting more IO?