I wrote a fairly simple script that creates in a periodic interval a backup of our DBs, switching automatically into differential in case a full backup already exists.
This runs great on my system. A 4.5 GB database takes around 10-20 seconds to perform the first full backup. However, testing the same DB on another system took over 8 minutes to complete with the same operation. I was expecting slightly worse performance since that system is not as beefy as mine, but not such a massive difference.
Both are running SQL Server 2014.
My system is a Ryzen 5800x (8c/16t), 32GB of RAM and only has M.2 drives with a peak 4GB/s write speed.
The other system is an Intel i5 4460 (4c/4t), 8GB of RAM and uses an SSD with peak 500MB/s write speed.
As you can see it's fairly justifiable that the Intel rig is going to be slower than the AMD rig based on the specifications, but that much slower?
What are the hardware specifications I should care about the most when it comes to optimizing speed for such operations?
I tried finding a viable source online that tackles it, but wasn't successful so I'm asking what you people think.
Here is the query I am currently using on both systems:
BACKUP DATABASE [DBname]
TO DISK = N'C:\tmp\DBname.bak'
NAME = N'DBname-Full Database Backup',
STATS = 10;