DocumentCode :
1516122
Title :
System optimization for OLTP workloads
Author :
Kunkel, Steven ; Armstrong, Bill ; Vitale, Philip
Author_Institution :
IBM Corp., Rochester, MN, USA
Volume :
19
Issue :
3
fYear :
1999
Firstpage :
56
Lastpage :
64
Abstract :
Major performance enhancements in large commercial systems are best achieved when advances in hardware technology are matched with advances in software technology. This article connects recent AS/400 hardware advances with the corresponding approaches used to tune the system performance for large online transaction processing (OLTP) workloads. We particularly emphasize those tuning efforts that affect the memory system. OLTP workloads are large and complex, stressing many parts of both the software and hardware. These workloads quickly expose software bottlenecks caused by contention on software locks. They also have large working sets, populated with hard-to-predict access patterns that make cache miss rates high. This causes the processor to spend a significant part of its execution time waiting for memory accesses. In multiprocessor systems, compilers alone have minimal effect on cycles spent in storage latency. Other optimizations are needed to affect this portion of the execution time, and many of those require direct involvement of the system software
Keywords :
data mining; systems analysis; AS/400 hardware advances; OLTP workloads; compilers; hardware technology; multiprocessor systems; online transaction processing; performance enhancements; software technology; system optimization; system software; Computer aided instruction; Computer architecture; Hardware; Job shop scheduling; Microprocessors; Operating systems; Processor scheduling; Reduced instruction set computing; System performance; Time sharing computer systems;
fLanguage :
English
Journal_Title :
Micro, IEEE
Publisher :
ieee
ISSN :
0272-1732
Type :
jour
DOI :
10.1109/40.768504
Filename :
768504
Link To Document :
بازگشت