2014, Cache and Testing - Technology Performance Pulse

The Return of the Frame Pointers

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. It shouldn't be 10%, unless it's cache effects. And for leaf routines (which never establish a frame), this is a non-issue.

Java

Java Cache Google Hardware

Analyzing a High Rate of Paging

Brendan Gregg

AUGUST 29, 2021

Reads usually have apps waiting on them; writes may not (write-back caching). total used free shared buff/cache available Mem: 64414 15421 349 5 48643 48409 Swap: 0 0 0. There's not much memory left, 349 Mbytes, but more interesting is the amount in the buffer/page cache: 48,643 Mbytes (48 Gbytes). Counting cache functions.

Cache

Cache C++ AWS Latency

Minimal Logging with INSERT…SELECT into Empty Clustered Tables

SQL Performance

MAY 16, 2019

Both of the following tests must pass for SQL Server to choose to set DMLRequestSort to true when inserting to an empty clustered index with table locking specified: An estimate of more than 250 rows at the input side of the Clustered Index Insert operator; and. Test ; END ; GO. spt_values AS SV ; Plan Caching. DROP TABLE dbo.

Cache

Cache Servers Testing Storage

Analyzing a High Rate of Paging

Brendan Gregg

AUGUST 29, 2021

Reads usually have apps waiting on them; writes may not (write-back caching). This is a 64-Gbyte memory system, and 48 Gbytes is in the page cache (the file system cache). Along with the numbers from the problem statement, this gives me a theory: Do the 100-Gbyte files bust the page cache, whereas 40-Gbyte files fit?

Cache

Cache C++ AWS Systems

Trade-offs under pressure: heuristics and observations of teams resolving internet service outages (Part II)

The Morning Paper

JANUARY 23, 2020

Today we’ll be digging into the analysis of an incident that took place at Etsy on December 4th, 2014. Peer consensus was the primary mechanism used to decide whether to take actions affecting the production systems, and on two occassions changes were pushed through without waiting for automated tests to complete.

Internet

Internet Internet Cache Engineering

The Performance Inequality Gap, 2021

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. mid-priced Androids were slightly faster than 2014's iPhone 6. The professionalism with which the new Core Web Vitals (CWV) have been developed, tested, and iterated on inspires real confidence.

Performance

Performance Network Cache Metrics

SQL 2016 – It Just Runs Faster Announcement

SQL Server According to Bob

JUNE 3, 2016

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. Try SQL Server 2016 Today.

Hardware

Hardware Software Engineering Transportation Scalability

Progress Delayed Is Progress Denied

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

Media Games Education Engineering

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

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. Note: You may need to execute the dbcc a second time so buffer cache is hot, eliminating I/O sub-system variants. SQL Server 2014. SQL Server.

Hardware

Hardware Cache Servers Software Engineering

Minimal Logging with INSERT…SELECT and Fast Load Context

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. As a consequence, a suitable insert with TABLOCK may still qualify for minimal logging via FastLoadContext if it fails the detailed RowsetBulk tests. Test ; END ; GO. GO. -- Clear the plan cache. CHECKPOINT ; GO. -- Main test.

Cache

Cache Testing Servers Code

Common SQL Server Mishaps

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. In that situation, you would need to manually update the value.

Servers

Servers Azure Hardware Database

Batch Mode Bitmaps in SQL Server

SQL Performance

AUGUST 23, 2019

We test for matches by applying the same hash functions to each probe-side value. The SQL Server batch mode implementation of a Bloom filter is optimized for modern CPU cache architectures and is known internally as a complex bitmap. The second type of bitmap is a Bloom filter. Bitmap Choice.

Servers

Servers Engineering Efficiency Retail

MariaDB vs MySQL: Key Differences and Use Cases

Percona

JUNE 4, 2023

It is always being tested and updated, providing for optimized performance and minimal failures. GA 31 March 2014 10.0.10 MySQL is the most popular database in the world and benefits from the knowledge, resources, and development from that user base. MySQL Percona Server for MySQL MariaDB Server 3 December 2010 5.5.8

Open Source

Open Source Servers Storage Scalability

Understanding Execution Plan Operator Timings

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

Servers Tuning Architecture Processing

Viewing and Sorting XEvents Efficiently (Code Samples) – XEProfiler

SQL Server According to Bob

DECEMBER 31, 2018

iBytesRead = s.Read(bData, 0, c_iMaxReadSize); } }. . // Do we need to start the read-ahead to suck data into file system cache if (iCookie > -1) { tReadAhead.Start(iCookie); } }. Powershell Test Driver. internal void DoReadAheadInternal(object oParms) { try { int iCookie = (int) oParms; string strName = SourceFiles.Item(iCookie).FileName;

Efficiency

Efficiency Code Servers Cache

Content Management Systems of the Future: Headless, JAMstack, ADN and Functions at the Edge

Abhishek Tiwari

NOVEMBER 3, 2018

They often get blindsided by vendor’s pitch and end-up making decision based on some fancy demos (see my post from 2014 on Adobe AEM ). Circa 2014, I was working with a big Japanese automotive brand in Australia. However, it is important to note that JAMstack can serve both static as well as dynamic content.

Systems

Systems Cache Website Network

Technology Performance Pulse

The Return of the Frame Pointers

Analyzing a High Rate of Paging

Trending Sources

Minimal Logging with INSERT…SELECT into Empty Clustered Tables

Analyzing a High Rate of Paging

Trade-offs under pressure: heuristics and observations of teams resolving internet service outages (Part II)

The Performance Inequality Gap, 2021

SQL 2016 – It Just Runs Faster Announcement

Progress Delayed Is Progress Denied

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

Minimal Logging with INSERT…SELECT and Fast Load Context

Common SQL Server Mishaps

Batch Mode Bitmaps in SQL Server

MariaDB vs MySQL: Key Differences and Use Cases

Understanding Execution Plan Operator Timings

Viewing and Sorting XEvents Efficiently (Code Samples) – XEProfiler

Content Management Systems of the Future: Headless, JAMstack, ADN and Functions at the Edge

Stay Connected