SQL Performance

JANUARY 23, 2020

Query Store 2017 to the Rescue. In SQL Server 2017 and above, Query Store captures query-level waits in addition to query resource consumption. Detailed query-level waits are available on demand via integrated Plan Explorer. We are evaluating augmenting instance-level waits with query level data from Query Store, when available.

Tuning 115

Tuning Servers Monitoring Hardware 115

Alex Russell

APRIL 29, 2021

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. The information it captures is, however, available going back somewhat further, providing a fuller picture of the trend lines of engine completeness. Count of APIs available from JavaScript by Web Confluence.

Media 145

Media Games Education Engineering 145

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. To address these challenges, architects must design robust and scalable MongoDB databases and adopt appropriate sharding strategies that can efficiently handle increasing workloads while ensuring continuous availability. What is sharding in MongoDB?

Best Practices 98

Best Practices Traffic Database Servers 98

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. Here is a summary of the queries: Simple queries: select count(*) from ontime where flightdate > '2017-01-01'. With faster disks (i.e. AWS Aurora (based on MySQL 5.6)

Cache 72

Cache C++ AWS Airlines 72

Brendan Gregg

SEPTEMBER 25, 2021

As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. Theory (A) is most likely based on the frame widths in the flame graph. But I'm not completely sure.

Speed 103

Speed Java AWS Virtualization 103

Sutter's Mill

FEBRUARY 13, 2017

” This contains updated and new material that reflects the latest C++ standards and compilers, with a focus to using modern C++11/14/17 effectively on modern hardware and memory architectures. On April 25-27, I’ll be in Stockholm (Kista) giving a three-day seminar on “High-Performance and Low-Latency C++.”

Latency 48

Latency C++ Hardware Performance 48

SQL Performance

AUGUST 27, 2019

It will also use less power than a two-socket Intel server, with a lower hardware cost, and potentially lower licensing costs (for things like VMware). TPC-H Benchmark Results with SQL Server 2017. TPC-E Benchmark Results with SQL Server 2017. AMD Rome Second Generation EPYC Review: 2x 64-core Benchmarked.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Alex Russell

JANUARY 30, 2024

This split decision was available via last year's update , but was somewhat buried. HTML, CSS, images, and fonts can all be parsed and run at near wire speeds on low-end hardware, but JavaScript is at least three times more expensive, byte-for-byte. Going forward, I'll produce both as top-line guidance. In the U.S., This nets out to 2.32

Performance 98

Performance Network Mobile Speed 98

O'Reilly Software

APRIL 4, 2018

As Tyler Akiadu, from Google, explained in his Strata NY 2017 presentation, “ Foundations of streaming SQL ”: “Streams are the in-motion form of data, both bounded and unbounded.” It enables unbounded scalability as more commodity or specialized hardware can be seamlessly added to existing clusters.

Architecture 80

Architecture Scalability Google Operating System 80

SQL Performance

MARCH 17, 2020

It comes set to SQL Server 2008 compatibility (level 100), but we will start with a more modern setting of SQL Server 2017 (level 140): ALTER DATABASE StackOverflow2013 SET COMPATIBILITY_LEVEL = 140 ; The tests were performed on my laptop using SQL Server 2019 CU 2. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance.

Servers 86

Servers Tuning Database Efficiency 86

Alex Russell

FEBRUARY 21, 2023

From outright misstatements about a competitor's security, to claims that performance differences in hardware show Safari is faster, to [geographic brinksmanship](/2022/02/minimum-standards/), the confident bluster hasn't gone down particularly well.

Energy 90

Energy Games Engineering Design 90

Alex Russell

OCTOBER 22, 2017

— Alex Russell (@slightlylate) October 4, 2017. If our example document wasn’t reliant on JavaScript to construct the <my-app> custom element, the contents of the document would likely be interactive as soon as enough CSS and content was available to render meaningfully. Maybe "ambush by JS"? First Load.

Performance 74

Performance Network Benchmarking Mobile 74

ACM Sigarch

FEBRUARY 23, 2018

Richard Thaler won the 2017 Nobel prize in Economics for his work on Behavioral Economics. In industry, engineers (me included) sometimes attack a problem with the tools they have readily available rather than taking a step back and examining the issue at large. We believed existing hardware and OS protocols protected the processor.

Architecture 48

Architecture Cache Hardware Virtualization 48

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. MySQL replication provides high availability, load balancing, and data redundancy, enhancing system reliability. Replication also provides for data availability by enabling failover to a replica in case the primary server becomes unavailable.

Servers 52

Servers Database Availability Traffic 52

The Morning Paper

JANUARY 19, 2020

STELLA: report from the SNAFU-catchers workshop on coping with complexity , Woods 2017, Coping with Complexity workshop. Today’s choice is a report from a 2017 workshop convened with that title, and recommended to me by John Allspaw – thank you John! How do participants do that?

C++ 50

C++ Systems Software Software 50

Brendan Gregg

SEPTEMBER 25, 2021

As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. html [60s checklist]: /Articles/Netflix_Linux_Perf_Analysis_60s.pdf [re:Invent talk]: [link] [recommendation]: [link] [Nitro]: /blog/2017-11-29/aws-ec2-virtualization-2017.html

Speed 40

Speed Java AWS Virtualization 40

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. This means that multiple partitions can be processed simultaneously, making better use of available hardware resources and further enhancing query performance. So, What is MySQL Partitioning?

Strategy 40

Strategy Storage Database Best Practices 40

SQL Server According to Bob

DECEMBER 18, 2018

Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be Linux may need similar utilities to control various hardware cache installations.

Servers 90

Servers Media Cache Storage 90

ACM Sigarch

APRIL 26, 2018

They unveiled their first two embedded AI chips fabricated with TSMC 40nm process in December 2017: “Journey 1.0 HPU: Holographic Processing Unit (HPU) is the specific hardware of Microsoft’s Hololens. Image Processing Unit (IPU) is the Pixel Visual Core designed by Google and integrated in Google Pixel 2 released in 2017.

Hardware 100

Hardware Artificial Intelligence Architecture Google 100

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. Modern network performance and availability. Hardware Past As Performance Prologue.

Performance 127

Performance Network Mobile Metrics 127

CSS Wizardry

APRIL 2, 2018

Here are my top five most-played tracks of 2017’s 70,000 minutes: However, after recently discussing one of my all-time favourite tracks with a friend, and, bizarrely enough, with Nu:Tone himself, I decided that I wanted to start taking my listening a little more seriously. At home, I’m used to just streaming Spotify through an Amazon Echo.

Website 109

Website Media Hardware Monitoring 109

Smashing Magazine

JANUARY 21, 2021

After the latest redesign in late 2017, it was Ilya Pukhalski on the JavaScript side of things (part-time), Michael Riethmueller on the CSS side of things (a few hours a week), and yours truly, playing mind games with critical CSS and trying to juggle a few too many things. Moving From Automated Critical CSS Back To Manual Critical CSS.

Performance 111

Performance Cache Mobile Network 111

Brendan Gregg

AUGUST 8, 2017

Based on the date, I looked up the kernel mailing list archives to find the actual patch, but the oldest email available is from June 1995, when the sysadmin writes: "While working on a system to make these mailing archives scale more effecitvely I accidently destroyed the current set of archives (ah whoops).". Yes, I'd say so. termc$ uptime.

Latency 111

Latency Metrics C++ Systems 111

John McCalpin

JANUARY 22, 2018

A peculiar throughput limitation on Intel’s Xeon Phi x200 (Knights Landing) Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC.

Latency 40

Latency Hardware Code Testing 40

John McCalpin

JANUARY 22, 2018

Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC. A peculiar throughput limitation on Intel’s Xeon Phi x200 (Knights Landing).

Latency 40

Latency Hardware Code Testing 40

Smashing Magazine

JANUARY 7, 2019

Time to Interactive (TTI) The point at which layout has stabilized, key webfonts are visible, and the main thread is available enough to handle user input — basically the time mark when a user can interact with the UI. Still, it’s not that difficult , and its support is coming, e.g. it’s available since Apache 2.4.26.

Performance 111

Performance Cache Network Metrics 111