MSSQL Benchmark Testing on SANDISK SN861 SSD

This white paper presents the results of benchmark testing conducted by SANDISK on the SN861 SSD, focusing on maintaining high online transactional processing (OLTP) performance in memory-constrained environments. The testing utilized Microsoft SQL Server 2022 and the HammerDB benchmarking tool to simulate OLTP workloads. The document outlines the hardware and software setup, including the server specifications and the benchmarking methodology. It describes the TPROC-C benchmark used to assess performance, detailing how the tests were structured to evaluate the SSD's performance under varying memory constraints. The results indicate that the SANDISK SN861 SSD can sustain a high level of transactions per minute (TPM) even when DRAM is limited, achieving 72.4% performance at 32GB of DRAM. The findings highlight the SSD's capability to maintain effective performance under constrained conditions, making it suitable for enterprise database environments. The paper concludes with observations on the implications of these results for infrastructure teams managing performance in resource-limited scenarios.