Dynatrace

JUNE 26, 2023

Intelligent software automation can give organizations a competitive edge by analyzing historical and compute workload data in real time to automatically provision and deprovision virtual machines and Kubernetes. Additionally, software analytics enhances the digital customer experience by enabling faster service for high-quality offerings.

Software 246

Software Software Analytics Big Data 246

SQL Performance

DECEMBER 17, 2019

One important choice you will still have to make is what type and size of Azure virtual machine you want to use for your existing SQL Server workload. Microsoft currently has eight main types of virtual machines designed for different types of workloads. Azure VM Types and Series. Hopefully, they will do that in the future. Conclusion.

Azure 72

Azure Virtualization Servers Storage 72

n0derunner

JUNE 28, 2019

The Linux VM running postgres has two virtual disks – one taking transaction log writes. The post View from Nutanix storage during Postgres DB benchmark appeared first on n0derunner. A quick look at how the workload is seen from the Nutanix CVM. In this example from prior post. These low-concurrency log writes also hit oplog.

Benchmarking 75

Benchmarking Storage Cache Database 75

HammerDB

SEPTEMBER 24, 2024

The key findings of the article were as follows: This server had a HammerDB benchmark running against it. But why are we running a COPY operation during a benchmark anyway? So this COPY statement is coming from the schema build phase and not the HammerDB benchmark workload at all. and start the build running.

Benchmarking 68

Benchmarking Performance Metrics Database 68

Dynatrace

APRIL 8, 2021

These served as our benchmark when creating our Lambda monitoring extension. This means that, compared to running a regular web server, there are virtually no costs while users are not interacting with your site. Today, Lambda can be monitored by Dynatrace in hybrid environments, thereby satisfying the enterprise requirements.

Lambda 246

Lambda AWS Serverless Monitoring 246

Dynatrace

APRIL 8, 2021

These served as our benchmark when creating our Lambda monitoring extension. This means that, compared to running a regular web server, there are virtually no costs while users are not interacting with your site. Today, Lambda can be monitored by Dynatrace in hybrid environments, thereby satisfying the enterprise requirements.

Lambda 246

Lambda AWS Serverless Monitoring 246

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

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.

Lambda 278

Lambda AWS Monitoring Serverless 278

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

n0derunner

JUNE 28, 2019

In this example, we use Postgres and the pgbench workload generator to drive some load in a virtual machine. Assume a Linux virtual machine that has Postgres installed. Specifically using a Bitnami virtual appliance. The post Benchmarking with Postgres PT1 appeared first on n0derunner. Image By Daniel Lundin.

Benchmarking 40

Benchmarking Virtualization Database Systems 40

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. Huge pages make PostgreSQL faster; can we implement it in Kubernetes?

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. High performance compute – Fastest and most powerful CPU virtual machines. Benchmark Test. VM Types and Sizes.

Azure 76

Azure Benchmarking Storage Virtualization 76

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 C++ Virtualization 68

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. I wrote about using CPU-Z to benchmark the Intel Xeon E5-2673 v3 processor in an Azure VM in this article. Figure 1: CPU-Z Benchmark Results for LS16v2. 10 x 1.9TB NVMe SSD.

Azure 42

Azure Virtualization Storage Benchmarking 42

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). Over the years, more and more articles have been published about clocksource in virtual machines, and it's now a well-known issue. include <sys/time.h>

Speed 103

Speed Java AWS Virtualization 103

HammerDB

APRIL 27, 2021

This will show the benchmark options dialog. Benchmark Options. and benchmark set with the bm argument. In the example below we have modified the SQL Server, number of warehouses to build and the virtual users to build them. A key aspect is being able to visualise the multithreaded nature of the Virtual Users.

Virtualization 74

Virtualization Benchmarking Database Operating System 74

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

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 We have long been surfing the virtualization wave (to keep it broad). Or, if we are hitting a limit in writes , we need to look at other areas of MySQL to tune.

Tuning 145

Tuning Cache Servers Benchmarking 145

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

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 71

Virtualization Benchmarking C++ Database 71

Percona

MARCH 17, 2023

Please note that the focus of these tests was around standard metrics gathering and display, we’ll use a future blog post to benchmark some of the more intensive query analytics (QAN) performance numbers. Virtual Memory utilization was averaging 48 GB of RAM.

Monitoring 117

Monitoring Scalability Database Cache 117

HammerDB

JULY 8, 2024

This is an important consideration that is often missed, so although it seems obvious, it is worth reiterating that benchmarking applications are not typically designed to be disconnected and the database restarted whilst the workload is running. When you create the virtual users, you can see the iterations value in the central panel.

Database 52

Database Benchmarking Virtualization C++ 52

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

HammerDB

JUNE 22, 2023

Job CLI Interface Jobs can also continue to be queried directly from the CLI with additional functionality at this interface such as querying the timings of individual Virtual Users. setOption(option_a3a1672ce6814324bd80d8b84cff1557); </script> </body> </html> Summary In this post we have introduced new HammerDB v4.8

Benchmarking 58

Benchmarking C++ Virtualization Database 58

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. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench. For storage, FIO is generally used. 4.22 %usr 38.40

Performance 55

Performance Benchmarking Cache Storage 55

The Morning Paper

SEPTEMBER 24, 2020

Instead, analyses expect their users to provide customization for web applications, which is a significant burden, virtually never overcome in practice. Popular static analysis frameworks for Java provide no support for the lifecycle or injected semantics of enterprise applications. Introducing JackEE. JackEE in action.

Java 80

Java Cache Benchmarking Programming 80

The Morning Paper

MAY 27, 2019

The work includes changes to the CHERI ISA, the C compiler, the C language runtime, the virtual memory APIs, and the CheriBSD kernel. On a context switch the kernel saves and restores user-thread register capability state, and updates virtual-physical mappings. For a macro-benchmark PostgreSQL’s initdb tool was used.

C++ 61

C++ Hardware Virtualization Benchmarking 61

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 132

Availability Database Open Source Hardware 132

HammerDB

NOVEMBER 22, 2021

This enables the user to compare and contrast performance across different benchmark scenarios. The example shows a TPROC-C workload running with 4 Active Virtual Users. Metrics view for benchmark. When a benchmark workload has completed, use the selection tool in the graph to select the metrics for a period of time of interest.

Metrics 63

Metrics Benchmarking C++ Database 63

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.

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. The actual overhead depends on your workload. Bear in mind that Netflix doesn't even use Fedora!) 2023, 2024: Frame Pointers in Fedora and Ubuntu!

Java 137

Java Cache Google Hardware 137

HammerDB

OCTOBER 24, 2023

BCP based load Now when we select the “Use BCP Option” We can see that we are now using an insert bulk command (although the item table being fixed at 100K rows and loaded by the monitor virtual user continues to use regular inserts). We thank @krithikasatish and @JoshInnis for this excellent contribution to HammerDB.

Servers 63

Servers C++ Benchmarking Virtualization 63

HammerDB

DECEMBER 14, 2022

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). ALL VIRTUAL USERS COMPLETE. Benchmark set to TPC-C for MariaDB. vuset vu vcpu.

C++ 63

C++ Virtualization Database Benchmarking 63

SQL Performance

AUGUST 27, 2019

The initial reviews and benchmarks for these processors have been very impressive: AMD EPYC 7002 Series Rome Delivers a Knockout. AMD Rome Second Generation EPYC Review: 2x 64-core Benchmarked. TPC-H Benchmark Results with SQL Server 2017. TPC-E Benchmark Results with SQL Server 2017. More total PCIe lanes and bandwidth.

Servers 52

Servers Benchmarking Architecture Virtualization 52

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