Measuring Database Performance in Online Services: A Trace-Based Approach

  • Swaroop Kavalanekar
  • Dushyanth Narayanan
  • Sriram Sankar
  • Eno Thereska
  • Kushagra Vaid
  • Bruce Worthington
Part of the Lecture Notes in Computer Science book series (LNCS, volume 5895)

Abstract

Many large-scale online services use structured storage to persist metadata and sometimes data. The structured storage is typically provided by standard database servers such as Microsoft’s SQL Server. It is important to understand the workloads seen by these servers, both for provisioning server hardware as well as to exploit opportunities for energy savings and server consolidation. In this paper we analyze disk I/O traces from production servers in four internet services as well as servers running TPC benchmarks. We show using a range of load metrics that the services differ substantially from each other and from standard TPC benchmarks. Online services also show significant diurnal patterns in load that can be exploited for energy savings or consolidation. We argue that TPC benchmarks do not capture these important characteristics and argue for developing benchmarks that can be parameterized with workload features extracted from live production workload traces.

Keywords

online services TPC benchmarks storage traces storage performance data centers capacity planning 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag Berlin Heidelberg 2009

Authors and Affiliations

  • Swaroop Kavalanekar
    • 1
  • Dushyanth Narayanan
    • 2
  • Sriram Sankar
    • 1
  • Eno Thereska
    • 2
  • Kushagra Vaid
    • 1
  • Bruce Worthington
    • 1
  1. 1.Microsoft CorporationRedmondUSA
  2. 2.Microsoft Research Ltd.CambridgeUnited Kingdom

Personalised recommendations