article thumbnail

Does SQL Server 2016 Require Trace Flag -T8048?

SQL Server According to Bob

Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Bob Dorr – Principal Software Engineer SQL Server. The three types of CMemThread partitioning and associated details are described in my previous post: [link].

Servers 40
article thumbnail

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

SQL Server According to Bob

This effort resulted in: · Changes to the SQL Server Engine · Changes to the SQL Server Linux Host Extension · Validation with the Windows Storage team · Validation with Windows Hyper-V team · Validation with Windows Azure Storage team · Conversations with Red Hat, HP, SUSE and Intel · Changes in the Linux file system. O_NONBLOCK.

Servers 90