A striped redundant array of independent disks (RAID) device can contain multiple physical disks, but Adaptive Server treats such a device as a single logical device. You can use multiple partitions on the single logical device and achieve good parallel query performance.
To determine the optimum number of partitions for your application mix, start with one partition for each device in the stripe set. Use your operating system utilities (vmstat, sar, and iostat on UNIX; Performance Monitor on Windows) to check utilization and latency.
To check maximum device throughput, use select count(*), using the index table_name clause to force a table scan if a nonclustered index exists. This command requires minimal CPU effort and creates very little contention for other resources.
