SQL Performance

SEPTEMBER 6, 2022

Testing environment. I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. SET NOCOUNT , XACT_ABORT ON ; -- Prevent plan caching for this procedure. -- See [link]. BEGIN TRANSACTION ; -- Test statement(s).

Database 98

Database Storage Testing Servers 98

John McCalpin

APRIL 2, 2020

The presentation discusses a family of simple performance models that I developed over the last 20 years — originally in support of processor and system design at SGI (1996-1999), IBM (1999-2005), and AMD (2006-2008), but more recently in support of system procurements at The Texas Advanced Computing Center (TACC) (2009-present).

Benchmarking 59

Benchmarking Performance Latency Architecture 59

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. The FastLoadContext code path adds support for minimally-logged and concurrent bulk load on: Empty and non-empty clustered b-tree indexes. There are two main code paths that can set DMLRequestSort to true for index inserts. The sqllang!CUpdUtil::FOptimizeInsert

Cache 64

Cache Testing Servers Code 64

SQL Server According to Bob

JUNE 3, 2016

The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. “SQL Server 2016 running on the same hardware as SQL Server 2014, 2012, 2008, 2008 R2 or 2005 uses fewer resources and executes a wide range of workloads faster. – [link]. Auto-soft NUMA.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Randon ASCII

FEBRUARY 25, 2018

Now we have a problem statement that we can reason about: why are large chunks of our code segment filled with zeroes? It’s frustrating to leave your computer running tests overnight only to have crashes pollute the results. In this case it said that 9322 bytes in the code in the crash dump were wrong. failure rate.

Programming 79

Programming Hardware Cache Code 79

Percona

JUNE 4, 2023

MariaDB is a popular SQL open source relational database management system that originated as a fork of MySQL after MySQL was acquired by Sun Microsystems in 2008 and later Oracle in 2010. In 2008, Sun Microsystems acquired MySQL AB, and then, in 2010, Oracle bought Sun Microsystems. What is MariaDB? release based on MySQL 5.5,

Open Source 52

Open Source Servers Storage Scalability 52

Randon ASCII

FEBRUARY 11, 2018

In hindsight it’s obvious that these zombies were caused by a trivial user-space coding bug. If you do care – if you want to wait for the process to quit – WaitForSingleObject(hProcess, INFINITE); – or query its exit code – GetExitCodeProcess(hProcess, &exitCode); – then you need to remember to close the handles after that.

Processing 72

Processing Programming Code Cache 72