@article{narayanan2006challenges, author = {Narayanan, Dushyanth and Thereska, Eno and Ailamaki, Anastassia}, title = {Challenges in building a DBMS Resource Advisor}, year = {2006}, month = {January}, abstract = {Administration increasingly dominates 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. We present a design and prototype implementation of a Resource Advisor that is able to answer “whatif” questions about DBMS performance under hypothetical conditions. We discuss the design issues and challenges involved in building such a Resource Advisor, as well as our experiences in building a prototype Resource Advisor for SQL Server.}, publisher = {IEEE}, url = {http://approjects.co.za/?big=en-us/research/publication/challenges-in-building-a-dbms-resource-advisor/}, pages = {40-46}, journal = {IEEE Data Eng. Bull}, volume = {29}, edition = {IEEE Data Eng. Bull}, }