allow sql server async i/o

Summary information

Default value

1

Valid values

0 (off), 1 (on)

Status

Static

Display level

Comprehensive

Required role

System Administrator

The allow sql server async i/o parameter enables Adaptive Server to run with asynchronous disk I/O. Use asynchronous disk I/O, you have to 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.

In all circumstances, disk I/O 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.