Memory performance of DSS commercial workloads in shared-memory multiprocessors

Pedro Trancoso, Josep L. Larriba-Pey, Zheng Zhang, Josep Torrellas

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Although cache-coherent shared-memory multiprocessors are often used to run commercial workloads, little work has been done to characterize how well these machines support such workloads. In particular, we do not have much insight into the demands of commercial workloads on the memory subsystem of these machines. In this paper, we analyze in detail the memory access patterns of several queries that are representative of Decision Support System (DSS) databases. Our analysis shows that the memory use of queries differs largely depending on how the queries access the database data, namely via indices or by sequentially scanning the records. The former queries, which we call Index queries, suffer most of their shared-data misses on indices and on lock-related metadata structures. The latter queries, which we call Sequential queries, suffer most of their shared-data misses on the database records as they are scanned. An analysis of the data locality in the queries shows that both Index and Sequential queries exhibit spatial locality and, therefore, can benefit from relatively long cache lines. interestingly, shared data is reused very little inside queries. However, there is data reuse across Sequential queries. Finally, we show that the performance of Sequential queries can be improved moderately with data prefetching.

Original languageEnglish (US)
Title of host publicationIEEE High-Performance Computer Architecture Symposium Proceedings
Editors Anon
PublisherIEEE
Pages250-260
Number of pages11
StatePublished - 1997
EventProceedings of the 1997 3rd International Symposium on High-Performance Computer Architecture, HPCA - San Antonio, TX, USA
Duration: Feb 1 1997Feb 5 1997

Other

OtherProceedings of the 1997 3rd International Symposium on High-Performance Computer Architecture, HPCA
CitySan Antonio, TX, USA
Period2/1/972/5/97

    Fingerprint

ASJC Scopus subject areas

  • Engineering(all)

Cite this

Trancoso, P., Larriba-Pey, J. L., Zhang, Z., & Torrellas, J. (1997). Memory performance of DSS commercial workloads in shared-memory multiprocessors. In Anon (Ed.), IEEE High-Performance Computer Architecture Symposium Proceedings (pp. 250-260). IEEE.