SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.

Tuning 115

Tuning Servers Monitoring Hardware 115

SQL Performance

MARCH 30, 2021

This five-part series takes a deep dive into the way SQL Server row mode parallel plans start up. ) ; My test environment is SQL Server 2019 CU9 on a laptop with 8 cores and 16GB of memory allocated to the instance. See Myth: SQL Server Caches a Serial Plan with every Parallel Plan for details. Parallel Plan Initialization.

Cache 98

Cache Servers Operating System Processing 98

Brendan Gregg

MARCH 16, 2024

This technique saves two instructions in the prologue and epilogue and makes one additional general-purpose register (%rbp) available." 2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth.

Java 145

Java Cache Google Hardware 145

KeyCDN

MARCH 28, 2019

There are a myriad of options available when choosing which backend framework you want to work with. Features Simple and fast routing engine Comes with its own CLI Powerful template system (Blade) Good documentation CakePHP CakePHP is one of the first PHP frameworks to be released back in 2005.

Programming 77

Programming Website Scalability Design 77

Brendan Gregg

NOVEMBER 29, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. It's amazing to recall that it was even possible to virtualize x86 before processors had hardware-assisted virtualization (Intel VT-x and AMD-V), which were added in 2005 and 2006. 0% performance overhead.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

AUGUST 12, 2020

You can find it in the documentation of Microsoft SQL Server and Azure SQL Database. T-SQL supports it starting with SQL Server 2005. In logical query processing terms, by the time you get to the outer query, the CTE name is already defined and available.

C++ 140

C++ Code Design Database 140

Brendan Gregg

NOVEMBER 28, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. It's amazing to recall that it was even possible to virtualize x86 before processors had hardware-assisted virtualization (Intel VT-x and AMD-V), which were added in 2005 and 2006. 0% performance overhead.

Virtualization 40

Virtualization AWS Hardware Storage 40

Brendan Gregg

AUGUST 8, 2017

The oldest change in the entire Linux repo dates back to 2005, when Linus imported Linux 2.6.12-rc2, Thankfully, I found some older linux-devel mailing list archives, rescued from server backups, often stored as tarballs of digests. It's time in some cgroup paths, but this server is not doing much disk I/O. to the load average.

Latency 111

Latency Metrics C++ Systems 111