Problems with SQL server job, the execution blocks other applications

Copper Contributor


We have a problem with a database backup job. The job creates a complete backup of an approx. 100GB database. The problem is that when this job is executed, so many resources seem to be tied up that other applications are slowed down.


Is there a way to reduce or scale the resources of a SQL Server Agent job?


Thanks for anwers!

2 Replies
Yes, there are several strategies :
Schedule backups during off-peak hours to minimize impact.
Limit resource usage by adjusting "Max Degree of Parallelism" and "Max Server Memory" settings.
Throttle backup job to control resource consumption.
Enable compression and encryption to reduce backup size and network traffic.
Optimize backup settings for performance.
Continuously monitor and adjust settings as needed.
Hi Fatima,
thanks for your answer, I will try that!