Select Page

SQL Agent Hot Spot

The Quick Scan report in Database Health Monitor detects when there are hot spots in scheduled jobs for the SQL Server Agent. A hot spot is when there are several jobs scheduled to start at exactly the same time. Having several jobs scheduled for the same time can put excess load on the SQL Server when they all kick off at the same time.

This can be resolved by moving the jobs around. Sometimes all it takes is sliding some of them a few minutes forward or backward on the schedule to clear up the hot spot.