Technology Conference on Performance Evaluation and Benchmarking

TPCTC 2014: Performance Characterization and Benchmarking. Traditional to Big Data pp 173-187

A Query, a Minute: Evaluating Performance Isolation in Cloud Databases

  • Tim Kiefer
  • Hendrik Schön
  • Dirk Habich
  • Wolfgang Lehner
Conference paper

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

Volume 8904 of the book series Lecture Notes in Computer Science (LNCS)
Cite this paper as:
Kiefer T., Schön H., Habich D., Lehner W. (2015) A Query, a Minute: Evaluating Performance Isolation in Cloud Databases. 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

Several cloud providers offer reltional databases as part of their portfolio. It is however not obvious how resource virtualization and sharing, which is inherent to cloud computing, influence performance and predictability of these cloud databases.

Cloud providers give little to no guarantees for consistent execution or isolation from other users. To evaluate the performance isolation capabilities of two commercial cloud databases, we ran a series of experiments over the course of a week (a query, a minute) and report variations in query response times. As a baseline, we ran the same experiments on a dedicated server in our data center. The results show that in the cloud single outliers are up to 31 times slower than the average. Additionally, one can see a point in time after which the average performance of all executed queries improves by 38 %.

Copyright information

© Springer International Publishing Switzerland 2015

Authors and Affiliations

  • Tim Kiefer
    • 1
  • Hendrik Schön
    • 1
  • Dirk Habich
    • 1
  • Wolfgang Lehner
    • 1
  1. 1.Database Technology GroupTechnische Universität DresdenDresdenGermany