Mar 12, 2021 · Databases

Understanding OLTP and OLAP Workloads and Oracle Database Performance Best Practices

This article explains the characteristics of OLTP and OLAP workloads, compares their I/O patterns, and provides Oracle database performance best‑practice guidelines, including storage planning, SAN architecture, operating‑system queue‑depth settings, and SwingBench testing results for optimal configuration.

Database PerformanceI/O optimizationOLAP

0 likes · 11 min read

Understanding OLTP and OLAP Workloads and Oracle Database Performance Best Practices

ITFLY8 Architecture Home

Jan 1, 2017 · Operations

How to Accurately Estimate Server, Storage, and Performance Resources for Enterprise Systems

This guide defines key IT terminology and presents a comprehensive methodology for estimating hardware platforms, storage devices, database and application servers, load‑balancing, and resource allocation using performance benchmarks such as TPC‑C, SPECweb2005, and SPECjbb2005, while outlining basic architectural principles and best‑practice deployment patterns.

IT infrastructurePerformance Testingresource estimation

0 likes · 34 min read

How to Accurately Estimate Server, Storage, and Performance Resources for Enterprise Systems