Cpu Busy (CpuBusy)

Monitors the percentage of time that the SQL Server is busy between polls of the @@CPU_BUSY global variable. The SQL Server increments the @@CPU_BUSY global variable each time the server detects that a process is running. The @@CPU_BUSY global variable measures the amount of CPU since SQL Server was last started. The GlobalVarsColl parameter calculates the change in the @@CPU_BUSY function that occurs between polls of @@CPU_BUSY, and it sends that calculated value to the CpuBusy parameter.

Recommendations

Examine the processes that are running to see if any are using unusually high amounts of CPU resources. You might also want to run sp_configure to increase the amount of available memory. Microsoft SQL Server automatically and dynamically configures resources. Only advanced users should use sp_configure to manually configure SQL Server. Using sp_configure can cause some unwanted results. Consult your Microsoft SQL Server documentation before making any changes to the configuration.

Recovery actions

When it reaches an alarm state the CpuBusy parameter generates a pop-up window that contains a report. 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