Forum Discussion

EMGAutomation's avatar
EMGAutomation
Copper Contributor
Mar 04, 2024

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 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!

  • Harrum_Fatima's avatar
    Harrum_Fatima
    Copper Contributor
    Mar 10, 2024
    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.

Resources