Write Operations on primary database latency issue

Question

I have a Azure SQL database replicated to two regions. As per azure documentation secondary databases are read only. In that case all my write operations will be directed to primary. Will that cause latency issue? because my regions are not closer to each other. If so what to do to improve write operations latency.

Answer 1

@Neela Thank you for reaching out.

In addition to Luis Arias's answer above.

Yes, there will be latency across regions and as distance goes up so will latency. To improve latency consider picking a region that’s closer to primary and if needed explore this stored procedure but the tradeoff will be between performance & latency.

Hope that helps.

Regards,

Oury

Answer 2

Hi please follow this thread https://learn.microsoft.com/en-us/answers/questions/1295981/data-latency-between-primary-database-and-named-re

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

Regards,

Luis