short-paper

Exploiting Intel Optane SSD for Microsoft SQL Server

Authors:

Kan Wu,

Andrea Arpaci-Dusseau,

Remzi Arpaci-Dusseau,

Rathijit Sen,

Kwanghyun ParkAuthors Info & Claims

DaMoN'19: Proceedings of the 15th International Workshop on Data Management on New Hardware

Article No.: 15, Pages 1 - 3

https://doi.org/10.1145/3329785.3329916

Published: 01 July 2019 Publication History

Get Access

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.

References

[1]

Assaf Eisenman, Darryl Gardner, Islam AbdelRahman, Jens Axboe, Siying Dong, Kim Hazelwood, Chris Petersen, Asaf Cidon, and Sachin Katti. 2018. Reducing DRAM footprint with NVM in facebook. In Proceedings of the Thirteenth EuroSys Conference. ACM, 42.

Digital Library

Google Scholar

[2]

Assaf Eisenman, Maxim Naumov, Darryl Gardner, Misha Smelyanskiy, Sergey Pupyrev, Kim Hazelwood, Asaf Cidon, and Sachin Katti. 2018. Bandana: Using non-volatile memory for storing deep learning models. arXiv preprint arXiv:1811.05922 (2018).

Google Scholar

[3]

Frank T Hady, Annie Foong, Bryan Veal, and Dan Williams. 2017. Platform storage performance with 3D XPoint technology. Proc. IEEE 105, 9 (2017), 1822--1833.

Crossref

Google Scholar

[4]

Intel. 2019. 3D XPoint. https://en.wikipedia.org/wiki/3D_XPoint.

Google Scholar

[5]

Intel. 2019. IMDT use case, memcached. https://www.intel.com/content/www/us/en/support/articles/000026359/memory-and-storage/datacenter-ssds.html.

Google Scholar

[6]

Intel. 2019. IMDT use case, redis. https://www.intel.com/content/dam/www/public/us/en/documents/solution-briefs/imdt-solution-brief-in-memory-data-store.pdf.

Google Scholar

[7]

Intel. 2019. IMDT use case, Spark. https://www.intel.com/content/www/us/en/software/apache-spark-optimization-technology-brief.html.

Google Scholar

[8]

Intel. 2019. Intel Memory Drive Technology. https://www.intel.com/content/www/us/en/software/intel-memory-drive-technology.html.

Google Scholar

[9]

Intel. 2019. Intel Optane DC Persistent Memory. https://www.intel.com/content/www/us/en/architecture-and-technology/optane-dc-persistent-memory.html.

Google Scholar

[10]

Intel. 2019. Intel Optane Memory. https://www.intel.com/content/www/us/en/architecture-and-technology/optane-memory.html.

Google Scholar

[11]

Intel. 2019. Intel Optane SSD. https://www.intel.com/content/www/us/en/products/memory-storage/solid-state-drives/datacenter-ssds/optane-dc-p4800x-series.html.

Google Scholar

[12]

Microsoft. 2019. Microsoft SQL Server. https://www.microsoft.com/en-us/sql-server/default.aspx.

Google Scholar

[13]

Samsung. 2019. Samsung 970 Pro. https://www.samsung.com/semiconductor/minisite/ssd/product/consumer/970pro/.

Google Scholar

[14]

Kan Wu, Andrea Arpaci-Dusseau, and Remzi Arpaci-Dusseau. 2019. Towards an Unwritten Contract of Intel Optane SSD. In 11th USENIX Workshop on Hot Topics in Storage and File Systems (HotStorage 19). USENIX Association, Renton, WA.

Digital Library

Google Scholar

Cited By

View all

Zhou RZhang YLi CZhou KWang PZhang GZhang JZhang G(2024)HyperDB: a Novel Key Value Store for Reducing Background Traffic in Heterogeneous SSD StorageProceedings of the 53rd International Conference on Parallel Processing10.1145/3673038.3673153(453-463)Online publication date: 12-Aug-2024
https://dl.acm.org/doi/10.1145/3673038.3673153
Koutsoukos DBhartia RFriedman MKlimovic AAlonso G(2023)NVM: Is it Not Very Meaningful for Databases?Proceedings of the VLDB Endowment10.14778/3603581.360358616:10(2444-2457)Online publication date: 1-Jun-2023
https://dl.acm.org/doi/10.14778/3603581.3603586
Raina ALu JCidon AFreedman MAamodt TJerger NSwift M(2023)Efficient Compactions between Storage Tiers with PrismDBProceedings of the 28th ACM International Conference on Architectural Support for Programming Languages and Operating Systems, Volume 310.1145/3582016.3582052(179-193)Online publication date: 25-Mar-2023
https://dl.acm.org/doi/10.1145/3582016.3582052
Show More Cited By

Recommendations

Exploiting Intra-Request Slack to Improve SSD Performance
Asplos'17

With Solid State Disks (SSDs) offering high degrees of parallelism, SSD controllers place data and direct requests to exploit the maximum offered hardware parallelism. In the quest to maximize parallelism and utilization, sub-requests of a request that ...
Exploiting Intra-Request Slack to Improve SSD Performance
ASPLOS '17: Proceedings of the Twenty-Second International Conference on Architectural Support for Programming Languages and Operating Systems

