The Morning Paper

NOVEMBER 5, 2019

File systems unfit as distributed storage backends: lessons from 10 years of Ceph evolution Aghayev et al., In this case, the assumption that a distributed storage backend should clearly be layered on top of a local file system. What is a distributed storage backend? SOSP’19. This is not surprising in hindsight.

Storage 64

Storage Systems Hardware Efficiency 64

Brendan Gregg

FEBRUARY 28, 2023

Titus, the Netflix container management platform, is now open source,” [link] Apr 2018 - [Cutress 19] Dr. DDR6: Here's What to Expect in RAM Modules,” [link] Nov 2020 - [Salter 20] Jim Salter, “Western Digital releases new 18TB, 20TB EAMR drives,” [link] Jul 2020 - [Spier 20] Martin Spier, Brendan Gregg, et al.,

Performance 103

Performance Latency Cache Virtualization 103

SQL Performance

MAY 16, 2019

The calculated row size (61 bytes) differs from the true row storage size (60 bytes) by the extra one byte of internal metadata present in the insert stream. spt_values AS SV ; Plan Caching. The DMLRequestSort property is saved as part of the cached plan. Calculated data size = 61 bytes * 268 rows = 16,348 bytes. Trace Flag.

Cache 67

Cache Servers Testing Storage 67

SQL Performance

SEPTEMBER 6, 2022

I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. SET NOCOUNT , XACT_ABORT ON ; -- Prevent plan caching for this procedure. -- See [link]. Let’s look at some examples using a fresh database. GOTO Start.

Database 98

Database Testing Storage Servers 98

Brendan Gregg

FEBRUARY 28, 2023

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?

Performance 52

Performance Latency Cache Virtualization 52

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. GO. -- Clear the plan cache. There is a final condition evaluated by storage engine code ( IndexDataSetSession::WakeUpInternal ) at execution time: DMLRequestSort is currently true ; and. GO. -- Clear the plan cache. DETAILED'. )

Cache 64

Cache Testing Servers Code 64

Percona

JUNE 4, 2023

MariaDB is a popular SQL open source relational database management system that originated as a fork of MySQL after MySQL was acquired by Sun Microsystems in 2008 and later Oracle in 2010. Some key features and functionalities of MySQL include: Support for multiple storage engines, allowing users to choose what is suitable for their needs.

Open Source 52

Open Source Servers Storage Scalability 52