How to set CPU idle time and duration (Enterprise Manager)

How to Install SQL Server 2000

How To

How to set CPU idle time and duration (Enterprise Manager)

To set CPU idle time and duration

  1. Expand a server group, and then expand a server.

  2. Expand Management, right-click SQL Server Agent, and then click Properties.

  3. Click the Advanced tab, and then select the The computer is idle when check box.

  4. Under Idle CPU condition, do the following:
    • Specify the percentage that the average CPU usage must remain below (across all CPUs).

    • Specify the duration in seconds before the computer is considered idle.