Dynatrace

FEBRUARY 25, 2021

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. If there’s an idle instance of a Lambda function available, no cold start is needed, and the function can be executed right away. What’s next.

Lambda 278

Lambda AWS Monitoring Serverless 278

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 145

Tuning Cache Servers Benchmarking 145

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. HammerDB has always used stored procedures as a design decision because the original benchmark was implemented as close as possible to the example workload in the TPC-C specification that uses stored procedures. On MySQL, we saw a 1.5X

Benchmarking 63

Benchmarking Database Network C++ 63

Percona

DECEMBER 20, 2023

Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. OS maintains a huge list of allocated and free pages to make slow but reliable address translation from virtual to physical.

C++ 120

C++ Virtualization Benchmarking Database 120

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. Compute optimized – High CPU-to-memory ration, medium traffic web servers and application servers. Generation.

Azure 76

Azure Benchmarking Storage Virtualization 76

HammerDB

OCTOBER 24, 2023

by @krithikasatish and @JoshInnis to provide accelerated load performance for both SQL Server TPROC-C and TPROC-H schemas. 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. With the default for v4.9 to have this feature enabled.

Servers 63

Servers C++ Benchmarking Virtualization 63

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

Percona

MARCH 17, 2023

Planning for resources of a PMM Server host instance can be tricky because the numbers can change depending on the DB instances being monitored by PMM. Virtual Memory utilization was averaging 48 GB of RAM. Capacity planning and setup details We used a dedicated 32-core CPU and 64GB of RAM for our testing.

Monitoring 117

Monitoring Scalability Database Cache 117

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 68

Programming Benchmarking Virtualization C++ 68

Percona

JUNE 22, 2023

Load balancing : Requests are evenly distributed across multiple database servers, ensuring the system remains operational even if one server fails. Automated failover : To keep the database operational and minimize downtime, it automatically switches to a backup server if the primary server fails.

Availability 132

Availability Database Open Source Hardware 132

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. A key aspect is being able to visualise the multithreaded nature of the Virtual Users.

Virtualization 74

Virtualization Benchmarking Database Operating System 74

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

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. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. Figure 1: CPU-Z Benchmark Results for LS16v2. Azure Lsv2 Details.

Azure 42

Azure Virtualization Storage Benchmarking 42

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. This server is spending about a third of its CPU cycles just checking the time! Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). A quick check of basic performance statistics showed over 30% higher CPU consumption.

Speed 103

Speed Java AWS Virtualization 103

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 63

Benchmarking Open Source C++ Cache 63

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

n0derunner

DECEMBER 22, 2020

With help from the Nutanix X-Ray team I have created an IO “benchmark” which simulates a “General Server Virtualization” workload.

Storage 52

Storage Benchmarking Virtualization Servers 52

HammerDB

MARCH 25, 2023

It will create the number of virtual users to the number of CPUs on the system where HammerDB is running. using existing tables (188,416 KB) SETTING CONFIGURATION Database set to MariaDB Benchmark set to TPC-C for MariaDB. scripts/tcl/maria/tprocc/maria_tprocc.sh TMP/hammer.DB TMP/hammer.DB TMP/hammer.DB TMP/hammer.DB TMP/hammer.DB

C++ 84

C++ Virtualization Benchmarking Database 84

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself. Is MongoDB free to use?

Open Source 98

Open Source Programming Database Servers 98

Percona

AUGUST 22, 2023

Some of the most important elements include: No single point of failure (SPOF): You must eliminate any SPOF in the database environment, including any potential for an SPOF in physical or virtual hardware. Load balancing: Traffic is distributed across multiple servers to prevent any one component from becoming overloaded.

Availability 98

Availability Hardware Open Source Database 98

HammerDB

NOVEMBER 22, 2021

This enables the user to compare and contrast performance across different benchmark scenarios. include/server -I/opt/postgresql-14.1/include/internal The example shows a TPROC-C workload running with 4 Active Virtual Users. Metrics view for benchmark. PostgreSQL Graphical Metrics. I/opt/postgresql-14.1/include/server

Metrics 63

Metrics Benchmarking C++ Database 63

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 the network, we can use Iperf to assess the network bandwidth between the client and the database server to ensure it will be enough to meet our peak requirement.

Performance 55

Performance Benchmarking Cache Storage 55

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. SQL Server DELAYED_DURABILITY. Logging Waits.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Brendan Gregg

MARCH 16, 2024

It was also a virtual machine that lacked low-level hardware profiling capabilities, so I wasn't able to do cycle analysis to confirm that the 10% was entirely frame pointer-based. Back-end servers. The actual overhead depends on your workload. I made that up, AFAIK they don't run Linux, but I may be wrong!)

Java 137

Java Cache Google Hardware 137

HammerDB

JUNE 27, 2024

Arguably, the most common beginning errors with database benchmarking is for a user to select a single point of utilisation (usually overconfigured) and then extrapolate conclusions about system performance from this single point. The profile ID chart will show performance for each individual profile.

C++ 52

C++ Performance Benchmarking Virtualization 52

HammerDB

DECEMBER 14, 2022

my.cnf --user=hammerdb 2022-12-14 12:14:05 0 [Note] bin/mysqld (server 10.10.2-MariaDB) and the test will run with the number of Virtual Users equivalent to the number of CPUs. Benchmark set to TPC-C for MariaDB. Building 20 Warehouses with 5 Virtual Users, 4 active + 1 Monitor VU(dict value maria_num_vu is set to 4).

C++ 63

C++ Virtualization Database Benchmarking 63

HammerDB

DECEMBER 5, 2020

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. more transactions than system B in the fully audited benchmark then the HammerDB result was also 1.5X I.e. if system A generated 1.5X

C++ 40

C++ Benchmarking Virtualization Open Source 40

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 56

Storage Cache C++ Virtualization 56

Percona

DECEMBER 20, 2018

In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud. A Look at MyRocks Performance. Installing MySQL 8.0

Database 50

Database Tuning Performance AWS 50

HammerDB

DECEMBER 1, 2022

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. . Use a different Browser. hammerdb>jobs [ "6388A0385EEC03E263531353", "6388A1585EEC03E243839333" ]. Use a different Browser. Use a different Browser.

Virtualization 58

Virtualization C++ Storage Database 58

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? Similarly for SQL Server TPM records Batches/sec which is the same value seen in the Activity Monitor in SSMS. and earlier. <benchmark>

C++ 52

C++ Benchmarking Metrics Database 52

Brendan Gregg

FEBRUARY 9, 2018

I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. In more detail: ## 1. Syscall rate This is the cost of extra CPU cycles in the syscall path. Linux 4.14.12-virtual

Performance 72

Performance Benchmarking Cache Tuning 72

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 45

Virtualization C++ Lambda Monitoring 45

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

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. This server is spending about a third of its CPU cycles just checking the time! Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). A quick check of basic performance statistics showed over 30% higher CPU consumption.

Speed 52

Speed Java AWS Virtualization 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. MS SQL Server/Linux and Windows. Virtual Users. Virtual Users within HammerDB are operating system threads.

Architecture 40

Architecture Virtualization Open Source C++ 40

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. This server is spending about a third of its CPU cycles just checking the time! Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). A quick check of basic performance statistics showed over 30% higher CPU consumption.

Speed 40

Speed Java AWS Virtualization 40