Non-linear Optimization of Performance Functions for Autonomic Database Performance Tuning

• Published in: Third International Conference on Autonomic and Autonomous Systems (ICAS'07) p. 48
• Main Authors: Rabinovitch, G., Wiese, D.
• Format: Conference Proceeding
• Language: English
• Published: IEEE 01.06.2007
• Subjects: autonomic database tuning; Autonomic nervous system; Control systems; Environmental management; Information systems; Management information systems; MAPE; non-linear regression; optimization; Optimization methods; Physiology; problem resolution; Protection; Relational databases; resource dependencies; Runtime; self-management; tuning knowledge
• ISBN: 0769528597; 9780769528595
• DOI: 10.1109/CONIELECOMP.2007.89

Modern ondemand environments are coined by a heterogeneous diversity of components, architectures and applications. High performance, availability and further service level agreements need to be satisfied under any circumstances in order to please customers. Today, highly skilled database administrators (DBAs) are required to tune the DBMS within their complex environments. Achieved DBMS' performance depends on individual DBA skills, home-grown tuning scripts and in most cases is reactive to obvious and urgent performance problems. This paper addresses the idea of classifying, formalizing, obtaining, storing, maintaining, exchanging and individually adapting DBA expert tuning-knowledge as shared domain of understanding in the autonomic management process. Hereby, we focus our attention on the development of a resource dependency model that allows for (precise) optimization and decision-support at run-time, in contrast to traditional trial-and- error, feedback-based tuning methodologies based on best- practices.