You might find it necessary to increase the max async I/O parameter if you implement a drive array on your SQL server. This parameter determines the maximum number of reads and writes your server can perform simultaneously. By default, SQL Server configures your server’s max async I/O parameter at 3
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help