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.

Azure 72

Azure Virtualization Servers Storage 72

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? Note if you only have browser access to a remote server you can run HammerDB through the browser, so this functionality is available in all environments.

Benchmarking 68

Benchmarking Performance Metrics Database 68

Percona

AUGUST 22, 2023

With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have. This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). What does high availability mean?

Availability 98

Availability Hardware Open Source Database 98

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

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. Kubectl helps to check the amount of huge pages available.

C++ 120

C++ Virtualization Benchmarking Database 120

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

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 MySQL comes pre-configured to be conservative instead of making the most of the resources available in the server. MySQL (B) 2517529 2610323 389048 5516900 194140 11523.48

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

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

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 VMs are not available in all regions, so you will want to check the availability in the Azure region that you are interested in using. Figure 2: Microsoft Project Olympus.

Azure 42

Azure Virtualization Storage Benchmarking 42

HammerDB

APRIL 27, 2021

This displays the available CLI commands with “help command” providing detailed information about the command and arguments required. This will show the benchmark options dialog. Benchmark Options. and benchmark set with the bm argument. In the CLI the print dict command shows us the available options.

Virtualization 74

Virtualization Benchmarking Database Operating System 74

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

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). Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. This was much worse many years ago on Xen virtual machine guests.

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

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

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

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. Virtual Memory utilization was averaging 48 GB of RAM.

Monitoring 117

Monitoring Scalability Database Cache 117

Alex Russell

APRIL 29, 2021

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. Higher is better.

Media 145

Media Games Education Engineering 145

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. Though still not “profitable” by many benchmarks, it’s a lot closer to being so, perhaps in a big way.) MongoDB is commonly referred to as source-available software. 2017: MongoDB goes public, trading as MDB.

Open Source 98

Open Source Programming Database Servers 98

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

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. As this setting is related to automated workloads the same setting is also available in the Autopilot options.

C++ 52

C++ Performance Benchmarking Virtualization 52

Brendan Gregg

MARCH 16, 2024

This technique saves two instructions in the prologue and epilogue and makes one additional general-purpose register (%rbp) available." 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.

Java 137

Java Cache Google Hardware 137

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. Preferred AMD EPYC Processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

HammerDB

DECEMBER 14, 2022

The scripts are available in both Python and Tcl formats. 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.

C++ 63

C++ Virtualization Database Benchmarking 63

Abhishek Tiwari

DECEMBER 27, 2017

Containerized data workloads running on Kubernetes offer several advantages over traditional virtual machine/bare metal based data workloads including but not limited to. Kubernetes has all necessary primitives available to make it happen. better cluster resource utilization. portability between cloud and on-premises. Performance.

Big Data 63

Big Data Storage Benchmarking Hardware 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. For TPC-C this meant enough available spindles to reduce I/O latency and for TPC-H enough bandwidth for data throughput.

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

n0derunner

JUNE 28, 2019

One of the nice things about using public cloud is the ability to use pre-canned application virtual appliances created by companies like Bitnami. We can use these same appliance images on Nutanix AHV to easily do a Postgres database benchmark. Importing OVAs direct into AHV should be available in the future. wget [link].

Benchmarking 40

Benchmarking C++ Virtualization Database 40

Brendan Gregg

FEBRUARY 9, 2018

This overhead can be reduced by A) pcid, fully available in Linux 4.14, and B) Huge pages. - **Cache access pattern**: the overheads are exacerbated by certain access patterns that switch from caching well to caching a little less well. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. Linux 4.14.12-virtual

Performance 72

Performance Benchmarking Cache Tuning 72

Rigor

FEBRUARY 19, 2020

Synthetic monitoring is one of the best ways to detect outages or availability issues since it actively tests your site from the outside. Is it a physical system or virtual? If virtualized, what is the technology used (VM, Docker, software package)? Competitive & Industry Benchmarking. And BOOM, you’re done!

Monitoring 59

Monitoring Benchmarking Mobile Testing 59

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? and earlier. <benchmark> The fix to this was to move to a newer ODBCv3 interface called tdbc::odbc.

C++ 52

C++ Benchmarking Metrics Database 52

Smashing Magazine

JUNE 3, 2022

And today, we still have type in a digital context, but it travels through cables, wirelessly on smartphones, and in virtual reality glasses in 3D. There are many typefaces, and many of them are very similar or are nearly identical to previous or contemporary versions available. There are many different classifications of typefaces.

Performance 123

Performance Design Best Practices Testing 123

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.

Speed 52

Speed Java AWS Virtualization 52

Percona

DECEMBER 20, 2018

We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud. In this benchmark, I discovered some interesting discrepancies in performance between AMD and Intel CPUs when running under systemd. A Look at MyRocks Performance.

Database 50

Database Tuning Performance AWS 50

HammerDB

NOVEMBER 30, 2018

HammerDB is open source and all of the source code is available at the sourceforge Git development site here [link] or the github mirror here [link]. As virtual users are started the database specific packages and workload specific modules are loaded into the virtual user threads. Virtual Users. program in TCL. #!/usr/local/bin/tclsh8.6

Architecture 40

Architecture Virtualization Open Source C++ 40

Apica

MAY 10, 2019

The Apica LoadTest solution uses innovative technologies like monitoring nodes and load clusters to reliably deliver and sustain a large-scale load of virtual users (VUs) to Hollywood for different, realistic user scenarios all at the same time. Load and stress-testing benchmark goals for the backend technological components.

Testing 40

Testing Performance Social Media Wireless 40

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.

Speed 40

Speed Java AWS Virtualization 40