This layer is for the disk and controllers that store your data. Adaptive Server can manage up to 256 devices.
Issues at the devices layer include:
You mirror the master device, the devices that hold the user database, or the database logs?
How do you distribute system databases, user databases, and database logs across the devices?
Do you need partitions for parallel query performance or high insert performance on heap tables?
Options to address these issues include:
Using more medium-sized devices and controllers may provide better I/O throughput than a few large devices
Distributing databases, tables, and indexes to create even I/O load across devices
Using segments and partitions for I/O performance on large tables used in parallel queries
