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.


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!