article thumbnail

How It Works (It Just Runs Faster): Non-Volatile Memory SQL Server Tail Of Log Caching on NVDIMM

SQL Server According to Bob

SQL Server 2016 Service Pack 1 (all SKUs) , in combination with Windows Server 2016 (All SKUs) or Windows 10 Client introduces non-volatile memory support for the tail of the log file (LDF) which can significantly increase transaction throughput. SQL Server 2016 is designed to detect non-volatile storage devices.

Cache 40
article thumbnail

SQL Server on Linux: ELF and PE Images Just Work

SQL Server According to Bob

By March of 2016 Slava had convinced me to join the team. Without going into details, you boot your laptop or server and don’t give a thought about the binary format(s) of the operation system. The computer works the same way if made by IBM, HP, Dell or other vendor no matter what the operating system.

Servers 40
article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

The operating system signals completion when the I/O stack finishes the request. Linux provides different system calls (syscall)/commands for asynchronous behavior. Using the Hyper-V, PowerShell cmdlets, from Windows 2016, you can configure Fua reporting for the guest virtual machine. $a Related References.

Servers 90