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 . 3823 2694 -- 0 4 4 2864 74.83

Benchmarking 63

Benchmarking Performance Hardware C++ 63

HammerDB

JUNE 22, 2023

So for example to change this to hammer.db On Windows it will look for TEMP, TMP, TMPDIR or finally C: for example, on Linux. In this example, we will run a PostgreSQL TPROC-C autopilot workload to generate some jobs to analyse. Therefore we will give examples on Windows, however the commands are the same on Linux as well.

Benchmarking 57

Benchmarking C++ Virtualization Database 57

Scalegrid

JANUARY 12, 2024

Various forms can take shape when discussing workloads within the realm of cloud computing environments – examples include order management databases, collaboration tools, videoconferencing systems, virtual desktops, and disaster recovery mechanisms. This applies to both virtual machines and container-based deployments.

Cloud 130

Cloud Virtualization Storage Efficiency 130

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

JUNE 27, 2022

HammerDB is a software application for database benchmarking. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The Transaction Processing Performance Council (TPC) was founded to bring standards to database benchmarking, and the history of the TPC can be found here.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Dynatrace

SEPTEMBER 23, 2021

Unfortunately, container security is much more difficult to achieve than security for more traditional compute platforms, such as virtual machines or bare metal hosts. Many good security tools provide that function, and benchmarks from the Center for Internet Security (CIS) are clear and prescriptive. Why is container security tricky?

Open Source 255

Open Source Benchmarking Best Practices Network 255

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. The pricing details for the East US region are here , as an example. I wrote about using CPU-Z to benchmark the Intel Xeon E5-2673 v3 processor in an Azure VM in this article.

Azure 42

Azure Virtualization Storage Benchmarking 42

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

HammerDB

OCTOBER 24, 2023

In this example on a development PC the regular build started at 10:48:35 and ended at 10:54:46 meaning it took 6 minutes 11 seconds to build our 20 warehouse schema. Summary The new Use BCP Option for SQL Server accelerates both TPROC-C and TPROC-H schema loads, so you can get to running your benchmarks faster.

Servers 62

Servers C++ Benchmarking Virtualization 62

HammerDB

APRIL 19, 2023

Regardless of whether the computing platform to be evaluated is on-prem, containerized, virtualized, or in the cloud, it is crucial to consider several essential factors. For example, if you are buying the latest Amazon memory-optimized EC2 instance (R7iz), the AWS page ( [link] ) tells us the following: Up to 3.9 4.22 %usr 38.40

Performance 54

Performance Benchmarking Cache Storage 54

HammerDB

APRIL 27, 2021

In this example we are using SQL Server so the message shows that everything is in order and we can proceed with running tests. This will show the benchmark options dialog. Benchmark Options. and benchmark set with the bm argument. The example below shows the same settings made in the GUI. librarycheck.

Virtualization 73

Virtualization Benchmarking Database Operating System 73

HammerDB

NOVEMBER 23, 2021

this web interface has been enhanced to add command line functionality to the service as well as extending the ability to query the database of configuration, results and timing data to be returned in JSON format, enabling a long-term repository of HammerDB benchmark data for integrating HammerDB into service based cloud environments.

Virtualization 70

Virtualization Benchmarking C++ Database 70

HammerDB

MARCH 27, 2023

introduces more lightweight database specific Docker Images, so if you only want to run benchmarks against a specific database you can go from having no benchmarking environment to reviewing your results in as little as 3 commands. New Features Pt 2: Example CLI Scripts 3. How to deploy HammerDB CLI fast with Docker HammerDB v4.7

Benchmarking 51

Benchmarking Testing Database C++ 51

HammerDB

NOVEMBER 22, 2021

This enables the user to compare and contrast performance across different benchmark scenarios. This example uses a PostgreSQL source based build with the pg_stat_statements extension found in the contrib directory. ./ -I/opt/postgresql-14.1/include/server Add the following example entries to the postgresql.conf.

Metrics 62

Metrics Benchmarking C++ Database 62

SQL Performance

NOVEMBER 18, 2019

Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. Microsoft has helped simplify things by creating multiple types of virtual machines. High performance compute – Fastest and most powerful CPU virtual machines. Benchmark Test. VM Types and Sizes.

