SQL Server Performance Tuning

How Can You Find the SQL Server Jobs That Start Simultaneously?

Updated October 29, 20252 min read

SQL Server jobs starting at once: four alarm clocks ringing around Ploom

Why should you care about them?

Multiple SQL Server Agent jobs are configured to start simultaneously, which will not perform as fast as if jobs did not overlap.

Your SQL Server may be under heavy load for short bursts of time.

How can I find the SQL Server Agent jobs that start simultaneously?

You can use the script below to list all SQL Server Agent jobs starting at precisely the same time.

T-SQL
SELECT j.name AS JobName
	,j.description AS JobDescription
	,a.start_execution_date AS JobStartExecutionDate
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobactivity a ON j.job_id = a.job_id
WHERE j.enabled = 1
	AND a.start_execution_date IN (
		SELECT start_execution_date
		FROM msdb.dbo.sysjobactivity
		GROUP BY start_execution_date
		HAVING COUNT(*) > 1
		)
Figure 1 - SQL Server Agent jobs starting simultaneously
Figure 1 - SQL Server Agent jobs starting simultaneously

How to fix them?

  • Spread job execution by tweaking the job schedules.

More information

Check Red9's SQL Server Services

SQL Server Consulting

Perfect for one-time projects like SQL migrations or upgrades, and short-term fixes such as performance issues or SQL remediation.

Discover More ➜

SQL Server Managed Services

Continuous SQL support, proactive monitoring, and expert DBA help with one predictable monthly fee.

Discover More ➜

Emergency SQL Support

Take the stress out of emergencies with immediate access to a SQL Server Sr. DBA 24x7x365

Discover More ➜

Explore All Services ➜