allow sql server async i/o

Summary information

Default value

1 (on)

Valid values

0 (off), 1 (on)

Status

Static

Display level

Comprehensive

Required role

System administrator

Configuration group

Disk I/O

allow sql server async i/o enables Adaptive Server to run with asynchronous disk I/O. To use asynchronous disk I/O, enable it on both Adaptive Server and your operating system. See your operating system documentation for information on enabling asynchronous I/O at the operating system level.

Disk I/O always runs faster asynchronously than synchronously. This is because when Adaptive Server issues an asynchronous I/O, it does not have to wait for a response before issuing further I/Os.