Azure 76

Azure Benchmarking Storage Virtualization 76

Brendan Gregg

MARCH 16, 2024

To explain this example in more detail: The profiler periodically interrupts software execution, and for those disconnected stacks it happens to be the execution of the kernel software ("vfs*", "ext*", etc.). These partial stacks get grouped together on the left. Click here for a longer explanation. You usually get an extra junk frame.

Java 145

Java Cache Google Hardware 145

HammerDB

JULY 6, 2023

In this example, we will use the CLI to run TPROC-C on a MariaDB database to illustrate the concepts. So as a first step, we will go ahead and set keying and thinking time for one virtual user and run the test for 2 minutes of rampup and 2 minutes of testing time. Again, each virtual user we add is running at approximately 1 NOPM.

Virtualization 57

Virtualization C++ Database Code 57

Dynatrace

APRIL 8, 2021

These served as our benchmark when creating our Lambda monitoring extension. A Lambda function behind an API gateway can provide exactly such an API endpoint to fetch data from other AWS services, or even to call back into the enterprise application to fetch data from, for example, a mainframe. Top enterprise use-cases for AWS Lambda.

Lambda 226

Lambda AWS Serverless Monitoring 226

HammerDB

DECEMBER 14, 2022

This image includes example scripts to build schemas and test your databases with a single command. In this post, we will show an example of using Docker to deploy the HammerDB command line and test a database with minimal effort. and the test will run with the number of Virtual Users equivalent to the number of CPUs.

C++ 62

C++ Virtualization Database Benchmarking 62

HammerDB

NOVEMBER 5, 2018

This post at an entry-level discusses the options you have to improve log throughput in your benchmark environment. . The first example shows a data load, the second a TPC-C based workload with 5 virtual users and the 2nd example with 10 virtual users. A good example of how tuning is an iterative process.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

HammerDB

DECEMBER 1, 2022

For example on Windows an example of opening a new database. For example, we will run the following script to build a TPROC-C schema. For querying a build, the status command will show whether all Virtual Users started and finished successfully, allowing a quick way to check the status of a build. . HammerDB CLI v4.6

Virtualization 57

Virtualization C++ Storage Database 57

Dynatrace

APRIL 8, 2021

These served as our benchmark when creating our Lambda monitoring extension. A Lambda function behind an API gateway can provide exactly such an API endpoint to fetch data from other AWS services, or even to call back into the enterprise application to fetch data from, for example, a mainframe. Top enterprise use-cases for AWS Lambda.

Lambda 188

Lambda AWS Serverless Monitoring 188

Percona

DECEMBER 23, 2022

The use case is the TPC-C benchmark but executed not on a high-end server but on a lower-spec virtual machine that is I/O limited like for example, with AWS EBS volumes. I decided to use a virtual machine with two CPU cores, four GB of memory, and storage limited to a maximum of 1000 IOPs of 16KB.

Storage 55

Storage Cache C++ Virtualization 55

HammerDB

DECEMBER 5, 2020

For example HammerDB has not used tpmC terminology to report TPC-C based metrics instead using TPM and NOPM nomenclature. The HammerDB TPROC-C workload by design intended as CPU and memory intensive workload derived from TPC-C – so that we get to benchmark at maximum CPU performance at a much smaller database footprint.

C++ 40

C++ Benchmarking Virtualization Open Source 40

HammerDB

NOVEMBER 30, 2022

Vuser 1:1 Active Virtual Users configured Vuser 1:TEST RESULT : System achieved 39945 NOPM from 92893 SQL Server TPM Vuser 1:Gathering timing data from Active Virtual Users. Running this script returns output as follows using the Python loop to drive HammerDB. Vuser 2:FINISHED SUCCESS Vuser 1:Calculating timings.

Virtualization 44

Virtualization C++ Lambda Monitoring 44

Percona

MARCH 17, 2023

For example, a higher number of data samples ingested per second or a monitoring database with a huge number of tables (1000+) can affect performance; similarly, the configuration for exporters or a custom metric resolution can also have an impact on the performance of a PMM server host.

