We are daily copying 100+ tables/ data between production cluster and DR cluster. these tables are growing 0.5-1% daily.
The tables that used to take 5 mins few months back are now taking 15 minutes to copy.
We understand volume growth can cause performance issues but not to this drastic extend. Collectively, this is causing lot of delay.
Copying entire database is now taking 3-4 more hours
Can you please suggest how can we improve performance of the copy operation