Microsoft SQL Server 2016 (SP1-CU6) (KB4037354) - 13.0.4457.0 (X64)
- The database's total size is 450 GB, from which 350GB is inital filestream size
- The average picture size is around 200Kb, the total number is around 118,000, and same number of filestream files.
- The database configuration has 1 filestream file
I have two virtual machines (with IFI enabled on both):
The first has read/write of 30MB/s, the second has 300MB/s
The backup on the first VM takes around 4 hours, restore takes around 40 hours
- Restoring on the second VM takes around 4 hours
The question is, why is SQL server on both VMs not using max IO speed of disks when it is clearly available?
The only wait types during both restores are