I have a sqlserver 2016 always-on with one primary and one secondary database. However I got nothing when I query the secondary database right after I get confirmation from primary database that insert is done. So I think this is because primary db confirm the transaction after log received at secondary db, however secondary database takes some time to write record into db after it received the log from primary db. So there are definitely some delay between primary and secondary db, question is how can I query secondary db instantly after I get confirmation from primary db?
Asked
Active
Viewed 749 times
0
-
anyone can help?? I learn about pear-to-pear replication, however, document still said that it is still problematic for latest change to be seen immediately. – Long Nov 15 '17 at 02:41
-
did I come to the wrong place? why nobody answer this? – Long Nov 15 '17 at 08:26
-
pear to pear or peer-to-peer ? also yes it always takes time to replicate data from primary node to secondary so if you're executing write query (which will go to primary) now these changes will take some time to reflect in secondary replica's depending on various factors such as volume of data, network bandwidth etc. – Mahesh Karia Dec 05 '17 at 08:59