We are running GG for SQL Server on a OCI VM. This is connecting to an on-premisis SQL Server instance. Initial sync and continuous replication works perfectly with most tables. We are running into issues when the tables have LOB columns.
We are experiencing extreme delays. It has been running for 18 hours and has extracted only 700k rows. We also have OCI GG working with Oracle source with LOB columns, we have no issues. 1.3M rows loaded in 20 minutes.
Network is not an issue as large tables without LOB columns from on-prem SQL Server to trail files on VM in OCI runs pretty quickly.
Any suggestions on what could be going wrong here is highly appreciated.