Exploiting intel optane SSD for microsoft SQL server

Kan Wu, Andrea Arpaci-Dusseau, Remzi Arpaci-Dusseau, Rathijit Sen, Kwanghyun Park

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

4 Citations (Scopus)

Abstract

New NVM-based devices provide unparalleled performance (i.e., significantly reduced latency) than Flash-based SSDs. In this paper, we look into exploiting an NVM-based block device - the Intel Optane SSD - as a caching layer for Microsoft SQL Server. We reveal that naive usage of Optane SSD can result in up to 23% higher query response time than Flash SSD. We explain the issues of simple caching by analyzing the I/O characteristics of Intel Optane SSD. To exploit Optane SSD as a caching layer, we propose an Optane SSD-aware caching strategy including an optimized cache replacement policy and a cache access filter.

Original languageEnglish
Title of host publication15th International Workshop on Data Management on New Hardware, DaMoN 2019
PublisherAssociation for Computing Machinery
ISBN (Electronic)9781450368018
DOIs
Publication statusPublished - 2019 Jul 1
Event15th International Workshop on Data Management on New Hardware, DaMoN 2019, Held with ACM SIGMOD/PODS 2019 - Amsterdam, Netherlands
Duration: 2019 Jul 1 → …

Publication series

NameProceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems

Conference

Conference15th International Workshop on Data Management on New Hardware, DaMoN 2019, Held with ACM SIGMOD/PODS 2019
Country/TerritoryNetherlands
CityAmsterdam
Period19/7/1 → …

Bibliographical note

Publisher Copyright:
© 2019 ACM.

All Science Journal Classification (ASJC) codes

  • Software
  • Information Systems
  • Hardware and Architecture

Fingerprint

Dive into the research topics of 'Exploiting intel optane SSD for microsoft SQL server'. Together they form a unique fingerprint.

Cite this