Exploiting intel optane SSD for microsoft SQL server

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

doi:10.1145/3329785.3329916

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 proceeding › Conference contribution

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 language	English
Title of host publication	15th International Workshop on Data Management on New Hardware, DaMoN 2019
Publisher	Association for Computing Machinery
ISBN (Electronic)	9781450368018
DOIs	https://doi.org/10.1145/3329785.3329916
Publication status	Published - 2019 Jul 1
Event	15th International Workshop on Data Management on New Hardware, DaMoN 2019, Held with ACM SIGMOD/PODS 2019 - Amsterdam, Netherlands Duration: 2019 Jul 1 → …

Publication series

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

Conference

Conference	15th International Workshop on Data Management on New Hardware, DaMoN 2019, Held with ACM SIGMOD/PODS 2019
Country/Territory	Netherlands
City	Amsterdam
Period	19/7/1 → …

Bibliographical note

Publisher Copyright:
© 2019 ACM.

All Science Journal Classification (ASJC) codes

Software
Information Systems
Hardware and Architecture

Access to Document

10.1145/3329785.3329916

Cite this

Wu, K., Arpaci-Dusseau, A., Arpaci-Dusseau, R., Sen, R., & Park, K. (2019). Exploiting intel optane SSD for microsoft SQL server. In 15th International Workshop on Data Management on New Hardware, DaMoN 2019 [3329916] (Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems). Association for Computing Machinery. https://doi.org/10.1145/3329785.3329916

@inproceedings{adadfdb70fdc4fc184685f7bbfe5c31b,

title = "Exploiting intel optane SSD for microsoft SQL server",

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.",

author = "Kan Wu and Andrea Arpaci-Dusseau and Remzi Arpaci-Dusseau and Rathijit Sen and Kwanghyun Park",

note = "Publisher Copyright: {\textcopyright} 2019 ACM.; 15th International Workshop on Data Management on New Hardware, DaMoN 2019, Held with ACM SIGMOD/PODS 2019 ; Conference date: 01-07-2019",

year = "2019",

month = jul,

day = "1",

doi = "10.1145/3329785.3329916",

language = "English",

series = "Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems",

publisher = "Association for Computing Machinery",

booktitle = "15th International Workshop on Data Management on New Hardware, DaMoN 2019",

}

Wu, K, Arpaci-Dusseau, A, Arpaci-Dusseau, R, Sen, R & Park, K 2019, Exploiting intel optane SSD for microsoft SQL server. in 15th International Workshop on Data Management on New Hardware, DaMoN 2019., 3329916, Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, Association for Computing Machinery, 15th International Workshop on Data Management on New Hardware, DaMoN 2019, Held with ACM SIGMOD/PODS 2019, Amsterdam, Netherlands, 19/7/1. https://doi.org/10.1145/3329785.3329916

Exploiting intel optane SSD for microsoft SQL server. / Wu, Kan; Arpaci-Dusseau, Andrea; Arpaci-Dusseau, Remzi et al.

15th International Workshop on Data Management on New Hardware, DaMoN 2019. Association for Computing Machinery, 2019. 3329916 (Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

TY - GEN

T1 - Exploiting intel optane SSD for microsoft SQL server

AU - Wu, Kan

AU - Arpaci-Dusseau, Andrea

AU - Arpaci-Dusseau, Remzi

AU - Sen, Rathijit

AU - Park, Kwanghyun

PY - 2019/7/1

Y1 - 2019/7/1

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=85074453536&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85074453536&partnerID=8YFLogxK

U2 - 10.1145/3329785.3329916

DO - 10.1145/3329785.3329916

M3 - Conference contribution

AN - SCOPUS:85074453536

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

BT - 15th International Workshop on Data Management on New Hardware, DaMoN 2019

PB - Association for Computing Machinery

T2 - 15th International Workshop on Data Management on New Hardware, DaMoN 2019, Held with ACM SIGMOD/PODS 2019

Y2 - 1 July 2019

ER -

Exploiting intel optane SSD for microsoft SQL server

Abstract

Publication series

Conference

Bibliographical note

All Science Journal Classification (ASJC) codes

Access to Document

Other files and links

Fingerprint

Cite this