Priority in DBMS resource scheduling
VLDB '89 Proceedings of the 15th international conference on Very large data bases
On Workload Characterization of Relational Database Environments
IEEE Transactions on Software Engineering
Dynamic resource brokering for multi-user query execution
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
Multi-dimensional resource scheduling for parallel queries
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Dynamic Memory Allocation for Multiple-Query Workloads
VLDB '93 Proceedings of the 19th International Conference on Very Large Data Bases
Xen and the art of virtualization
SOSP '03 Proceedings of the nineteenth ACM symposium on Operating systems principles
Database Server Workload Characterization in an E-Commerce Environment
MASCOTS '04 Proceedings of the The IEEE Computer Society's 12th Annual International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunications Systems
The Architecture of Virtual Machines
Computer
Resource Allocation for Autonomic Data Centers using Analytic Performance Models
ICAC '05 Proceedings of the Second International Conference on Automatic Computing
Utility-Function-Driven Resource Allocation in Autonomic Systems
ICAC '05 Proceedings of the Second International Conference on Automatic Computing
Continuous resource monitoring for self-predicting DBMS
MASCOTS '05 Proceedings of the 13th IEEE International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems
Dynamic placement for clustered web applications
Proceedings of the 15th international conference on World Wide Web
Adaptive self-tuning memory in DB2
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
A scalable application placement controller for enterprise data centers
Proceedings of the 16th international conference on World Wide Web
Automated and on-demand provisioning of virtual machines for database applications
Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Live migration of virtual machines
NSDI'05 Proceedings of the 2nd conference on Symposium on Networked Systems Design & Implementation - Volume 2
Appliance-Based Autonomic Provisioning Framework for Virtualized Outsourcing Data Center
ICAC '07 Proceedings of the Fourth International Conference on Autonomic Computing
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
SQL memory management in Oracle9i
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Server virtualization in autonomic management of heterogeneous workloads
ACM SIGOPS Operating Systems Review
VirtualBox: bits and bytes masquerading as machines
Linux Journal
Linux Journal
Automatic virtual machine configuration for database workloads
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Journal of Systems and Software
Autonomic Live Adaptation of Virtual Computational Environments in a Multi-Domain Infrastructure
ICAC '06 Proceedings of the 2006 IEEE International Conference on Autonomic Computing
Self-Tuning Virtual Machines for Predictable eScience
CCGRID '09 Proceedings of the 2009 9th IEEE/ACM International Symposium on Cluster Computing and the Grid
Windows Server 2008 Resource Kit
Windows Server 2008 Resource Kit
Workload-aware database monitoring and consolidation
Proceedings of the 2011 ACM SIGMOD International Conference on Management of data
"Cut me some slack": latency-aware live migration for databases
Proceedings of the 15th International Conference on Extending Database Technology
Feedback-based optimization of a private cloud
Future Generation Computer Systems
RemusDB: transparent high availability for database systems
The VLDB Journal — The International Journal on Very Large Data Bases
Parallel analytics as a service
Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data
Application level ballooning for efficient server consolidation
Proceedings of the 8th ACM European Conference on Computer Systems
Non-cooperative games on multidimensional resource allocation
Future Generation Computer Systems
IBM zEnterprise unified resource manager platform performance management
IBM Journal of Research and Development
Hi-index | 0.00 |
Virtual machine monitors are becoming popular tools for the deployment of database management systems and other enterprise software. In this article, we consider a common resource consolidation scenario in which several database management system instances, each running in a separate virtual machine, are sharing a common pool of physical computing resources. We address the problem of optimizing the performance of these database management systems by controlling the configurations of the virtual machines in which they run. These virtual machine configurations determine how the shared physical resources will be allocated to the different database system instances. We introduce a virtualization design advisor that uses information about the anticipated workloads of each of the database systems to recommend workload-specific configurations offline. Furthermore, runtime information collected after the deployment of the recommended configurations can be used to refine the recommendation and to handle changes in the workload. To estimate the effect of a particular resource allocation on workload performance, we use the query optimizer in a new what-if mode. We have implemented our approach using both PostgreSQL and DB2, and we have experimentally evaluated its effectiveness using DSS and OLTP workloads.