Forum Discussion
bmcminfra
Aug 24, 2017Copper Contributor
Storage Replica Async Performance
Should Storage Replica in async replication mode impact write performance? All of my testing has shown that it does (I am using dedicated data and log NVMe drives). In sync mode write performance is...
NedPyle
Aug 24, 2017Former Employee
Yes, data writes still have to go through the local log. If the local
log volume is slow, or at least, same/slower than data volume, perf will
suffer even without the secondary server trip and network. We are
working on a much improved log with much better perf to minimize this;
coming in a later release after RS3 - it is our top priority.
rhirani
Feb 11, 2019Copper Contributor
Hi, I am doing a POC using SR (sync mode) for a new SQL stretch cluster. With SR enabled the IOPs from diskspd runs drops from 1064 I/O per s, to just 125. is that normal? such a large drop in performance. I have tried both sync and async modes and both give similar diskspd results.
I'm using disks from an all flash SAN via FC, so shouldn't it be going as fast as the SSD storage can go?