Monitoring 95

Monitoring Scalability Cache Database 95

Percona

APRIL 7, 2023

To illustrate this, I ran the Sysbench-TPCC synthetic benchmark against two different GCP instances running a freshly installed Percona Server for MySQL version 8.0.31 For example, if the hot data can fit in 12G, then increasing the Buffer Pool to 26G won’t make much of a difference.

Tuning 133

Tuning Cache Servers Benchmarking 133

The Morning Paper

SEPTEMBER 24, 2020

This means for example that it can be applied to analyse source code repositories and pull requests, be used as an additional test in CI pipelines, and even give assistance in your IDE if it’s fast enough. For example, the notions of entry point, controller, filter, and bean. Introducing JackEE. JackEE in action.

Java 80

Java Cache Benchmarking Programming 80

HammerDB

JULY 8, 2019

/restchk.tcl TEST DIRECT PRINT COMMANDS -- Printing output for db and converting JSON to text JSON format { "ora": "Oracle", "mssqls": "MSSQLServer", "db2": "Db2", "mysql": "MySQL", "pg": "PostgreSQL", "redis": "Redis" } TEXT format ora Oracle mssqls MSSQLServer db2 Db2 mysql MySQL pg PostgreSQL redis Redis Printing output for bm and converting JSON (..)

Benchmarking 40

Benchmarking Virtualization C++ Database 40

Percona

JUNE 22, 2023

High availability works through a combination of the following: No single point of failure (SPOF) : You must eliminate any single point of failure in the database environment, including physical or virtual hardware the database system relies on that would cause it to fail. there cannot be high availability.

Availability 104

Availability Database Open Source Hardware 104

SQL Performance

AUGUST 27, 2019

Figure 1 shows an example from AMD comparing a two-socket server with two Intel Xeon Gold 6262V processors to a one-socket server with one AMD EPYC 7702P processor. Figure 1: AMD Example of Two-socket vs. One-socket Server. AMD Rome Second Generation EPYC Review: 2x 64-core Benchmarked. This idea is not unique to AMD.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Dynatrace

FEBRUARY 25, 2021

What the Lambda team introduced in 2018, for example, the new Firecracker VM, has since been fully rolled out. The virtual CPU is turned off. When we set out to create the new Lambda extension, we benchmarked other dedicated Lambda monitoring solutions that were already on the market. Lambda worker nodes.

Lambda 224

Lambda AWS Monitoring Serverless 224

Rigor

FEBRUARY 19, 2020

As an example, here is what the industry-standard Selenium IDE recorder looks like when testing a mission-critical “checkout user flow” 2. Some common examples include: Testing your site with and without a CDN, or with different CDNs. For example, here is what a comparison report looks like in Rigor.

Monitoring 59

Monitoring Benchmarking Mobile Traffic 59

HammerDB

MAY 10, 2021

For example for configuring an Oracle workload the following commands set the rampup and duration running times respectively. In the following example we have set the default 2 minutes of rampup and 5 minutes of test. Note that it is expected for Virtual User 1 of the replicas to end immediately with the message.

Virtualization 52

Virtualization C++ Database Monitoring 52

Percona

AUGUST 22, 2023

Streaming services, for example, run mission-critical systems in which excessive downtime could result in significant financial and reputational losses for the business. Without enough infrastructure (physical or virtualized servers, networking, etc.), there cannot be high availability.

Availability 77

Availability Hardware Open Source Database 77

HammerDB

DECEMBER 9, 2020

<benchmark> <first_result>TPM</first_result> </benchmark> So why not just print NOPM and report a single metric for TPROC-C as per the official TPC-C workloads? It can be seen from the example below that the HammerDB Transaction Counter. and earlier. <benchmark> Transaction Counter.

C++ 52

C++ Benchmarking Metrics Database 52

HammerDB

NOVEMBER 30, 2018

This article Threads Done Right… With Tcl gives an excellent overview of these capabilities and it should be clear that to build a scalable benchmarking tool this thread performance and scalability is key. As virtual users are started the database specific packages and workload specific modules are loaded into the virtual user threads.

Architecture 40

Architecture Virtualization Open Source C++ 40