A new approach to dynamic self-tuning of database buffers
ACM Transactions on Storage (TOS)
Autonomic tuning expert: a framework for best-practice oriented autonomic database tuning
CASCON '08 Proceedings of the 2008 conference of the center for advanced studies on collaborative research: meeting of minds
Hi-index | 0.00 |
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.