2016, Servers and Software Engineering - Technology Performance Pulse

2016

Servers

Software Engineering

New Metadata-Only Column Changes in SQL Server 2016

SQL Performance

APRIL 17, 2020

When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Improvements in SQL Server 2016. The subject of this post is the additional changes that are enabled for metadata-only from SQL Server 2016 onward.

Servers

Servers Database Testing Efficiency

Does SQL Server 2016 Require Trace Flag -T8048?

SQL Server According to Bob

JUNE 22, 2016

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

Servers Azure Software Engineering Design

Join 5,000+

Insiders

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

Trending Sources

How It Works: SQL Server 2016 SSE/AVX Support

SQL Server According to Bob

JUNE 6, 2016

As indicated, SQL Server 2016 added the use of SSE and AVX instructions in various code paths to improve performance. This post will outline SQL Server’s decisions around SSE/AVX or software algorithm use. Bob Dorr – Principal Software Engineer SQL Server. Reference APIs such as: CryptDecrypt.

Servers

Servers Hardware Software Engineering Software

SQL 2016 – It Just Runs Faster Announcement

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. – [link].

Hardware

Hardware Software Engineering Transportation Scalability

SQL 2016–Install MSVC Patch Required

SQL Server According to Bob

JUNE 15, 2016

There is a MSVC, runtime library patch needed by SQL Server 2016 and without the patch the SQL Server service can simply terminate (crash.) This may not produce stack dumps and the SQL Server error log often looks like it simply terminates (no logging of shutdown.).

Software Engineering

Software Engineering Servers Database Engineering

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. Ryan Stonecipher – Principle SQL Server Software Engineer. SQL Server.

Hardware

Hardware Servers Cache Software Engineering

SQL Server Management Studio Provides–“XE Profiler”

SQL Server According to Bob

DECEMBER 26, 2017

Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Q uick XE Trace ’ capabilities. The feature is available in the latest SQL Server Management Studio (SSMS) release. Here is an example using the SQL Server SSMS 2017 against my SQL 2016 server.

Servers

Servers Software Engineering Engineering Availability

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

SQL Server According to Bob

NOVEMBER 8, 2016

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. As the following diagram shows the SQL Server Log Cache is in memory.

Cache

Cache Servers Media Storage

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

SQL Server According to Bob

JUNE 27, 2016

To some of you SQL Server On Linux is old news from various announcements made a couple of months ago. Yes, SQL Server runs on Linux! It was Jan 2015, in my previous supportability role, that I started looking at SQL Server on Linux. I proceeded to install an Ubuntu VM and the internal build of SQL Server on Linux.

Servers

Servers Games Azure Testing

How It Works: How SQL Server Determines Logical and Physical Processors

SQL Server According to Bob

JUNE 9, 2016

SQL Server, as outlined in the following post ( [link] ) adjusts to various processor configurations. I have received questions related to how SQL Server accomplishes the alignment on both bare metal and VM installations. SQL Server uses Windows APIs to determine the processors and package interactions. GetSystemInfo [link].

Servers

Servers Virtualization Tuning Architecture

SQL Server on Linux: ELF and PE Images Just Work

SQL Server According to Bob

JANUARY 5, 2017

Last March I moved from 22 years in SQL Server support to the SQL Server development team, working on SQL Server on Linux project and reporting to Slava Oks. As Slava highlights in his recent blog post , he also contacted me in early 2015 to assist with supportability of SQL Server on Linux. There are no burning secrets.

Servers

Servers Operating System C++ Software Engineering

Create Table – Disk vs In-Memory Optimized

SQL Server According to Bob

AUGUST 23, 2016

The creation of the XTP, common access DLL requires SQL Server to generate C code, invoke the C compiler and save the DLL into the XTP directory. Bob Dorr – Principal Software Engineer SQL Server. These are additional steps that a disk based table does not perform.

C++

C++ Software Engineering Servers Code

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

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story.

Servers

Servers Media Cache Storage

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

SQL Server According to Bob

JANUARY 28, 2018

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). The application then uses the SQL Server client (SQL Server ODBC for this example) to establish a TDS based connection to the target SQL Server (local or remote.). Local Host Name. The olehlp!

Servers

Servers Azure Engineering Java

World’s Top Web Performance Leaders To Watch

Rigor

SEPTEMBER 11, 2019

Rick is a software engineer on the Google Chrome team, “leading an effort to make the web just work for developers.” Follow him on Twitter @ RickByers and be sure to watch the video of his conversation at Chrome Dev Summit 2016 , where he discussed the ways Chrome is “improving predictability for developers.”

Performance

Performance Education Google Website

New Metadata-Only Column Changes in SQL Server 2016

Does SQL Server 2016 Require Trace Flag -T8048?

Trending Sources

How It Works: SQL Server 2016 SSE/AVX Support

SQL 2016 – It Just Runs Faster Announcement

SQL 2016–Install MSVC Patch Required

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

SQL Server Management Studio Provides–“XE Profiler”

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

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

How It Works: How SQL Server Determines Logical and Physical Processors

SQL Server on Linux: ELF and PE Images Just Work

Create Table – Disk vs In-Memory Optimized

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

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

World’s Top Web Performance Leaders To Watch

Stay Connected