The Morning Paper

NOVEMBER 5, 2019

In 2008, with the emergence of Btrfs, a new implementation was built taking advantage of Btrfs’ transactions, deduplication, checksums, and compression. To avoid any consistency overheads on object writes it writes data directly to raw disk , so there is only one cache flush fora data write. The first implementation (c.

Storage 64

Storage Systems Hardware Efficiency 64

Randon ASCII

FEBRUARY 25, 2018

This was starting to look like a Windows file cache bug. Maybe something to do with multi-socket coherency of the disk and cache or ??? This bug shows up from Server 2008 R2 (Windows 7) up to the latest stable build of Windows 10 and OS fixes will take a while to propagate so you might as well be careful.

Programming 79

Programming Hardware Cache Code 79

SQL Server According to Bob

JUNE 3, 2016

“SQL Server 2016 running on the same hardware as SQL Server 2014, 2012, 2008, 2008 R2 or 2005 uses fewer resources and executes a wide range of workloads faster. The following table is taken from an ASP.NET, session state cache, stress test. ” – Bob Dorr, Principle Engineer SQL Server Support. .”

Hardware 40

Hardware Software Engineering Transportation Scalability 40

John McCalpin

APRIL 2, 2020

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).

Benchmarking 59

Benchmarking Performance Latency Architecture 59

Speed Curve

JUNE 14, 2021

To overcome some of these challenges, we built our own Java-based player, complete with caching, content compression, and even bandwidth detection so it could switch between video, audio, and text versions of a course depending on network speed. Ultimately the business didn’t survive the dotcom bust, but it lit a spark.

Retail 52

Retail Internet Internet Education 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. GO. -- Clear the plan cache. GO. -- Clear the plan cache. Remember that DMLRequestSort is cached with the plan — it is not evaluated on each execution of a reused plan. NULL , -- Partition ID.

Cache 64

Cache Testing Servers Code 64

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

Randon ASCII

FEBRUARY 11, 2018

I don’t know what that means but my guess would be that that indicates more data being cached, which would be a good thing. A Windows kernel file buffer bug from Server 2008 R2 to Windows 10. A few types of memory actually increased after killing CcmExec.exe, mostly Mapped File and Metafile.

Processing 72

Processing Programming Code Systems 72

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

SQL Performance

JULY 16, 2019

Intel server processors have historically delivered significantly better single-threaded CPU performance and lower power consumption than competing AMD processors since the Intel Nehalem microarchitecture in 2008. They will also have up to 256MB of L3 cache per processor.

Servers 46

Servers Hardware Architecture Retail 46

SQL Performance

JUNE 21, 2019

If you are on SQL Server 2008 – SQL Server 2014, for a single NUMA node with less than 8 logical processors, keep MAXDOP at or below the number of logical processors. I tend to recommend increasing this value to a higher number after examining the Plan Cache. Microsoft has given guidance on what values to use for MAXDOP.

Servers 49

Servers Azure Hardware Database 49

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. In 2008, Sun Microsystems acquired MySQL AB, and then, in 2010, Oracle bought Sun Microsystems. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

SQL Server According to Bob

JANUARY 26, 2017

Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest. c:public_symbols is a symbol cache and a folder I created on my laptop.

Servers 40

Servers Database Azure Cache 40

All Things Distributed

JUNE 20, 2017

In 2008, AWS opened a point of presence (PoP) in Hong Kong to enable customers to serve content to their end users with low latency. Beyond running their web properties and applications, Next Digital also uses Amazon RDS (database), Amazon ElastiCache (caching), and Amazon Redshift (data warehousing).

AWS 127

AWS Logistics Cloud Social Media 127

All Things Distributed

DECEMBER 18, 2012

Jul 4 - Leases: An efficient fault-tolerant mechanism for distributed file cache consistency , Gray, Cary, and David Cheriton, Vol. Goetz Graefe, ACM Queue 6(4): 40-52 (2008). Sep 21 - Leases: An Efficient Fault-Tolerant Mechanism for Distributed File Cache Consistency , Cary G. Saltzer, D. Reed, and D. Gray and David R.

Operating System 134

Operating System Cache AWS Scalability 134