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

If there is a newer file available on the server, we definitely want to download it. We’ve talked a lot so far about revalidation: the process of the browser making the trip back to the server to check whether a fresher file might be available. a CDN), to always serve the freshest possible copy, and not to persist anything to storage.

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. They do a much better job than what was available in PostgreSQL (pglz). It uses more CPU and can affect the TPS for specific workloads and machine configuration.

Database 115

Database Benchmarking Open Source Latency 115

Scalegrid

JANUARY 19, 2024

Data-bearing members face a higher risk of encountering issues caused by rollbacks, compared to others who utilize different storage methods. This particular write concern prioritizes data longevity over reading speed. The files look something like this: <dbname> <collectionname> 2016-02-08T19-34-44.0.bson

Database 130

Database Network Servers Monitoring 130

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 VMs are not available in all regions, so you will want to check the availability in the Azure region that you are interested in using. The L3 cache size is 64MB. Memory (GiB).

Azure 42

Azure Virtualization Storage Benchmarking 42

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. Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. I'd expect between 0.1%

Virtualization 111

Virtualization AWS Hardware Storage 111

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. Block storage is what you think of today as disk access. Tail Of Log Caching.

Cache 40

Cache Servers Media Storage 40