In order to improve performance of our SQL Server backups we backup to multiple backup files.
- On most blog posts about this topic they say to use multiple backup files but, is there a point where you can have too many files that instead of improving performance you get a worse performance due to the big amount of threads waiting?
- Is there any general recommendation based on, for example, number of
cores in the server? To be more specific, one of our server shows
BACKUPBUFFERas top 2 offenders wait stats.
We're backing up a big DB (several TBs) using 10 backup files, but I noticed server has only 4 cores and 32 GBs of RAM. I have changed the number of backup files to use 4 backup files instead. I'll see how it goes next week in the next backup cycle, but meanwhile I was trying to find any recommendations on how many backup files to use depending on the server specifications.