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

What Am I Working On (RDORR): SQL Server On Linux

SQL Server According to Bob

During this same timeframe my peers were releasing our providers natively, portions of.NET, sqlcmd, bcp and the numbers in the Azure VM world are showing Linux as a valuable asset. That is exactly what I started doing in Mar 2016. Bob Dorr – Principal Software Engineer SQL Server.

Servers 40
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

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

SQL Server According to Bob

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. This means there are no DTC components available for SQL Server 2017 on Linux. Helpful References.

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.

Servers 90