Remove 2016 Remove Azure Remove Monitoring Remove Software Engineering
article thumbnail

Does SQL Server 2016 Require Trace Flag -T8048?

SQL Server According to Bob

Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) NUMA partitioned, CMemThread objects to CPU partitioned based objects. Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Instead the design of CMemThread was updated.

Servers 40
article thumbnail

How It Works: SQL Server DTC (MSDTC and XA Transactions)

SQL Server According to Bob

Transaction Monitor/Manager – Coordinator. There is a technique that can be used with SQL Server (Windows, Azure or Linux) to support some DTC capabilities. Note: SQL Server Azure does not support DTC. However, this technique can be used with SQL Server Azure as well. Distributed Transaction Coordination – Generic term.

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. make_durable*.

Servers 90