SQL Performance

SEPTEMBER 5, 2019

This article explores the batch data normalized representation, explains why not all eight-byte data types can fit within 64 bits, and shows an example of how all this affects batch-mode performance. This table uses columnstore for its primary storage to produce batch mode execution later on. DROP TABLE IF EXISTS #T ; GO.

Performance 81

Performance C++ Storage Servers 81

Tim Kadlec

JANUARY 9, 2019

One question I’ve seen posed a few times in the past several months is whether performance really is a moral or ethical concern, or if that’s all heavy-handed exaggeration. When you stop to consider all the implications of poor performance, it’s hard not to come to the conclusion that poor performance is an ethical issue.

Performance 111

Performance Energy Internet Internet 111

Brendan Gregg

SEPTEMBER 5, 2017

I gave a talk about container performance recently at DockerCon, and included a quick summary of how they work: YouTube , SlideShare : If you search of slideshare and youtube, you'll find many other good talks on containers as well. People rarely create them manually.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Percona

MARCH 30, 2023

Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021.

Open Source 77

Open Source Database Storage Scalability 77

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. Horizontal and vertical MySQL partitions are techniques used to divide tables into smaller sections for improved performance and management.

Strategy 40

Strategy Storage Database Best Practices 40

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Scalability is a significant concern, as databases must handle growing data volumes and user demands while maintaining peak performance. A poorly chosen shard key can lead to performance issues.

Best Practices 73

Best Practices Traffic Database Servers 73

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. This processor has a base clock speed of 2.0GHz, with an all-core boost speed of 2.55GHz, and a max boost clock speed of 3.0GHz. The L3 cache size is 64MB.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Performance

AUGUST 27, 2019

TPC-H Benchmark Results with SQL Server 2017. HPE has already submitted a new official TPC-H result on SQL Server 2017 for a single-socket, HPE Proliant DL325 Gen10 1U server that was 743,750 QphH@1000GB. TPC-E Benchmark Results with SQL Server 2017. Higher memory speed and bandwidth. In this case, 6,716.88/64

Servers 52

Servers Benchmarking Virtualization Architecture 52

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. This machine has four i7 CPUs (hyperthreaded to 8) with a base speed of 2.4GHz. Performance is competitive at around 15ms. This code is provided for interest and is not included in the performance summary table. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

Smashing Magazine

JANUARY 7, 2019

Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Web performance is a tricky beast, isn’t it? How do we actually know where we stand in terms of performance, and what our performance bottlenecks exactly are? Vitaly Friedman.

Performance 103

Performance Cache Metrics Network 103

SQL Performance

FEBRUARY 3, 2020

While I got decent results in my first attempt, I wanted to see if I could improve the performance in part 2. There I outlined a few of the things I thought might be performance issues, and laid out how I would better partition the destination table for optimal columnstore compression. Other Testing.

Speed 113

Speed Processing Servers Storage 113

Alex Russell

OCTOBER 22, 2017

TL;DR: performance budgets are an essential but under-appreciated part of product success and team health. — Alex Russell (@slightlylate) October 4, 2017. Performance budgets are set early in the life of the project. Performance budgets keep everyone on the same. Maybe "ambush by JS"?

Performance 68

Performance Benchmarking Network Mobile 68

Enprowess

JANUARY 12, 2022

Web development is evolving at a rapid speed with each passing year. And so, it optimizes the page loading speed and reduces the bounce rate. So it is convenient for all to use irrespective of internet speed and it works offline using cached data. Twitter Lite PWA : It was integrated as the standard User Interface in 2017.

Blockchain 59

Blockchain IoT Development Serverless 59

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! Take a trivial example with three components A, B, and C.

C++ 50

C++ Systems Software Software 50

All Things Distributed

OCTOBER 2, 2017

We were pushing the limits of what was a leading commercial database at the time and were unable to sustain the availability, scalability and performance needs that our growing Amazon business demanded. Performant – The service would need to be able to maintain consistent performance in the face of diverse customer workloads.

Internet 128

Internet Internet AWS Performance 128

SQL Server According to Bob

DECEMBER 31, 2018

Using SQL Server Management Studio (SSMS) and storing the events in a table requires reading the events, streaming to table storage followed by an order by event sequence query. The project uses parallel threads to perform scatter/gather activities as well as tournament sorting to optimize the sorting and merging activities.

Efficiency 40

Efficiency Code Servers Cache 40