CODEWITHSUNDEEP
sql-server
Bashar Abu Shamaa
Bashar Abu Shamaa

Reputation: 2029

Does the SQL Server Agent affect the performance of SQL Server?

Does the SQL Server Agent affect the performance of SQL Server?

Do I need to stop it to increase SQL Server speed!

If yes, please give me more details

Upvotes: 0

Views: 697

Answers (1)

Taz
Taz

Reputation: 1315

The SQL Server Agent is a service which executes any jobs you have configured on the server. It will not inherently affect performance itself, as it's not running most of the time.

When it runs a job, the performance hit will be identical to if you were running the items in the job yourself.

If you were to disable it, you wouldn't be able to run any jobs. Probably not a great idea.

Upvotes: 3

Related Questions