In this episode of Data Exposed, Scott welcomes Lindsey Allen, SQL Server Partner Group PM, and Tobias Klima, Windows Storage PM, to the show to discuss how persistent memory in Windows Server 2016 increases the performance of SQL Server 2016. Building on the video with Bob Ward and Bob Dorr in which they discuss some of the performance improvements to SQL Server 2016, Lindsey and Tobias begin by sharing the storage technology evolution over the past decade and how persistent memory plays a pivotal role in that evolution regarding capacity, latency, and IOPS. Storage class memory using nonvolatile memory.
From there, at the 6:43 mark Lindsey shares how SQL Server takes advantage of these technology improvements to significantly increase the performance of SQL Server 2016. Lindsey spends several quality minutes showing us an example illustrating how persistent memory performance is much better through NTFS DirectAccess (DAX) volumes over standard HDD and SDD storage. Quick a significance!
At the 15:00 minute mark we jump into a demo to show the impact persistent memory has on CPU utilization and IO. With IO being the bottleneck, CPU utilization isn't where it should be in many environments, so Lindsey runs through a couple of examples to illustrate how persistent memory removes the IO bottleneck and takes advantage of CPU. Great demo!