Technology Conference on Performance Evaluation and Benchmarking

TPCTC 2014: Performance Characterization and Benchmarking. Traditional to Big Data pp 156-172

Performance Analysis of Database Virtualization with the TPC-VMS Benchmark

  • Eric Deehr
  • Wen-Qi Fang
  • H. Reza Taheri
  • Hai-Fang Yun
Conference paper

DOI: 10.1007/978-3-319-15350-6_10

Volume 8904 of the book series Lecture Notes in Computer Science (LNCS)
Cite this paper as:
Deehr E., Fang WQ., Reza Taheri H., Yun HF. (2015) Performance Analysis of Database Virtualization with the TPC-VMS Benchmark. In: Nambiar R., Poess M. (eds) Performance Characterization and Benchmarking. Traditional to Big Data. TPCTC 2014. Lecture Notes in Computer Science, vol 8904. Springer, Cham

Abstract

TPC-VMS is a benchmark designed to measure the performance of virtualized databases using existing, time-tested TPC workloads. In this paper, we will present our experience in using the TPC-E workload under the TPC-VMS rules to measure the performance of 3 OLTP databases consolidated onto a single server. We will describe the tuning steps employed to more than double the performance and reach 98.6 % of the performance of a non-virtualized server – if we aggregate the throughputs of the 3 VMs for quantifying the tuning process. The paper will detail lessons learned in optimizing performance by tuning the application, the database manager, the guest operating system, the hypervisor, and the hardware on both AMD and Intel processors.

Since TPC-E results have been disclosed with non-virtualized databases on both platforms, we can analyze the performance overheads of virtualization for database workloads. With a native-virtual performance gap of just a few percentage points, we will show that virtualized servers make excellent platforms for the most demanding database workloads.

Keywords

Database performanceVirtualizationSQL serverWorkload consolidationPerformance tuningCloud computing

Copyright information

© Springer International Publishing Switzerland 2015

Authors and Affiliations

  • Eric Deehr
    • 1
  • Wen-Qi Fang
    • 1
  • H. Reza Taheri
    • 2
  • Hai-Fang Yun
    • 1
  1. 1.Hewlett-Packard, Inc.BeijingChina
  2. 2.VMware, Inc.Palo AltoUSA