SQL Server According to Bob

MARCH 18, 2018

The changes made in SQL Server 2017 CU4 improve resource usage on smaller machines, such as a VM or Container used for testing and development. The calculation was based on architecture only Default-Worker-Count = (starting count x86=256 : x64=512) + (## of workers per CPU on the system [x86=8 : x64=16]). What Is A Small System?

Servers 40

Servers Best Practices Software Engineering Operating System 40

SQL Server According to Bob

MAY 19, 2019

The reduction effort started when we shipped SQL Server 2017 ( [link].) Demand paging is the ability for the operating system to copy a disk page into physical memory only if an attempt is made to access that page. SQL Server 2017. Bob Dorr – Principal Software Engineer SQL Server. . Demand Paging.

IoT 61

IoT Servers Development Cache 61

SQL Server According to Bob

DECEMBER 18, 2018

Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be Microsoft SQL Server Database Engine Input/Output Requirements.

Servers 90

Servers Media Cache Storage 90