An empirical study of transaction throughput thrashing across multiple relational DBMSes

Young Kyoon Suh, Richard T. Snodgrass, Sabah Currim

Research output: Contribution to journalArticlepeer-review

5 Scopus citations


Modern DBMSes are designed to support many transactions running simultaneously. DBMS thrashing is indicated by the existence of a sharp drop in transaction throughput. Thrashing behavior in DBMSes is a serious concern to database administrators (DBAs) as well as to DBMS implementers. From an engineering perspective, therefore, it is of critical importance to understand the causal factors of DBMS thrashing. However, understanding the origin of thrashing in modern DBMSes is challenging, due to many factors that may interact with each other. This article aims to better understand the thrashing phenomenon across multiple DBMSes. We identify some of the underlying causes of DBMS thrashing. We then propose a novel structural causal model to explicate the relationships between various factors contributing to DBMS thrashing. Our model derives a number of specific hypotheses to be subsequently tested across DBMSes, providing empirical support for this model as well as important engineering implications for improvements in transaction processing.

Original languageEnglish (US)
Pages (from-to)119-136
Number of pages18
JournalInformation Systems
StatePublished - Jun 1 2017


  • DBMS Thrashing
  • Empirical Study
  • Factors
  • Structural Causal Model
  • Throughput
  • Transaction

ASJC Scopus subject areas

  • Software
  • Information Systems
  • Hardware and Architecture


Dive into the research topics of 'An empirical study of transaction throughput thrashing across multiple relational DBMSes'. Together they form a unique fingerprint.

Cite this