How large should I configure the data volumes of a MaxDB database?
It is not only the size of a data volume that is important for system performance, but also the number of volumes. The number of volumes determines the scaling of the I/O. Depending on the number of configured volumes, MaxDB configures threads (_IOPROCS_PER_DEV), which are responsible for the I/O. The number of threads for each volume is configured using the _IOPROCS_PER_DEV parameter. We recommend the following values: 2 (UNIX), 1 (WINDOWS) Therefore, subsequent I/O operations to a volume are distributed to several threads. You should increase the number of I/O threads for each volume if the database has been configured with a small number of data volumes, but the I/O system allows more parallel I/O. However, it is advantageous to use an appropriately large amount of data volumes, because the data writer and user tasks must then check less frequently if an I/O queue is already busy. Too many data volumes increase the number of threads, and can approach the limits of the operating syst
