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. Want to dive deeper?

Availability 40

Availability Servers Hardware Benchmarking 40

CSS Wizardry

MARCH 3, 2019

Tip: There are a number of directives that Clear-Site-Data will accept: "cookies" , "storage" , "executionContexts" , and "*" (which, naturally, means ‘all of the above’). a CDN), to always serve the freshest possible copy, and not to persist anything to storage. Examples and Recipes. headers we might employ. Live Train Timetable Page.

Cache 264

Cache Latency Strategy Servers 264

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

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. Attempts to compress PostgreSQL WAL at different levels have always been around since the beginning. The actual benefit of compression depends on many factors.

Database 118

Database Benchmarking Open Source Latency 118

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

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. This processor has a base clock speed of 2.0GHz, with an all-core boost speed of 2.55GHz, and a max boost clock speed of 3.0GHz. The L3 cache size is 64MB. Azure Lsv2 Details.

Azure 42

Azure Virtualization Storage Benchmarking 42

All Things Distributed

DECEMBER 12, 2018

The second platform is a managed IoT cloud with customer-facing applications and data management, which went live in 2016. We are excited to offer a comprehensive portfolio of services, from foundational technologies such as compute, storage, and networking to more advanced services such as containers and serverless computing.

AWS 124

AWS Cloud Games Serverless 124

Tim Kadlec

JANUARY 9, 2019

Mbps download speed Jake Archibald mentioned his relative getting or the 0.8 Mbps download speed my in-laws get at their house. Ballooning bandwidth and storage have fostered complacency that we can do without. My home internet connection gives me somewhere around 3 Mbps down. It seems blazingly fast compared to the 0.42

Performance 111

Performance Energy Internet Internet 111

SQL Performance

SEPTEMBER 5, 2019

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. Batch mode execution is all about speed. You might call this arrangement "off-row" or "out-of-batch" storage.

Performance 81

Performance C++ Storage Servers 81

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. The hardest part on Linux is now done: kernel support. It's the official profiler.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Alex Russell

OCTOBER 22, 2017

JavaScript is the single most expensive part of any page in ways that are a function of both network capacity and device speed. Thankfully, this is somewhat easier than network speeds: more than half of American mobile users are on Android devices. The true median device from 2016 sold at about ~$200 unlocked.

Performance 68

Performance Benchmarking Network Mobile 68