20th International Conference on Advanced Information Networking and Applications - Volume 2 (AINA'06) Automatic Performance Diagnosis for Changing Workloads in DBMSs Vienna, Austria April 18-April 20 ISBN: 0-7695-2466-4
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/AINA.2006.111
Database performance is directly linked to Database Management System (DBMS) resource allocation. Complex relationships between DBMS resources make problem diagnosis and performance tuning difficult, time-consuming tasks. Database Administrators are currently required to retune the DBMS as databases grow and workloads change. Performance can be increased and cost of ownership reduced by automating the tuning process, starting specifically with the diagnosis of resource allocation problems. In this paper, we overview our automatic diagnosis framework designed to determine resource problems. We present our results demonstrating the ability to correctly identify system bottlenecks for a generic On-Line Transaction Processing workload when new transactions are added to the workload.
Citation:
Darcy G. Benoit, "Automatic Performance Diagnosis for Changing Workloads in DBMSs," aina, vol. 2, pp.509-518, 20th International Conference on Advanced Information Networking and Applications - Volume 2 (AINA'06), 2006 Usage of this product signifies your acceptance of the Terms of Use. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||