Autonomic Computing, International Conference on (2005)
June 13, 2005 to June 16, 2005
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICAC.2005.12
Darcy G. Benoit , Acadia University
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.
D. G. Benoit, "Automatic Diagnosis of Performance Problems in Database Management Systems," Autonomic Computing, International Conference on(ICAC), Seattle, Washington, 2005, pp. 326-327.