SQL - @@IO_BUSY Function

---

---

The SQL @@IO_BUSY statistical function is used to retrieve the spent time by this SQL server. It returns the total spent time by this SQL server on performing the input and output operations.

Note − If the time returned by the @@IO_BUSY function exceeds around 49 days of cumulative CPU time, you may receive an arithmetic overflow warning. In that case, the value of @@CPU_BUSY, @@IO_BUSY, and @@IDLE variables are incorrect.

Syntax

Following is the syntax of the SQL @@IO_BUSY function −

@@IO_BUSY

Return type

The return type of this function is an INTEGER.

Parameters

• It does not accept any parameters.

Return value

This function returns the total spent time by this SQL server on performing the input and output operations.

Example

In the following example,we are using the SQL @@IO_BUSY function to retrieve the total time of this SQL server that has been spent performing the input and output operations.

SELECT @@IO_BUSY AS Total_spent_time;

Output

After executing the above query, it will produce the following output −

+------------------+
| Total_spent_time |
+------------------+
| 43939            |
+------------------+

Example

The following is another example of the SQL @@IO_BUSY function. You can also use the GETDATE() function along with this function to retrieve the total time until today of this SQL server that has been spent on performing the input and output operations.

SELECT @@IO_BUSY AS Total_spent_time, GETDATE() AS Todays_date;

Output

Following is the output of the above query −

+-----------------+-------------------------+
| Total_spent_time| Todays_date             |
+-----------------+-------------------------+
| 4398            | 2023-02-28 16:56:26.700 |
+-----------------+-------------------------+

Example

In this example, we are using the SQL @@IO_BUSY function to retrieve the total spent time by this SQL server on performing the input and output operations.

SELECT @@IO_BUSY AS Total_spent_time, GETDATE() AS Curr_date, @@IO_BUSY *CAST(@@TIMETICKS AS float) AS Time_in_microsecond;

Output

The above SQL query produces the following output −

+------------------+-------------------------+---------------------+
| Total_spent_time | Curr_date               | Time_in_microsecond |
+------------------+-------------------------+---------------------+
| 44023            | 2023-02-28 16:58:43.160 | 1375718750          |
+------------------+-------------------------+---------------------+