Hi everyone,
I'm planning to run Windows Server 2022 Standard with SQL Server Web 2022 on a NAS High Availability (NAS-HA) setup.
My workload involves disk read/write averaging 30 MBps with peaks up to 1 GBps.
Has anyone tried this configuration?
Any performance issues or considerations?
Is NAS-HA suitable for these I/O demands with SQL Server?
I'd appreciate any insights or experiences.
Thanks!
Hi Jean,
In general, use case using SQL server or DB depend more about latency than throughput.
Nas-ha could match to your use case.
You just have to keep in mind that protocol should be challenge.
In general we see better perf using NFS ( v3 or v4 depending use case ) instead of CIFS.
But you need to test it, it depends about configuration and use case.
You can test Enterprise file storage too, only in NFS, but with better latency than nas-ha.
https://www.ovhcloud.com/en/storage-solutions/enterprise-file-storage/
This service guaranteeing 4,000 IOPS per TB and 64MB/s bandwidth per TB.
Mean with 16TB volume you will be sure to burst to 1Go/s
Regards
File storage team