KeyCDN

AUGUST 15, 2019

Before you begin tuning your website or application, you must first figure out which metrics matter most to your users and establish some achievable benchmarks. Measurements refer to specific data points, such as the number of seconds it takes to process a request. What is Performance Testing? What’s the difference?

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. As datasets continue to grow in size, the amount of RAM required to store and process these datasets also increases. Benchmark before you decide.

Performance 127

Performance Hardware Tuning Storage 127

Dynatrace

OCTOBER 2, 2023

Limits of a lift-and-shift approach A traditional lift-and-shift approach, where teams migrate a monolithic application directly onto hardware hosted in the cloud, may seem like the logical first step toward application transformation. Use SLAs, SLOs, and SLIs as performance benchmarks for newly migrated microservices.

Architecture 228

Architecture Artificial Intelligence Cloud Open Source 228

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. So over at Phoronix some database benchmarks were published showing PostgreSQL 12 Performance With AMD EPYC 7742 vs. Intel Xeon Platinum 8280 Benchmarks .

Benchmarking 63

Benchmarking Performance Hardware C++ 63

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. However, it is crucial that the benchmarking application does not have inherent bottlenecks that artificially limits the scalability of the database. Basic Benchmarking Concepts. To benchmark a database we introduce the concept of a Virtual User.

Programming 67

Programming Benchmarking Virtualization C++ 67

Brendan Gregg

SEPTEMBER 25, 2021

What about short-lived processes, like a service restarting in a loop? As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Was there some other program consuming CPU, like a misbehaving Ubuntu service that wasn't in CentOS? These can be invisible to top(8).

Speed 126

Speed Java AWS Virtualization 126

Percona

AUGUST 5, 2023

This means that multiple partitions can be processed simultaneously, making better use of available hardware resources and further enhancing query performance. Special considerations are needed to ensure these processes still work seamlessly after partitioning. Documentation : Always be documenting!

Strategy 40

Strategy Storage Database Best Practices 40

Brendan Gregg

SEPTEMBER 25, 2021

What about short-lived processes, like a service restarting in a loop? As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Was there some other program consuming CPU, like a misbehaving Ubuntu service that wasn't in CentOS? These can be invisible to top(8).

Speed 40

Speed Java AWS Virtualization 40

SQL Server According to Bob

JANUARY 11, 2020

Example 1: ​​ Hardware failure (CPU board) Battery backup on the caching controller maintained the data. Important Always consult with your hardware manufacturer for proper stable media strategies. For specific information on I/O tuning and balancing, you will find more details in the following document.

Servers 40

Servers Cache Media Hardware 40

HammerDB

OCTOBER 12, 2018

As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. For anyone benchmarking MySQL with HammerDB it is important to understand the differences from sysbench workloads as HammerDB is targeted at a testing a different usage model from sysbench. innodb_file_per_table.

Best Practices 40

Best Practices Scalability Performance C++ 40

Percona

NOVEMBER 3, 2023

About the cluster Following a step-by-step process, the objective is to create a four-node cluster consisting of: PostgreSQL version 15 Citus extension (I’ll be using version 11, but there are newer ones available.) In order to speed up the benchmark indexes must be added. psql pgbench <<_eof1_ qecho adding node citus3.

Database 107

Database Benchmarking Latency C++ 107

SQL Server According to Bob

JANUARY 11, 2020

DBCC Page Auditing DBCC page auditing is the process of executing common DBCC consistency checks as pages are read from disk. ​​ This is a serious I/O subsystem problem that should be addressed immediately to avoid SQL Server and overall system stability problems ​​ and ​​ data loss.

Servers 40

Servers Cache Database Media 40

Scalegrid

JULY 13, 2020

Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. of PostgreSQL users are currently in the process of migrating to the RDBMS, according to the 2019 PostgreSQL Trends Report , an astounding percentage considering this is the 4th most popular database in the world.

Open Source 244

Open Source Tuning C++ Database 244

John McCalpin

APRIL 25, 2023

This metric is interesting because we don’t always have the luxury of parallelizing every application we run, and our operating systems almost always process each call (e.g., GHz, 1530 GB/s peak BW from 6 HBM stacks), I see single-thread sustained memory bandwidth of 304 GB/s on the ReadOnly benchmark used here. Stay tuned!

Benchmarking 97

Benchmarking Cache Latency Tuning 97

High Scalability

NOVEMBER 25, 2019

Your Laptop has a filesystem used by hundreds of processes. It is limited by the disk space; it can’t expand storage elastically; it chokes if you run few I/O intensive processes or try collaborating with 100 other users. On prem data processing. Locks used for strong consistency across processes. Document store.

Architecture 52

Architecture Cache Azure Storage 52