As you might know already if you’re creating backups and also monitoring your server’s resources you have seen that the CPU is used intensively during the compression phase of the backup operation.

Find out in this article how to set 7zip CPU priority to LOW.

Set 7zip CPU priority to LOW

Unfortunately, there is no way to set 7zip CPU priority to low from SQLBackupAndFTP, but there is a workaround for this.

If you already have a job created in SQLBackupAndFTP and you want it to run under low priority mode in terms of CPU usage, all you have to do is create a Windows batch file (.bat extension) where you’re going to call the SQLBackupAndFTP job.

When calling the job you’ll specify some parameters which will set the priority of the process to low. Just follow the below example to set 7zip CPU priority to low:

start "Job 2" /low 
"C:\Program Files (x86)\SQLBackupAndFTP\SQLBackupAndFTP.exe" -r 
"C:\Users\Administrator\Desktop\DB Rotation.jobx