SQL SERVER – SQL Agent – Job Start Whenever the CPUs Become Idle

Today let see a quick question which I was recently asked by a customer of Comprehensive Database Performance Health Check about SQL Agent and Job starting whenever CPU Become Idle.

SQL SERVER - SQL Agent - Job Start Whenever the CPUs Become Idle sqlagents-800x193

Become Idle

SQL Server Agent is one of the most important tools for DBA. We use it for pretty much everything from Index rebuilding, database backup, database consistency check, etc. When we try to configure the job schedule we have quite a lots of options but one option was really confusing to my client it said – Start Whenever CPUs Become Idle. So the question which I received was what actually decides that CPU is ideal or not.

SQL SERVER - SQL Agent - Job Start Whenever the CPUs Become Idle agentjob1

Solarwinds

Well, the answer is pretty simple actually and let us understand with the help of SQL Agent only.

First of all – go to the SQL Agent Node in SQL Server Management Studio. Over here, right-click and go to Properties.

SQL SERVER - SQL Agent - Job Start Whenever the CPUs Become Idle agentjob2

Next, go to Advanced Options.

SQL SERVER - SQL Agent - Job Start Whenever the CPUs Become Idle agentjob3

Over here, you will notice a configuration section for Idle CPU Conditions. Check the box next to that option.

Checking the option will enable two further options: Average CPU Usage Falls Below and And Remains Below This Level For. Configure these two values to quality your server in the CPU Idle state.

I usually keep the values at the default value unless there is a need to change them.

Here are a few additional blog posts which are on the same topic as what we discussed in this blog post:

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, , , ,
Previous Post
SQL SERVER – Strange Error Related to Alias
Next Post
SQL SERVER – Drop Multiple Columns from a Single Table

Related Posts

Leave a Reply

Menu