SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

CSS Wizardry

MARCH 3, 2019

This includes CDNs, proxy servers, and the like. Once the 60 seconds is up, the browser will head back to the server to revalidate the file. It means ‘do no t serve a copy from cache until you’ve revalidated it with the server and the server said you can use the cached copy’. public and private. Cache-Control: no-cache.

Cache 264

Cache Latency Strategy Servers 264

Percona

JANUARY 24, 2023

Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. Zstd can be chosen if the server load is not CPU bound because it can give us better compression at the expense of more CPU utilization.

Database 118

Database Benchmarking Open Source Latency 118

Brendan Gregg

NOVEMBER 29, 2017

Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. In this configuration, the AMI and boot is paravirt (PV), the kernel is making hypercalls instead of privileged instructions, and the system is using paravirt network and storage drivers. I'd expect between 0.1% The AMI and boot are now HVM.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

SEPTEMBER 5, 2019

I briefly mentioned that batch mode data is normalized in my last article Batch Mode Bitmaps in SQL Server. You will need SQL Server 2016 (or later) and Developer Edition (or equivalent) to reproduce the results shown here. This table uses columnstore for its primary storage to produce batch mode execution later on.

Performance 81

Performance C++ Storage Servers 81

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. Since then, Microsoft has changed the naming of this series to Lsv2.

Azure 42

Azure Virtualization Storage Benchmarking 42

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage.

Performance 124

Performance Network Cache Metrics 124

Brendan Gregg

NOVEMBER 28, 2017

Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. In this configuration, the AMI and boot is paravirt (PV), the kernel is making hypercalls instead of privileged instructions, and the system is using paravirt network and storage drivers. I'd expect between 0.1% The AMI and boot are now HVM.

Virtualization 40

Virtualization AWS Hardware Storage 40

Brendan Gregg

SEPTEMBER 5, 2017

LTS (April 2016). I wrote about it in a previous post, [DTrace for Linux 2016]. I wrote a page on it: [perf]. - **eBPF**: tracing features completed in 2016, this provides efficient programmatic tracing to existing kernel frameworks. Oracle VM Server is based on Xen. The hardest part on Linux is now done: kernel support.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Alex Russell

OCTOBER 22, 2017

Late-loading JavaScript can cause “server-side rendered” pages to fail in infuriating ways. The server sends it as a stream of bytes and when the browser encounters each of the sub-resources referenced in the document, it requests them. The true median device from 2016 sold at about ~$200 unlocked.

Performance 68

Performance Benchmarking Network Mobile 68