Brendan Gregg

MARCH 16, 2024

Only in extreme circumstances does the cost (in processor time and I-cache footprint) translate to a tangible benefit - circumstances which usually resort to hand-coded assembly anyway. You're just saving a pushl, movl, an series of operations that (for obvious reasons) is highly optimized on x86. The actual overhead depends on your workload.

Java 145

Java Cache Google Hardware 145

Alex Russell

APRIL 29, 2021

Thanks to the Web Platform Tests project and wpt.fyi , we have the makings of an answer for the first: Tests that fail only in a given browser. wpt.fyi 's new Compat 2021 dashboard narrows this full range of tests to a subset chosen to represent the most painful compatibility bugs : Stable-channel Compat 2021 results over time.

Media 145

Media Games Education Engineering 145

SQL Server According to Bob

JUNE 3, 2016

My development collogues and I are starting a regular blog series, outlining the vast range of scalability improvements, allowing SQL Server 2016 to run across a wide array of hardware configurations, faster and better than previous releases of SQL Server. The following table is taken from an ASP.NET, session state cache, stress test.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. Hardware Past As Performance Prologue. Regardless, the overall story for hardware progress remains grim, particularly when we recall how long device replacement cycles are: Tap for a larger version.

Performance 124

Performance Network Cache Metrics 124

SQL Performance

JUNE 21, 2019

Managed Instance sets a max server memory value based on the deployed tier, however when I tested resizing the environment, the max memory value was not dynamically changed. For SQL Server 2008R – 2014, you could lower this threshold using trace flag 2371. With modern hardware, the cost estimation of 5 is outdated.

Servers 49

Servers Azure Hardware Database 49

SQL Server According to Bob

JUNE 3, 2016

The following chart shows the same 1TB database testing. Use SQL Server Management Studio (SSMS) or your favorite query editor to connect to a SQL Server 2012 or 2014 instance. On the same hardware/machine repeat steps 1 thru 3 using an instance of SQL Server 2016 CTP 3.0 SQL Server 2014. CheckScanner = New design.

Hardware 40

Hardware Cache Servers Software Engineering 40

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). Total elapsed time is 933ms with 6,673ms of CPU time with a warm cache.

Servers 95

Servers Tuning Architecture Processing 95