Abstract
Database administrators should be aware of resource usages to maintain database system performance. As database applications become more complex and diverse, managing database systems becomes too costly and prone to error. Autonomic database tuning becomes more important than ever. This paper starts with an analysis on how resource usages respond by changing resource sizes in database systems. Then, we present a simple method that automatically selects resources that affect the system performance. An experiment using the TPC-C and TPC-W workloads has been carried out with a commercial database system. A preliminary analysis shows that our method works.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
