Database virtualization: A new frontier for database tuning and physical design

Resource virtualization is currently being employed at all levels of the IT infrastructure to improve provisioning and manageability, with the goal of reducing total cost of ownership. This means that database systems will increas-ingly be run in virtualized environments, inside virtual ma-chines. This has many benefits, but it also introduces new tuning and physical design problems that are of interest to the database research community. In this paper, we dis-cuss how virtualization can benefit database systems, and we present the tuning problems it introduces, which relate to setting the new “tuning knobs ” that control resource al-location to virtual machines in the virtualized environment. We present a formulation of the virtualization design prob-lem, which focuses on setting resource allocation levels for different database workloads statically at deployment and configuration time. An important component of the solu-tion to this problem is modeling the cost of a workload for a given resource allocation. We present an approach to this cost modeling that relies on using the query optimizer in a special virtualization-aware “what-if ” mode. We also dis-cuss the next steps in solving this problem, and present some long-term research directions. 1