O'Reilly

SEPTEMBER 19, 2023

” Consider the structural evolutions of that theme: Stage 1: Hadoop and Big Data By 2008, many companies found themselves at the intersection of “a steep increase in online activity” and “a sharp decline in costs for storage and computing.” Millions of tests, across as many parameters as will fit on the hardware.

Hardware 134

Hardware Storage Big Data Blockchain 134

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. Finding a small number of distinct values might seem like quite a specific requirement, but I have come across it fairly frequently over the years, usually as part of tuning a larger query. Test Environment. Final Thoughts.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

JUNE 21, 2019

While hardware such as intelligent SANs, Solid State Disk, and other advancements have helped speed things up, wasted space in index can translate to wasted space in the buffer pool as well as wasting more I/O. If you have big physical hardware with defaults, then you should look at optimizing MAXDOP. SQL Server Agent Alerts.

Servers 49

Servers Azure Hardware Database 49

Brendan Gregg

SEPTEMBER 5, 2017

Nowadays, there are three built-in tracers that you should know about: - **ftrace**: since 2008, this serves many tracing needs, and has been enhanced recently with hist triggers for custom histograms. It's fast, but limited in places, and usually only suited as a single-user tool (there are workarounds).

Virtualization 75

Virtualization AWS Engineering Hardware 75