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

Alex Russell

MARCH 6, 2021

Thanks to progress in networks and browsers (but not devices), a more generous global budget cap has emerged for sites constructed the "modern" way: ~100KiB of HTML/CSS/fonts and ~300-350KiB of JS (compressed) is the new rule-of-thumb limit for at least the next year or two. Modern network performance and availability.

Performance 124

Performance Network Cache Metrics 124

Scalegrid

AUGUST 15, 2019

In 2014, we discussed 4 of the top MongoDB GUIs: MongoVue, MongoHub, RockMongo, and Robo 3T (formerly Robomongo), and again in 2016: MongoDB Compass, Robo 3T, Studio 3T, and MongoBooster. Should have an excellent way to measure server and query performance. Import data from RDBMS like MySQL, PostgreSQL, and SQL Server.

Database 40

Database Servers Monitoring Availability 40

Brendan Gregg

NOVEMBER 29, 2017

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. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. AWS called this [enhanced networking].

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

SEPTEMBER 2, 2021

A lot of things change over the course of a few major versions of our favorite database platform. SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1.

C++ 59

C++ Servers Testing Database 59

Brendan Gregg

NOVEMBER 28, 2017

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. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. AWS called this [enhanced networking].

Virtualization 40

Virtualization AWS Hardware Storage 40

Smashing Magazine

OCTOBER 26, 2018

It’s an all-in-one system that is equipped with a working admin interface; it manages database connection, and has a bunch of useful APIs exposed that handle user authentication, routing, and more. on December 6th, 2016. Transients API is used to store data in the options table of your WordPress database for a specific period of time.

Cache 79

Cache Website Speed Database 79

Alex Russell

MAY 9, 2022

Reduced network and device capacity correlate with other access challenges. Folks with powerful laptops, new iPhones, and low-latency networks are noticing, which is a very bad sign. Do they have a device-class or network condition target ? miAi3020A9G #perfmatters 1 10:04 AM · Jul 7, 2016. sales, marketing, etc.)?

Performance 86

Performance Latency Metrics Engineering 86

The Symphonia

DECEMBER 6, 2017

without web app servers?—?to to a massively distributed CDN network a possibility. Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. There have been some improvements since re:Invent 2016 but to see nothing announced at this re:Invent was very disappointing.

Serverless 40

Serverless Lambda AWS Traffic 40

Percona

JANUARY 14, 2019

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. Processed 4.15

Database 40

Database Analytics Blockchain Healthcare 40