DATE: Thursday, December 16, 2004
TIME: 2:30 pm - 3:30 pm (note special time)
PLACE: Wean Hall 7220 (note special place)

Dushyanth Narayanan
Microsoft Research Cambridge

What Will My Performance Be? (A Resource Advisor for DBMSs)

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 system resources (CPU, memory and storage) with quantitative predictions of the expected improvement in workload performance. We describe the design, implementation, and evaluation of a Resource Advisor, a tool that provides such predictions in response to "what-if" questions about hypothetical resource upgrades. It is based on end-to-end monitoring of transactions in a live system, followed by simulation and analysis to predict workload performance after a hypothetical resource change.

Since November 2002, Dushyanth Narayanan has been a researcher at Microsoft's Research Centre in Cambridge, UK, where he thinks about performance modeling, power management, and other research areas beginning with the letter "p." In August 2002, he acquired his Ph.D. from Carnegie Mellon University, where he worked on adaptation in interactive wearable applications. An excess of information about him can be found at and

Host: M. Satyanarayanan

Visitor Coordinator: Tracy Farbacher

For Further Seminar Info Contact:
or visit