Skip to main content

Extending TPC-E to Measure Availability in Database Systems

  • Conference paper
  • 2587 Accesses

Part of the book series: Lecture Notes in Computer Science ((LNPSE,volume 7144))

Abstract

High-availability is a critical feature to database customers; having a way to measure and characterize availability is important for guiding system development and evaluating different HA technologies. This paper describes extensions to the TPC-E benchmark for availability measurement, including HA scenario simulation, fault injection, and availability metric reporting. The implementation details and exemplary test results on SQL Server 2008 Database Mirroring are also described.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   54.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   72.00
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Microsoft SQL Server High Availability Solutions Overview, http://msdn.microsoft.com/en-us/library/ms190202v=SQL.100.aspx

  2. Microsoft SQL Server 2008 Database Mirroring Overview, http://msdn.microsoft.com/en-us/library/bb934127v=SQL.100.aspx

  3. TPC-E Benchmark, http://www.tpc.org/tpce/

  4. Gray, J., Siewiorek, D.: High-Availability Computer Systems. Computer 24(9), 39–48 (1991)

    Article  Google Scholar 

  5. IFIP WG 10.4 on Dependable Computing and Fault Tolerance, http://www.dependability.org/wg10.4/

  6. Kanoun, K., Spainhower, L. (eds.): Dependability Benchmarking for Computer Systems. Wiley-IEEE Computer Society Press (2008)

    Google Scholar 

  7. Vieira, M., Madeira, H.: A dependability Benchmark for OLTP Application Environments. In: VLDB 2003, pp. 742–753 (2003)

    Google Scholar 

  8. Almeida, R., Poess, M., Nambiar, R., Patil, I., Vieira, M.: How to Advance TPC Benchmarks with Dependability Aspects. In: Nambiar, R., Poess, M. (eds.) TPCTC 2010. LNCS, vol. 6417, pp. 57–72. Springer, Heidelberg (2011)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2012 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Li, Y., Levine, C. (2012). Extending TPC-E to Measure Availability in Database Systems. In: Nambiar, R., Poess, M. (eds) Topics in Performance Evaluation, Measurement and Characterization. TPCTC 2011. Lecture Notes in Computer Science, vol 7144. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-32627-1_8

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-32627-1_8

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-32626-4

  • Online ISBN: 978-3-642-32627-1

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics