HammerDB

OCTOBER 18, 2018

An essential part of database performance testing is viewing the statistics generated by the database during the test and in 2009 HammerDB introduced automatic AWR snapshot generation for Oracle for the TPC-C test. However what if you want to review performance data in real time as the test is running?

Benchmarking 40

Benchmarking Monitoring Performance C++ 40

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

n0derunner

OCTOBER 4, 2019

HammerDB is a great tool for running Database benchmarks. However it is very easy to create an artificial bottleneck which will give a very poor benchmark result. When setting up HammerDB to run against even a moderate modern server, it is important to avoid displaying the client transaction outputs in the HammerDB UI.

Benchmarking 75

Benchmarking Database Servers Performance Testing 75

n0derunner

JULY 23, 2019

In this video I migrate a Postgres DB running PGbench benchmark. The variation in the transaction rate is due to the benchmark itself, the transaction rate is not expected to be uniform. The aim of the experiment was to see how data-locality might affect a running database workload, not to generate the maximum TPS.

Benchmarking 76

Benchmarking Storage Tuning Cache 76

Adrian Cockcroft

JUNE 21, 2022

In 1991 I wrote a white paper on performance that was widely read, and in 1993 (with help from Brian Wong) that got me a job in the USA, working alongside Brian for Mike Briggs in technical product marketing. We had specializations in hardware, operating systems, databases, graphics, etc. Jim also joined the database performance team.

Tuning 52

Tuning Benchmarking Engineering C++ 52

n0derunner

OCTOBER 1, 2019

For our purposes we are going to use Postgres DB and the built-in benchmarking tool PGbench. This time though the metric is Database transactions per second not IOPS or Storage throughput. X-Ray can run Ansible scripts on the X-Ray worker VMs, and by doing so we are able to provision almost any application. X-Ray interface to pgbench.

Performance 75

Performance Benchmarking Storage Database 75

Brendan Gregg

FEBRUARY 9, 2018

I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. Plotting the percent performance loss vs syscall rate per CPU, for my microbenchmark: Applications that have high syscall rates include proxies, databases, and others that do lots of tiny I/O.

Performance 75

Performance Benchmarking Cache Tuning 75

Particular Software

DECEMBER 18, 2018

Getting up and running was simple and we don't have to worry about managing and maintaining queue databases anymore. When we attempted to do performance testing of the new transport to compare it to the legacy transport, we discovered that it is essentially impossible to run benchmarks on the Standard Tier.

Transportation 49

Transportation Azure Benchmarking Availability 49

Brendan Gregg

FEBRUARY 8, 2018

I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. Plotting the percent performance loss vs syscall rate per CPU, for my microbenchmark: Applications that have high syscall rates include proxies, databases, and others that do lots of tiny I/O.

Performance 40

Performance Benchmarking Cache Tuning 40

Apica

MAY 10, 2019

These virtual users simulate realistic scenarios scripted and recorded with Apica’s ZebraTester tool so that hundreds, thousands, and millions of tests run concurrently in a Streaming companies/studios’ pre-production or production environments before the episodes are actually ‘aired.’

Testing 40

Testing Performance Social Media Wireless 40

HammerDB

OCTOBER 12, 2018

As with the previous guides as an Intel employee (#IAMINTEL) the examples are taken from a MySQL 8 on Linux on Intel system and the approach is the same for whatever system you are testing although some of the settings you see may be different. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB.

Best Practices 40

Best Practices Scalability Performance C++ 40

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

High Scalability

DECEMBER 3, 2019

By having appropriate indexes on your MySQL tables, you can greatly enhance the performance of SELECT queries. During this time, you are also likely to experience a degraded performance of queries as your system resources are busy in index-creation work as well.

Best Practices 21

Best Practices Performance Systems Processing 21

Smashing Magazine

JANUARY 6, 2020

Geekbench CPU performance benchmarks for the highest selling smartphones globally in 2019. JavaScript stresses single-core performance (remember, it’s inherently more single-threaded than the rest of the Web Platform) and is CPU bound. Test with network throttling, and emulate a high-DPI device.

Performance 145

Performance Cache Network Metrics 145

High Scalability

NOVEMBER 25, 2019

Chokepoint : Even sharded Berkeley DB was choking under the stress and there was a database crash with recovery taking hours, it had to be replaced. Automate schema management for some remaining databases. Which database do you use? How is your database architected? Cloud Platform. Google cloud. Hosted Data Centers.

Architecture 52

Architecture Cache Azure Storage 52