Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Managed Instance
Important
On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server or SQL Agent job limitations in SQL Managed Instance for details.
This article explains how to define the CPU idle condition for your server in SQL Server by using SQL Server Management Studio. The CPU idle definition influences how SQL Server Agent responds to events.
For example, suppose that you define the CPU idle condition as when the average CPU usage falls below 10 percent and remains at this level for 10 minutes. Then, if you define jobs to execute whenever the server CPU reaches an idle condition, the job starts when the CPU usage falls below 10 percent and remains at that level for 10 minutes. If this job significantly impacts the performance of your server, how you define the CPU idle condition is important.
Use SQL Server Management Studio
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
Right-click SQL Server Agent, select Properties, and select the Advanced page.
Under Idle CPU condition, complete the following steps:
Select Define idle CPU condition.
Enter a percentage for the Average CPU usage falls below (across all CPUs) box. This value sets the usage level that the CPU must fall below before it's considered idle.
Enter a number of seconds for the And remains below this level for box. This value sets the duration that the minimum CPU usage must remain at before it's considered idle.