{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,16]],"date-time":"2026-02-16T16:19:20Z","timestamp":1771258760889,"version":"3.50.1"},"reference-count":68,"publisher":"Association for Computing Machinery (ACM)","issue":"11","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2025,7]]},"abstract":"<jats:p>SSDs are hardware and software systems whose design involves complex and undocumented trade-offs between cost, energy consumption and performance. This complexity is hidden behind standard interfaces and a few headline specifications, such as capacity, sequential, and random performance. As a result, database system designers often assume that SSDs are interchangeable commodities and regularly use a single SSD model to evaluate database performance. Does it matter which SSD model is provisioned for a database system? If yes, how to choose the right one? These are the questions we address in this paper. We study the performance characteristics of commercial data center SSDs, highlighting the limitations of current standard metrics in capturing their true behavior. We conduct experiments on nine SSDs from major vendors, revealing significant differences in performance despite similar headline specifications. We show that the choice of SSD matters for database system performance. We propose a new benchmark, SSD-iq, which introduces four additional metrics to better characterize SSD performance, particularly for write-intensive workloads. Incidentally, our work should encourage vendors to optimize SSD controllers using more comprehensive and transparent performance criteria.<\/jats:p>","DOI":"10.14778\/3749646.3749694","type":"journal-article","created":{"date-parts":[[2025,9,4]],"date-time":"2025-09-04T17:55:06Z","timestamp":1757008506000},"page":"4295-4308","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":2,"title":["SSD-iq: Uncovering the Hidden Side of SSD Performance"],"prefix":"10.14778","volume":"18","author":[{"given":"Gabriel","family":"Haas","sequence":"first","affiliation":[{"name":"Technische Universit\u00e4t M\u00fcnchen and University of Copenhagen"}]},{"given":"Bohyun","family":"Lee","sequence":"additional","affiliation":[{"name":"Technische Universit\u00e4t M\u00fcnchen"}]},{"given":"Philippe","family":"Bonnet","sequence":"additional","affiliation":[{"name":"University of Copenhagen"}]},{"given":"Viktor","family":"Leis","sequence":"additional","affiliation":[{"name":"Technische Universit\u00e4t M\u00fcnchen"}]}],"member":"320","published-online":{"date-parts":[[2025,9,4]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.14778\/3583140.3583157"},{"key":"e_1_2_1_2_1","doi-asserted-by":"crossref","unstructured":"Michael Allison Arun George Javier Gonzalez Dan Helmick Roshan Nair and Vivek Shah. 2025. Towards Efficient Flash Caches with Emerging NVMe Flexible Data Placement SSDs. In Eurosys.","DOI":"10.1145\/3689031.3696091"},{"key":"e_1_2_1_3_1","unstructured":"Apache. 2016. Apache Commons Random Number Generator. https:\/\/github.com\/apache\/commons-rng\/blob\/master\/commons-rng-sampling\/src\/main\/java\/org\/apache\/commons\/rng\/sampling\/distribution\/RejectionInversionZipfSampler.java."},{"key":"e_1_2_1_4_1","unstructured":"Jens Axboe. 2025. fio: Flexible I\/O Tester. https:\/\/github.com\/axboe\/fio."},{"key":"e_1_2_1_5_1","volume-title":"Gregory R. Ganger, and George Amvrosiadis.","author":"Bj\u00f8rling Matias","year":"2021","unstructured":"Matias Bj\u00f8rling, Abutalib Aghayev, Hans Holmberg, Aravind Ramesh, Damien Le Moal, Gregory R. Ganger, and George Amvrosiadis. 2021. ZNS: Avoiding the Block Interface Tax for Flash-based SSDs. In USENIX ATC. 689\u2013703."},{"key":"e_1_2_1_6_1","unstructured":"Matias Bj\u00f8rling Javier Gonz\u00e1lez and Philippe Bonnet. 2017. LightNVM: The Linux Open-Channel SSD Subsystem. In FAST. 359\u2013374."},{"key":"e_1_2_1_7_1","unstructured":"Luc Bouganim Bj\u00f6rn \u00de\u00f3r J\u00f3nsson and Philippe Bonnet. 2009. uFLIP: Understanding Flash IO Patterns. In CIDR."},{"key":"e_1_2_1_8_1","doi-asserted-by":"crossref","unstructured":"Li-Pin Chang. 2007. On efficient wear leveling for large-scale flash-memory storage systems. In SAC. 1126\u20131130.","DOI":"10.1145\/1244002.1244248"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1109\/TC.2009.134"},{"key":"e_1_2_1_10_1","volume-title":"Garbage Collection Techniques for Flash-Resident Page-Mapping FTLs. CoRR abs\/1504.01666","author":"Dayan Niv","year":"2015","unstructured":"Niv Dayan and Philippe Bonnet. 2015. Garbage Collection Techniques for Flash-Resident Page-Mapping FTLs. CoRR abs\/1504.01666 (2015)."},{"key":"e_1_2_1_11_1","volume-title":"Modelling and Managing SSD Write-amplification. CoRR abs\/1504.00229","author":"Dayan Niv","year":"2015","unstructured":"Niv Dayan, Luc Bouganim, and Philippe Bonnet. 2015. Modelling and Managing SSD Write-amplification. CoRR abs\/1504.00229 (2015)."},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/1842722.1842723"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/2577384"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732240.2732246"},{"key":"e_1_2_1_15_1","first-page":"1","article-title":"Limplock: understanding the impact of limpware on scale-out cloud systems","volume":"14","author":"Do Thanh","year":"2013","unstructured":"Thanh Do, Mingzhe Hao, Tanakorn Leesatapornwongsa, Tiratat Patana-anake, and Haryadi S. Gunawi. 2013. Limplock: understanding the impact of limpware on scale-out cloud systems. In SoCC. 14:1\u201314:14.","journal-title":"SoCC."},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1109\/cluster52292.2023.00018"},{"key":"e_1_2_1_17_1","unstructured":"Arun George. 2025. Introduction to Flexible Data Placement: A New Era of Optimized Data Management. https:\/\/download.semiconductor.samsung.com\/resources\/white-paper\/FDP_Whitepaper_102423_Final.pdf."},{"key":"e_1_2_1_18_1","unstructured":"Gabriel Haas. 2025. Commit 2a96057: ssd latency experiment. https:\/\/github.com\/leanstore\/leanstore\/commit\/2a96057"},{"key":"e_1_2_1_19_1","unstructured":"Gabriel Haas. 2025. Commit e0c5a7d: SSD WAF experiment with steady TPC-C. https:\/\/github.com\/leanstore\/leanstore\/commit\/e0c5a7d"},{"key":"e_1_2_1_20_1","volume-title":"Managing Very Large Datasets on Directly Attached NVMe Arrays. Scalable Data Management for Future Hardware","author":"Haas Gabriel","year":"2025","unstructured":"Gabriel Haas, Adnan Alhomssi, and Viktor Leis. 2025. Managing Very Large Datasets on Directly Attached NVMe Arrays. Scalable Data Management for Future Hardware (2025), 223."},{"key":"e_1_2_1_21_1","unstructured":"Gabriel Haas Michael Haubenschild and Viktor Leis. 2020. Exploiting directly-attached NVMe arrays in DBMS. In CIDR. https:\/\/www.cidrdb.org\/cidr2020\/papers\/p16-haas-cidr20.pdf"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.14778\/3598581.3598584"},{"key":"e_1_2_1_23_1","volume-title":"An in-depth study of correlated failures in production SSD-based data centers. File Storage Technol","author":"Han Shujie","year":"2021","unstructured":"Shujie Han, P Lee, Fan Xu, Yi Liu, Cheng He, and Jiongzhou Liu. 2021. An in-depth study of correlated failures in production SSD-based data centers. File Storage Technol (2021), 417\u2013429. https:\/\/www.usenix.org\/conference\/fast21\/presentation\/han"},{"key":"e_1_2_1_24_1","volume-title":"Gunawi","author":"Hao Mingzhe","year":"2016","unstructured":"Mingzhe Hao, Gokul Soundararajan, Deepak R. Kenchammana-Hosekote, Andrew A. Chien, and Haryadi S. Gunawi. 2016. The Tail at Store: A Revelation from Millions of Hours of Disk and SSD Deployments. In FAST. 263\u2013276."},{"key":"e_1_2_1_25_1","volume-title":"Arpaci-Dusseau","author":"He Jun","year":"2017","unstructured":"Jun He, Sudarsun Kannan, Andrea C. Arpaci-Dusseau, and Remzi H. Arpaci-Dusseau. 2017. The Unwritten Contract of Solid State Drives. In EuroSys. 127\u2013144."},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/3576855"},{"key":"e_1_2_1_27_1","volume-title":"Pletka","author":"Hu Xiao-Yu","year":"2009","unstructured":"Xiao-Yu Hu, Evangelos Eleftheriou, Robert Haas, Ilias Iliadis, and Roman A. Pletka. 2009. Write amplification analysis in flash-based solid state drives. In SYSTOR. 10."},{"key":"e_1_2_1_28_1","unstructured":"JEDEC Solid State Technology Association. 2010. Solid-State Drive (SSD) Requirements and Endurance Test Method. JESD218A."},{"key":"e_1_2_1_29_1","unstructured":"JEDEC SOLID STATE TECHNOLOGY ASSOCIATION. 2022. Solid-State Drive (SSD) Endurance Workloads. JESD219.A01."},{"key":"e_1_2_1_30_1","doi-asserted-by":"crossref","unstructured":"Song Jiang Lei Zhang XinHao Yuan Hao Hu and Yu Chen. 2011. S-FTL: An efficient address translation for flash memory by exploiting spatial locality. In MSST. 1\u201312.","DOI":"10.1109\/MSST.2011.5937215"},{"key":"e_1_2_1_31_1","doi-asserted-by":"crossref","unstructured":"Dawoon Jung Yoon-Hee Chae Heeseung Jo Jinsoo Kim and Joonwon Lee. 2007. A group-based wear-leveling algorithm for large-capacity flash memory storage systems. In CASES. 160\u2013164.","DOI":"10.1145\/1289881.1289911"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.14778\/3372716.3372724"},{"key":"e_1_2_1_33_1","unstructured":"Jeong-Uk Kang Jeeseok Hyun Hyunjoo Maeng and Sangyeun Cho. 2014. The Multi-streamed Solid-State Drive. In HotStorage."},{"key":"e_1_2_1_34_1","first-page":"2004","article-title":"2R: Efficiently Isolating Cold Pages in Flash Storages","volume":"13","author":"Kang Minji","year":"2020","unstructured":"Minji Kang, Soyee Choi, Gihwan Oh, and Sang Won Lee. 2020. 2R: Efficiently Isolating Cold Pages in Flash Storages. PVLDB 13, 11 (2020), 2004\u20132017.","journal-title":"PVLDB"},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1145\/3126537"},{"key":"e_1_2_1_36_1","volume-title":"USENIX Annu Tech Conf","author":"Kim Jaeho","year":"2019","unstructured":"Jaeho Kim, Kwanghyun Lim, Youngdon Jung, Sungjin Lee, Changwoo Min, and S Noh. 2019. Alleviating garbage collection interference through spatial separation in all flash arrays. USENIX Annu Tech Conf (2019), 799\u2013812. https:\/\/www.usenix.org\/conference\/atc19\/presentation\/kim-jaeho"},{"key":"e_1_2_1_37_1","volume-title":"Tae Jun Ham, and Jae W. Lee","author":"Kim Shine","year":"2019","unstructured":"Shine Kim, Jonghyun Bae, Hakbeom Jang, Wenjing Jin, Jeonghun Gong, SeungYeon Lee, Tae Jun Ham, and Jae W. Lee. 2019. Practical Erase Suspension for Modern Low-latency SSDs. In USENIX ATC. USENIX Association, 813\u2013820."},{"key":"e_1_2_1_38_1","unstructured":"Ricardo Koller and Raju Rangaswami. 2008. FIU IODedup Traces (SNIA IOTTA Trace Set 391). In SNIA IOTTA Trace Repository Geoff Kuenning (Ed.). Storage Networking Industry Association. http:\/\/iotta.snia.org\/traces\/block-io\/390?only=391"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1145\/1837915.1837921"},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/3596205"},{"key":"e_1_2_1_41_1","volume-title":"Principles of Database and Solid-State Drive Co-Design","author":"Lerner Alberto","unstructured":"Alberto Lerner and Philippe Bonnet. 2025. Principles of Database and Solid-State Drive Co-Design. Springer. https:\/\/link.springer.com\/book\/9783031578762"},{"key":"e_1_2_1_42_1","volume-title":"CIDR 2020, 10th Conference on Innovative Data Systems Research, Amsterdam, The Netherlands, January 12\u201315, 2020, Online Proceedings","author":"Lerner Alberto","year":"2020","unstructured":"Alberto Lerner, Jaewook Kwak, Sangjin Lee, Kibin Park, Yong Ho Song, and Philippe Cudr\u00e9-Mauroux. 2020. It takes two: Instrumenting the interaction between in-memory databases and solid-state drives. CIDR 2020, 10th Conference on Innovative Data Systems Research, Amsterdam, The Netherlands, January 12\u201315, 2020, Online Proceedings (2020), 1\u20138. https:\/\/folia.unifr.ch\/rerodoc\/330495"},{"key":"e_1_2_1_43_1","unstructured":"Jinhong Li Qiuping Wang Patrick P. C. Lee and Chao Shi. 2020. An In-Depth Analysis of Cloud Block Storage Workloads in Large-Scale Production. In IISWC. 37\u201347."},{"key":"e_1_2_1_44_1","unstructured":"Ruiming Lu Erci Xu Yiming Zhang Zhaosheng Zhu Mengtian Wang Zongpeng Zhu Guangtao Xue Minglu Li and Jiesheng Wu. 2022. NVMe SSD Failures in the Field: the Fail-Stop and the Fail-Slow. In USENIX ATC. 1005\u20131020."},{"key":"e_1_2_1_45_1","unstructured":"Stathis Maneas Kaveh Mahdaviani Tim Emami and Bianca Schroeder. 2022. Operational Characteristics of SSDs in Enterprise Storage Systems: A Large-Scale Field Study. In FAST. 165\u2013180."},{"key":"e_1_2_1_46_1","volume-title":"Ganger","author":"McAllister Sara","year":"2024","unstructured":"Sara McAllister, Yucong Wang, Benjamin Berg, Daniel S. Berger, George Amvrosiadis, Nathan Beckmann, and Gregory R. Ganger. 2024. FairyWREN: A Sustainable Cache for Emerging Write-Read-Erase Flash Interfaces. In OSDI. 745\u2013764."},{"key":"e_1_2_1_47_1","unstructured":"John Rudelic Michael Allison. 2023. What is the NVM Express\u00ae Flexible Data Placement (FDP)? https:\/\/www.snia.org\/educational-library\/what-nvm-express%C2%AE-flexible-data-placement-fdp-2023."},{"key":"e_1_2_1_48_1","unstructured":"MSR. 2018. MSR Cambridge Traces (SNIA IOTTA Trace Set 388). In SNIA IOTTA Trace Repository Geoff Kuenning (Ed.). Storage Networking Industry Association. http:\/\/iotta.snia.org\/traces\/block-io?only=388"},{"key":"e_1_2_1_49_1","volume-title":"Rejuvenator: A static wear leveling algorithm for NAND flash memory with minimized overhead. In MSST. 1\u201312.","author":"Murugan Muthukumar","year":"2011","unstructured":"Muthukumar Murugan and David Hung-Chang Du. 2011. Rejuvenator: A static wear leveling algorithm for NAND flash memory with minimized overhead. In MSST. 1\u201312."},{"key":"e_1_2_1_50_1","volume-title":"The Promise of NVMe Flexible Data Placement in Data Center Sustainability. In SNIA Storage Developer Conference (SDC24)","author":"Nair Roshan","year":"2024","unstructured":"Roshan Nair and Arun George. 2024. The Promise of NVMe Flexible Data Placement in Data Center Sustainability. In SNIA Storage Developer Conference (SDC24)."},{"key":"e_1_2_1_51_1","unstructured":"Roshan Nair and Arun George. 2024. The Promise of NVMe Flexible Data Placement in Data Center Sustainability. URL: https:\/\/www.sniadeveloper.org\/events\/agenda\/session\/698."},{"key":"e_1_2_1_52_1","doi-asserted-by":"publisher","DOI":"10.1145\/1416944.1416949"},{"key":"e_1_2_1_53_1","doi-asserted-by":"publisher","DOI":"10.1145\/3725328"},{"key":"e_1_2_1_54_1","first-page":"0d","article-title":"NVM Command Set Specification. NVM Express","volume":"1","author":"Express NVM","year":"2023","unstructured":"NVM Express, Inc 2023. NVM Command Set Specification. NVM Express, Inc. Revision 1.0d.","journal-title":"Inc. Revision"},{"key":"e_1_2_1_55_1","volume-title":"Thesios: Synthesizing Accurate Counterfactual I\/O Traces from I\/O Samples. In ASPLOS. 1016\u20131032.","author":"Phothilimthana Phitchaya Mangpo","year":"2024","unstructured":"Phitchaya Mangpo Phothilimthana, Saurabh Kadekodi, Soroush Ghodrati, Selene Moon, and Martin Maas. 2024. Thesios: Synthesizing Accurate Counterfactual I\/O Traces from I\/O Samples. In ASPLOS. 1016\u20131032."},{"key":"e_1_2_1_56_1","unstructured":"Alma Riska and Erik Riedel. 2006. Disk Drive Level Workload Characterization. In USENIX ATC. 97\u2013102."},{"key":"e_1_2_1_57_1","unstructured":"Ross Stenfort Ta-Yu Wu and Lee Prewitt. 2020. NVMe Cloud SSD Specification. Open Compute Project (OCP). Version 1.0a (06262020)."},{"key":"e_1_2_1_58_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536360.2536372"},{"key":"e_1_2_1_59_1","volume-title":"Filebench: A Flexible Framework for File System Benchmarking. login - The Usenix Magazine 41","author":"Tarasov Vasily","year":"2016","unstructured":"Vasily Tarasov, E Zadok, and S Shepler. 2016. Filebench: A Flexible Framework for File System Benchmarking. login - The Usenix Magazine 41 (2016). https:\/\/www.semanticscholar.org\/paper\/Filebench%3A-A-Flexible-Framework-for-File-System-Tarasov-Zadok\/b5c260b4cc4110abd7f05302b3e6109011a772bb"},{"key":"e_1_2_1_60_1","unstructured":"TPC. 2025. TPC-C Homepage. https:\/\/www.tpc.org\/tpcc\/. Accessed: 2025-4-29."},{"key":"e_1_2_1_61_1","unstructured":"Kristian V\u00e4tt\u00f6. 2025. The OCZ Vector 180 SSD Review. https:\/\/www.anandtech.com\/show\/9009\/ocz-vector-180-240gb-480gb-960gb-ssd-review."},{"key":"e_1_2_1_62_1","volume-title":"Reducing SSD read latency via NAND flash program and erase suspension","author":"Wu Guanying","unstructured":"Guanying Wu and Xubin He. 2012. Reducing SSD read latency via NAND flash program and erase suspension. In FAST. USENIX Association, 10."},{"key":"e_1_2_1_63_1","unstructured":"Gala Yadgar and Moshe Gabel. 2016. Avoiding the Streetlight Effect: I\/O Workload Analysis with SSDs in Mind. In HotStorage."},{"key":"e_1_2_1_64_1","unstructured":"Gala Yadgar Moshe Gabel Shehbaz Jaffer and Bianca Schroeder. 2018. YCSB RocksDB SSD Traces (SNIA IOTTA Trace Set 28568). In SNIA IOTTA Trace Repository Geoff Kuenning (Ed.). Storage Networking Industry Association. http:\/\/iotta.snia.org\/traces\/block-io?only=28568"},{"key":"e_1_2_1_65_1","doi-asserted-by":"publisher","DOI":"10.1145\/3423137"},{"key":"e_1_2_1_66_1","doi-asserted-by":"publisher","DOI":"10.1145\/3121133"},{"key":"e_1_2_1_67_1","doi-asserted-by":"publisher","DOI":"10.5555\/3357062.3357089"},{"key":"e_1_2_1_68_1","first-page":"1","article-title":"An efficient page-level FTL to optimize address translation in flash memory","volume":"12","author":"Zhou You","year":"2015","unstructured":"You Zhou, Fei Wu, Ping Huang, Xubin He, Changsheng Xie, and Jian Zhou. 2015. An efficient page-level FTL to optimize address translation in flash memory. In EuroSys. 12:1\u201312:16.","journal-title":"EuroSys."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3749646.3749694","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,5]],"date-time":"2025-09-05T03:18:03Z","timestamp":1757042283000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3749646.3749694"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,7]]},"references-count":68,"journal-issue":{"issue":"11","published-print":{"date-parts":[[2025,7]]}},"alternative-id":["10.14778\/3749646.3749694"],"URL":"https:\/\/doi.org\/10.14778\/3749646.3749694","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2025,7]]},"assertion":[{"value":"2025-09-04","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}