How important to SQL Server is the speed of the SSD and network latency?
Essentially, how does a cloud SSD of 125MB/sec compare to a Gen 5 SSD which measures 14,000MB/sec? Even if we manage to max out the Premium SSD V2 with 1,250MB, it's still less than 10%.
Also, how does a SQL server running on the same physical server as an app server compare to VMs that may be in the same zone but not on the same machine necessarily?