Cpu I/O Busy (CpuIoBusy)

1. Monitors the percentage of time that the SQL Server performs input and output operations between polls of the @@IO_BUSY global variable.
2. The SQL Server increments the @@IO_BUSY global variable whenever the SQL Server performs input and output operations. The @@IO_BUSY function measures the amount of I/O since SQL Server was last started. The GlobalVarsColl parameter calculates the change in @@IO_BUSY that occurs between polls of @@IO_BUSY, and then it sends that value to the CpuIoBusy parameter.

Recommendations

Examine the processes that are running to see if any are performing unusually high amounts of I/O.

Recovery actions

1. Whenever it goes into an alarm state, the CpuIoBusy parameter generates a pop-up window that contains a report with details about the processes that spent the most time performing I/O operations. The report includes the last SQL statement executed by those processes.
2. 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