i/o batch size

i/o batch size sets the number of writes issued in a batch before the task goes to sleep. Once this batch is completed, the task is woken up, and the next batch of writes are issued, ensuring that the I/O subsystem is not flooded with many simultaneous writes.

Summary Information

Default value

100

Range of values

1–2147483647

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

SQL Server Administration

Setting i/o batch size to the appropriate value can improve the performance of operations like checkpoint, dump database, select into, and so on.