Tune the disk storage:
The TPC-E benchmark rules require disk storage redundancy. You can use RAID 1+0 if you have enough storage capacity. If you do not have enough capacity, you can use RAID 5.
If you use rotational disks, configure logical drives so that all spindles are used for database disks, if possible. Additional spindles improve overall disk subsystem performance.
The TPC-E workload consists of two disk I/O workloads: random reads/writes in a 9:1 ratio on database tables, and sequential writes on the log. You can improve performance with proper write caching on the log disk only in the case of battery backed up disk configurations that are able to avoid data loss in case of power failure:
Enable 100% write caching for the log disk.
|