Cpu Idle (CpuIdle)

Monitors the percentage of time that the SQL Server is idle between polls of the @@IDLE function. The GlobalVarsColl collector parameter calculates the change in the SQL Server @@IDLE function that occurs between polls of @@IDLE, and then it sends that value to the CpuIdle parameter.

Recommendations

Microsoft SQL Server automatically and dynamically configures resources. Only advanced users should use sp_configure to manually configure SQL Server. If the SQL Server consistently registers an excessive amount of idle time, you might want to run sp_configure to decrease the amount of available memory. Before making any changes, consult the configuration value and memory usage. Using sp_configure can cause some unwanted results. Consult your Microsoft SQL Server documentation before making any changes to the configuration.

Recovery actions

Whenever it reaches an alarm state, the CpuIdle parameter generates a pop-up window that contains a report on the processes that use CPU, including the last SQL statement executed by those processes. Other recovery actions for this parameter are controlled by the settings in the ARA Default Actions dialog box. By default, whenever this parameter crosses a warning or an alarm threshold, the ARA (automatic recovery action) feature does the following:

• Executes the ara_MSSQL.cmd script (if one exists). See Setting up the ara_MSSQL command for instructions on how to create a recovery action in the ara_MSSQL.cmd file.
• Creates an output file in the PATROL_TEMP directory .
• Annotates the parameter warning or alarm.
• Triggers an event in the PATROL Event Manager.

To turn off these automatic recovery actions or to add other actions, see Customizing automatic recovery actions.

Default parameter attributes