article thumbnail

How To Reduce the Costs of Database Management in Financial Services

Percona

During the recession of 2008, they experienced firsthand how fast money and assets can vanish. Consolidate workloads: In the past, you might have wanted to split out additional replicas or cluster nodes to process specific types of workloads, such as those related to reporting. If needed, you can spin up a backup.

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?

Insiders

Sign Up for our Newsletter

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

Trending Sources

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

The Ever Given is Not a Black Swan Event

The Agile Manager

Shippers, facing excessive capacity after the financial crisis of 2008, either went out of business, merged, or did deals to fill their ships to capacity. Optimization of the oceangoing containership fleet came at the cost of the efficiency of the rest of the supply chain into which it was integrated. This is not a black swan event.

article thumbnail

Is Intel Doomed in the Server CPU Space?

SQL Performance

One year after a Tock release Intel would take that same microarchitecture (with some minor improvements), and use a shrink of the manufacturing process to create a Tick release. The Tick-Tock release cycle basically fell apart by about 2015 , as Intel was unable to move from a 14nm manufacturing process to a 10nm manufacturing process.

Servers 46
article thumbnail

Finding Distinct Values Quickly

SQL Performance

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. The Sort only has 19 rows to process, so it consumes only 1ms or so.

Servers 86
article thumbnail

The Surprising Effectiveness of Non-Overlapping, Sensitivity-Based Performance Models

John McCalpin

The presentation discusses a family of simple performance models that I developed over the last 20 years — originally in support of processor and system design at SGI (1996-1999), IBM (1999-2005), and AMD (2006-2008), but more recently in support of system procurements at The Texas Advanced Computing Center (TACC) (2009-present).