Randon ASCII

FEBRUARY 11, 2018

Zombies probably won’t consume 32 GB of your memory like they did to me, but zombie processes do exist, and I can help you find them and make sure that developers fix them. He’d even written a tool that would dump a list of zombie processes – their names and counts. I ran his tool and it showed 506,000 zombie processes!

Processing 72

Processing Programming Code Cache 72

SQL Performance

SEPTEMBER 17, 2019

SSRS 2008 brought that component into the reporting service module. The ReportServer and ReportServerTempDB databases are SQL Server databases and should be part of a regular backup process, just like other user databases. In the early days of SSRS, a requirement was to also install and configure Internet Information Services (IIS).

Tuning 67

Tuning Servers Database Best Practices 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]. Notice the lack of a check at 1250 due to the code quirk I mentioned.

Database 98

Database Storage Testing Servers 98

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

Percona

JUNE 4, 2023

Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. Efficient data processing and indexing, making it optimal for executing queries and handling large datasets. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

SQL Server According to Bob

JUNE 3, 2016

The new column store engine and query processing technology could increase query performance up to 100X and the new In-memory OLTP engine can process 1.25million batches/sec on a single 4 socket server, which is more than 3X of SQL 2014. “ – Rohan Kumar, Director of SQL Software Engineering. Auto-soft NUMA. Batch Requests / Sec.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Randon ASCII

FEBRUARY 25, 2018

Now we have a problem statement that we can reason about: why are large chunks of our code segment filled with zeroes? This command compares the code bytes in the crash dump (some of them are saved in the crash dump, just in case) against those on disk. In this case it said that 9322 bytes in the code in the crash dump were wrong.

Programming 79

Programming Hardware Cache Code 79