With Solid State Disks (SSDs) offering high degrees of parallelism, SSD controllers place data and direct requests to exploit the maximum offered hardware parallelism. In the quest to maximize parallelism and utilization, sub-requests of a request that ...
A high-performance and endurable SSD cache for parity-based RAID

Solid-state drives (SSDs) have been widely used as caching tier for disk-based RAID systems to speed up data-intensive applications. However, traditional cache schemes fail to effectively boost the parity-based RAID storage systems (e.g., RAID-5/6), ...

Comments

Information & Contributors

Information

Published In

DaMoN'19: Proceedings of the 15th International Workshop on Data Management on New Hardware

July 2019

150 pages

ISBN:9781450368018

DOI:10.1145/3329785

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 July 2019

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Short-paper
Research
Refereed limited

Conference

SIGMOD/PODS '19

Sponsor:

SIGMOD

SIGMOD/PODS '19: International Conference on Management of Data

July 1, 2019

Amsterdam, Netherlands

Acceptance Rates

Overall Acceptance Rate 94 of 127 submissions, 74%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

10
Total Citations
View Citations
416
Total Downloads

Downloads (Last 12 months)23
Downloads (Last 6 weeks)5

Reflects downloads up to 03 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Zhou RZhang YLi CZhou KWang PZhang GZhang JZhang G(2024)HyperDB: a Novel Key Value Store for Reducing Background Traffic in Heterogeneous SSD StorageProceedings of the 53rd International Conference on Parallel Processing10.1145/3673038.3673153(453-463)Online publication date: 12-Aug-2024
https://dl.acm.org/doi/10.1145/3673038.3673153
Koutsoukos DBhartia RFriedman MKlimovic AAlonso G(2023)NVM: Is it Not Very Meaningful for Databases?Proceedings of the VLDB Endowment10.14778/3603581.360358616:10(2444-2457)Online publication date: 1-Jun-2023
https://dl.acm.org/doi/10.14778/3603581.3603586
Raina ALu JCidon AFreedman MAamodt TJerger NSwift M(2023)Efficient Compactions between Storage Tiers with PrismDBProceedings of the 28th ACM International Conference on Architectural Support for Programming Languages and Operating Systems, Volume 310.1145/3582016.3582052(179-193)Online publication date: 25-Mar-2023
https://dl.acm.org/doi/10.1145/3582016.3582052
Li STu FLiu LLin JWang ZKang YDing YXie YSolihin YHeinrich M(2023)ECSSD: Hardware/Data Layout Co-Designed In-Storage-Computing Architecture for Extreme ClassificationProceedings of the 50th Annual International Symposium on Computer Architecture10.1145/3579371.3589093(1-14)Online publication date: 17-Jun-2023
https://dl.acm.org/doi/10.1145/3579371.3589093
Lee HChoi KLee HSim J(2023)SDM: Sharing-enabled Disaggregated Memory System with Cache Coherent Compute Express LinkProceedings of the 32nd International Conference on Parallel Architectures and Compilation Techniques10.1109/PACT58117.2023.00016(86-98)Online publication date: 21-Oct-2023
https://dl.acm.org/doi/10.1109/PACT58117.2023.00016
Oliveira GGhose SGómez-Luna JBoroumand ASavery ARao SQazi SGrignou GThakur RShiu EMutlu O(2023)Extending Memory Capacity in Modern Consumer Systems With Emerging Non-Volatile Memory: Experimental Analysis and Characterization Using the Intel Optane SSDIEEE Access10.1109/ACCESS.2023.331788411(105843-105871)Online publication date: 2023
https://doi.org/10.1109/ACCESS.2023.3317884
Liu XPan YLi YWang GLiu X(2022)An NVM SSD-based High Performance Query Processing Framework for Search EnginesIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2022.3160557(1-1)Online publication date: 2022
https://doi.org/10.1109/TKDE.2022.3160557
Didona DIoannou NStoica RKourtis K(2021)Toward a better understanding and evaluation of tree structures on flash SSDsProceedings of the VLDB Endowment10.14778/3430915.343092614:3(364-377)Online publication date: 9-Dec-2021
https://dl.acm.org/doi/10.14778/3430915.3430926
Akram SWang ZWrigstad T(2021)Exploiting Intel optane persistent memory for full text searchProceedings of the 2021 ACM SIGPLAN International Symposium on Memory Management10.1145/3459898.3463906(80-93)Online publication date: 22-Jun-2021
https://dl.acm.org/doi/10.1145/3459898.3463906
Mironov VChernykh IKulikov IMoskovsky AEpifanovsky EKudryavtsev A(2019)Performance Evaluation of the Intel Optane DC Memory With Scientific Benchmarks2019 IEEE/ACM Workshop on Memory Centric High Performance Computing (MCHPC)10.1109/MCHPC49590.2019.00008(1-6)Online publication date: Nov-2019
https://doi.org/10.1109/MCHPC49590.2019.00008

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Abstract

References

Cited By

Recommendations

Exploiting Intra-Request Slack to Improve SSD Performance

Exploiting Intra-Request Slack to Improve SSD Performance

A high-performance and endurable SSD cache for parity-based RAID

Comments

Information

Published In

Sponsors

Publisher

Publication History

Permissions

Check for updates

Qualifiers

Conference

Acceptance Rates

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Login options

Full Access

View options

PDF

eReader

Share

Share this Publication link

Share on social media

Affiliations