Aug 24 2017
09:19 AM
- last edited on
Apr 15 2021
11:31 AM
by
TechCommunityAP
Aug 24 2017
09:19 AM
- last edited on
Apr 15 2021
11:31 AM
by
TechCommunityAP
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 expected to suffer but in async mode writes should ACK immediately once written to the local server’s disk. I had opened a MS support case and they did not find anything wrong with my config, but they can’t confirm or deny if this is expected behavior.
Aug 24 2017 10:58 AM
Dec 14 2018 09:06 AM
I'm testing SR Async on Windows Server 2019 1809 and there is still a significant write penalty when Storage Replica is enabled. I'm using a pair of NVMe drives (simple volume) for my log that can sustain >3.5GB/s 4K write performance. My data volume gets ~1.6GB/s 4K sequential writes and 174MB/s random before SR is enabled, but only 700MB/s seq and 29MB/s random writes after SR is enabled.
Are there any details on how SR log performance was improved vs. Server 2016?
Feb 11 2019 05:58 AM
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?
Feb 11 2019 08:31 AM
If you enable consistency groups, it may decrease replication and write Input/Output performance.
The best practice at this case is maintain as few disks as possible in same replication group. 2:1 or 3:1 (data disks : SR log disk) it's a good ratio.
Ref.: https://docs.microsoft.com/en-us/powershell/module/storagereplica/new-srgroup?view=win10-ps