loading...
Continuous resource monitoring for self-predicting DBMS
Atlanta, Georgia September 27-September 29
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/MASCOT.2005.2113th IEEE International Symposium on ...
 This Article 
 
PDF
HTML
IEEE Xplore Subscribers
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Dushyanth Narayanan, Microsoft Research Cambridge, UK
Eno Thereska, Carnegie Mellon University Pittsburgh, PA
Anastassia Ailamaki, Carnegie Mellon University Pittsburgh, PA

Administration tasks increasingly dominate the total cost of ownership of database management systems. A key task, and a very difficult one for an administrator, is to justify upgrades of CPU, memory and storage resources with quantitative predictions of the expected improvement in workload performance. Current database systems are not designed with such prediction in mind and hence offer only limited help to the administrator. This paper proposes changes to database system design that enable a Resource Advisor to answer "what-if" questions about resource upgrades. A prototype Resource Advisor built to work with a commercial DBMS shows the efficacy of our approach in predicting the effect of upgrading a key resource - buffer pool size - on OLTP workloads in a highly concurrent system.

Citation:
Dushyanth Narayanan, Eno Thereska, Anastassia Ailamaki, "Continuous resource monitoring for self-predicting DBMS," mascots, pp.239-248, 13th IEEE International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems, 2005
Usage of this product signifies your acceptance of the Terms of Use.


Suggestions