SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers 90

Servers Media Cache Storage 90

Brendan Gregg

SEPTEMBER 5, 2017

Linux has been adding tracing technologies over the years: kprobes (kernel dynamic tracing), uprobes (user-level dynamic tracing), tracepoints (static tracing), and perf_events (profiling and hardware counters). Oracle VM Server is based on Xen. amazon"). I also wrote and published an entertaining SMF manifest that played music.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. The idea is to use secondary servers on your infrastructure for either reads or other administrative solutions. Network Connectivity: Establish a reliable network connection between the primary and replica servers. Restart the MySQL service.

Servers 52

Servers Database Availability Traffic 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Sharding in MongoDB is a technique used to distribute a database horizontally across multiple nodes or servers, known as “shards.” MongoDB distributes data across these shard servers to ensure an even distribution.

Best Practices 73

Best Practices Traffic Database Servers 73

Percona

JULY 7, 2023

In general terms, to achieve HA in PostgreSQL, there must be: Redundancy: To ensure data redundancy and provide continuous performance when a primary server fails, multiple copies of the database reside in replica servers. When the primary server fails, a standby server takes over as the new primary.

Availability 85

Availability Open Source Architecture Database 85

Brendan Gregg

SEPTEMBER 25, 2021

Since instances of both CentOS and Ubuntu were running in parallel, I could collect flame graphs at the same time (same time-of-day traffic mix) and compare them side by side. This server is spending about a third of its CPU cycles just checking the time! The CentOS flame graph: The Ubuntu flame graph: Darn, they didn't work.

Speed 126

Speed Java AWS Virtualization 126

Alex Russell

MARCH 6, 2021

TL;DR: A lot has changed since 2017 when we last estimated a global baseline resource per-page resource budget of 130-170KiB. To update our global baseline from 2017, we want to update our priors on a few dimensions: The evolved device landscape. Hardware Past As Performance Prologue. The Moto G4 , for example. Hard Reset.

Performance 124

Performance Network Cache Metrics 124