article thumbnail

SQL Server 2016 – It Just Runs Faster: Always On Availability Groups Turbocharged

SQL Server According to Bob

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.

article thumbnail

Cache-Control for Civilians

CSS Wizardry

If there is a newer file available on the server, we definitely want to download it. If, however, there wasn’t a new file on the server, we’ll bring back a 304 header, no new file, but an entire roundtrip of latency. We can completely cut out the overhead of a roundtrip of latency. What do we mean by a mutable or immutable file?

Cache 264
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

The Performance Inequality Gap, 2023

Alex Russell

The talks are up on YouTube , including my own (behind a paywall, but the slides are freely available [1] ): The talk, like this post, is an update on network and CPU realities this series has documented since 2017. That is, what was the average device in 2016? 2023 Content Targets #. No, it was a $600-$700 device.

article thumbnail

Expanding the Cloud – An AWS Region is coming to Hong Kong

All Things Distributed

The new AWS Asia Pacific (Hong Kong) Region will have three Availability Zones and be ready for customers for use in 2018. As a result, we have opened 43 Availability Zones across 16 AWS Regions worldwide. This enables customers to serve content to their end users with low latency, giving them the best application experience.

AWS 146
article thumbnail

MongoDB Rollback: How to Minimize Data Loss

Scalegrid

Using this specific approach also carries potential drawbacks such as decreased performance due to unavailable or lagging secondaries within the replica set network issues or server failures leading to increased latency for any ongoing writing processes.

Database 130
article thumbnail

Percentiles don’t work: Analyzing the distribution of response times for web services

Adrian Cockcroft

The mean and percentile measurements hide this structure, but the rest of this post will show how the structure can be measured and analyzed so that you can figure out a useful model of your system, understand what is driving the long tail of latencies and come up with better SLAs and measures of capacity.

Lambda 98
article thumbnail

WAL Compression in PostgreSQL and Recent Improvements in Version 15

Percona

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. Individual processes generate WAL records, and latency is very crucial for transactions. They do a much better job than what was available in PostgreSQL (pglz).

Database 118