Forum Discussion
Problems with SQL server job, the execution blocks other applications
Hello, 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 ...
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.
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!
thanks for your answer, I will try that!