2006 · 113 citations · 14 references
ComputingComputer ScienceComputer SystemsDatabasesMemoryOperating SystemsCache Behavior AnalysisCachingMemory HierarchyMemory ManagementMemory Subsystem DesignPerformance TuningConvergenceDynamic Memory AllocationHeapsHeterogeneous Memory SystemsMemory AllocationMemory Allocation StrategiesMemory PlacementSystem Noise Reduction
DB2 for Linux, UNIX, and Windows Version 9.1 introduces the Self-Tuning Memory Manager (STMM), which provides adaptive self tuning of both database memory heaps and cumulative database memory allocation. This technology provides state-ofthe-art memory tuning combining control theory, runtime simulation modeling, cost-benefit analysis, and operating system resource analysis. In particular, the novel use of cost-benefit analysis and control theory techniques makes STMM a breakthrough technology in database memory management. The cost-benefit analysis allows STMM to tune memory between radically different memory consumers such as compiled statement cache, sort, and buffer pools. These methods allow for the fast convergence of memory settings while also providing stability in the presence of system noise. The tuning model has been found in numerous experiments to tune memory allocation as well as expert human administrators, including OLTP, DSS, and mixed environments. We believe this is the first known use of costbenefit analysis and control theory in database memory tuning across heterogeneous memory consumers. 1.
14
Automatic Performance Diagnosis and Tuning in Oracle
Karl Dias, Mark Ramacher, Uri Shaft et al. · Conference on Innovative Data Systems Research · 2005 · 102 citations
Goal-oriented buffer management revisited
Kurt P. Brown, Michael J. Carey, Miron Livny · 1996 · 68 citations · Full text
Partially preemptible hash joins
HweeHwa Pang, Michael J. Carey, Miron Livny · 1993 · 55 citations · Full text