When restoring SQL Server 2008R2 DWH-DBs I always gave some memory back to the OS to speed it up.
Now I got performance problems restoring to SQLServer 2016:
Where does the restore buffer come from?
SQL Memory Manager I guess?
Does the SQL Server need more memory or the OS to restore big files over the network?
Backup is compressed and consist of 14 files each larger 2,5 TB => DBsize is lager 100 TB.
Parameter:
MAXTRANSFERSIZE = 4194300, BUFFERCOUNT = 5000, BLOCKSIZE default.
INSTANT FILE INITIALIZATION on, Network SMB, Server 2012R2
