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.