Home > Storage > PowerStore > Databases and Data Analytics > Dell PowerStore: Oracle Best Practices > OLTP and OLAP/DSS workloads
OLTP systems usually support predefined operations on specific data, and their workloads generally have small, random I/Os for rapidly changing data. As such, PowerStore arrays should be primarily sized based on the number of IOPS for OLTP systems.
Data warehouses are designed to accommodate queries, OLAP, DSS, and ETL processing. Their workloads generally have large sequential reads. Storage solutions servicing workloads of this type are predominantly sized based on I/O bandwidth or throughput and not capacity or IOPS. When sizing for throughput, the expected throughput of each component in the I/O path (CPU cores, HBAs, FC connections, FC switches and ports, disk controllers, and disks) must be known. The entire I/O path needs to be sized appropriately to guarantee balanced system resources. Appropriately sized I/O paths maximize I/O throughput and allow the system to grow without compromising the I/O bandwidth. Sometimes, throughput can easily be exceeded when using SSDs. Understand the characteristics of SSDs and the expected I/O pattern of Oracle.