主要和次要GEO之间的同步时间 [英] Sync time between primary and secondary GEO

问题描述

我们正在运行具有1750 DTU的p11 Azure SQL数据库.该数据库具有一个GEO副本.我们会将一些读取任务转移给GEO.但是我们想知道GEO的准确性如何.在主数据库和地理位置上进行写入之间是否存在明显的延迟?

We are running a p11 Azure SQL database with 1750 DTU. This database has a GEO replica. We would to offload some read tasks to the GEO. But we are wondering how accurate the GEO is. Is there a significant delay between a write on the primary and the geo?

问候，

Tarik

Tarik

推荐答案

你好，

Hello,

The following query will let you know what is the replication lag:

 link_guid

 , partner_server

 , last_replication

 , replication_lag_sec

 FROM sys.dm_geo_replication_link_status;

Base on that replication_lag_sec column you can evaluate "how accurate" the Geo is.

Hope this helps.

Regards,

SQLCoffee.com

Alberto Morillo
SQLCoffee.com

这篇关于主要和次要GEO之间的同步时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！