Remove 2016 Remove Availability Remove Database Remove Design
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). Our design needed to scale and be adaptable to the modern hardware on the market.

article thumbnail

Expanding the AWS Cloud: Introducing the AWS US East (Ohio) Region

All Things Distributed

It brings the worldwide total of AWS Availability Zones (AZs) to 38, and the number of regions globally to 14. In the remainder of 2016 and inq 2017, we will launch another four AWS regions in Canada, China, the United Kingdom, and France, adding another nine AZs to our global infrastructure footprint.

AWS 127
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

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. Such “torn pages” are corruptions from the database point of view. They do a much better job than what was available in PostgreSQL (pglz).

Database 114
article thumbnail

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

Scalegrid

Why should a relational database even care about unstructured data? JSON database in 9.2 It is useful to validate incoming JSON and store in the database. Not all index types support all operator classes, so planning is needed to design your indexes based on the type of operators and queries that you plan on using.

Storage 321
article thumbnail

Should You Use ClickHouse as a Main Operational Database?

Percona

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Text search.

article thumbnail

DBCC Trace Flags 2562 and 2549

SQL Server According to Bob

Trace flags 2562 and 2549 are documented in knowledgebase article: [link] and the blog post [link] highlights the SQL 2016 DBCC performance improvements. For SQL Server 2016 the trace flags are available but the behavior may be altered by the design changes. This is behavior is unchanged in SQL Server 2016.

Servers 40
article thumbnail

The Performance Inequality Gap, 2021

Alex Russell

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. Modern network performance and availability. The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively.