Редагувати

Поділитися через


Set CPU Idle Time and Duration

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 for details.

This topic 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 Microsoft 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 have defined jobs to execute whenever the server CPU reaches an idle condition, the job will start when the CPU usage falls below 10 percent and remains at that level for 10 minutes. If this is a job that significantly impacts the performance of your server, how you define the CPU idle condition is important.

Using SQL Server Management Studio

To set CPU idle time and duration

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Right-click SQL Server Agent, click Properties, and select the Advanced page.

  3. Under Idle CPU condition, do the following:

    • Check Define idle CPU condition.

    • Specify a percentage for the Average CPU usage falls below (across all CPUs) box. This sets the usage level that the CPU must fall below before it is considered idle.

    • Specify a number of seconds for the And remains below this level for box. This sets the duration that the minimum CPU usage must remain at before it is considered idle.