Home > Storage > Unity XT > Virtualization, Cloud & Applications > Dell Unity XT: Oracle Database Best Practices > OLTP workloads
An online transaction processing (OLTP) workload typically consists of small random reads and writes. The I/O sizes are generally equivalent to the database block size. The primary goal of designing a storage system for this type of workload is to maximize the number of IOPS while keeping the latency as low as possible. Depending on the business and application requirement, a latency of less than 1 millisecond is typical in a high performing environment.
Consider using 16 Gb Fibre Channel (FC) or 25 GbE optical I/O models in each SP. If higher drive counts are necessary to achieve higher IOPS, use 12 Gb SAS IO modules for backend connectivity, such as from the storage processors (controllers) to the disk enclosures. 12 Gb SAS is only available in the 480F, 680F, and 880F models and 25 GbE optical is only available in Dell Unity x80/x80F models.
For best results, capture performance statistics for at least 24 hours that include the system peak workload.
An OLTP workload typically consists of small random reads and writes. The backend storage system servicing this type of workload is primarily sized based on capacity and the number of IOPS required.