Automatic diagnosis of performance problems in database management systems

DG Benoit - … Conference on Autonomic Computing (ICAC'05), 2005 - ieeexplore.ieee.org
DG Benoit
Second International Conference on Autonomic Computing (ICAC'05), 2005ieeexplore.ieee.org
Database performance is directly linked to database management system (DBMS) resource
allocation. Complex relationships between resources make problem diagnosis and
performance tuning difficult, time-consuming tasks. Database administrators (DBAs)
currently tune and re-tune the DBMS as the database grows and workloads change.
Increased performance and reduced cost of ownership can be achieved by automating the
tuning process, starting with resource allocation problem diagnosis. In this paper we …
Database performance is directly linked to database management system (DBMS) resource allocation. Complex relationships between resources make problem diagnosis and performance tuning difficult, time-consuming tasks. Database administrators (DBAs) currently tune and re-tune the DBMS as the database grows and workloads change. Increased performance and reduced cost of ownership can be achieved by automating the tuning process, starting with resource allocation problem diagnosis. In this paper we overview an automatic diagnosis framework designed to diagnose resource problems. Our diagnosis model and results demonstrate an ability to correctly identify system bottlenecks for a generic on-line transaction processing workload
ieeexplore.ieee.org