Remove 2019 Remove Speed Remove Storage
article thumbnail

USENIX LISA2021 Computing Performance: On the Horizon

Brendan Gregg

AWS Graviton2); for memory with the arrival of DDR5 and High Bandwidth Memory (HBM) on-processor; for storage including new uses for 3D Xpoint as a 3D NAND accelerator; for networking with the rise of QUIC and eXpress Data Path (XDP); and so on. Ford, et al., “TCP

article thumbnail

Speed Up Your Website With WebP

Smashing Magazine

Speed Up Your Website With WebP. Speed Up Your Website With WebP. 2019-10-29T12:30:59+02:00. 2019-10-29T13:36:09+00:00. Here’s what Google suggests: PageSpeed Insights demonstrates how much storage and bandwidth websites stand to save with WebP. Suzanne Scacca. This is a sponsored post.) As well it should.

Website 75
Insiders

Sign Up for our Newsletter

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

article thumbnail

Memory-Optimized TempDB Metadata in SQL Server 2019

SQL Shack

By removing disk-based storage and the challenge of copying data in and out of memory, query speeds in SQL Server can be improved by orders of magnitude. Introduction In-memory technologies are one of the greatest ways to improve performance and combat contention in computing today.

Servers 79
article thumbnail

The Winds of Architecture Changes at the USENIX ATC 2019

ACM Sigarch

This blog post gives a glimpse of the computer systems research papers presented at the USENIX Annual Technical Conference (ATC) 2019, with an emphasis on systems that use new hardware architectures. Intel Quick Assist Technology (QAT) was the focus of the QZFS paper which used this new hardware device to speed up file system compression.

article thumbnail

Finding Distinct Values Quickly

SQL Performance

This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. This machine has four i7 CPUs (hyperthreaded to 8) with a base speed of 2.4GHz. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. Test Environment. The cost threshold for parallelism is set to 50.

Servers 86
article thumbnail

USENIX SREcon APAC 2022: Computing Performance: What's on the Horizon

Brendan Gregg

## References I've reproduced the references from my SREcon22 keynote below, so you can click on links: - [Gregg 08] Brendan Gregg, “ZFS L2ARC,” [link] Jul 2008 - [Gregg 10] Brendan Gregg, “Visualizations for Performance Analysis (and More),” [link] 2010 - [Greenberg 11] Marc Greenberg, “DDR4: Double the speed, double the latency?

article thumbnail

Fun with (columnstore) compression on a very large table – part 3

SQL Performance

Applying page or row compression (both online/offline) to the source before the affinitized copy (offline), to see if compressing the data first could speed up the destination. The downside to the latter is that, in SQL Server 2017, you cannot run this online… but you will be able to in 2019. tblOriginal.

Speed 113