article thumbnail

Why you should benchmark your database using stored procedures

HammerDB

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

article thumbnail

HammerDB v4.3 New Features Pt1: Graphical Metrics for PostgreSQL

HammerDB

Introducing the PostgreSQL performance metrics viewer. HammerDB included a graphical performance metrics view for the Oracle database only. HammerDB includes the same functionality for PostgreSQL enabling the user to drill down on database metrics in real time. PostgreSQL Graphical Metrics. PostgreSQL Metrics treeview.

Metrics 62
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

What is infrastructure monitoring and why is it mission-critical in the new normal?

Dynatrace

IT infrastructure is the heart of your digital business and connects every area – physical and virtual servers, storage, databases, networks, cloud services. This shift requires infrastructure monitoring to ensure all your components work together across applications, operating systems, storage, servers, virtualization, and more.

article thumbnail

Getting Hands-on Training into more hands in 2021

Dynatrace

And we know as well as anyone: the need for fast transformations drives amazing flexibility and innovation, which is why we took Perform Hands-on Training (HOT) virtual for 2021. Here’s what’s new this year, and how you can get a front-row seat in our virtual classroom. More flexibility, more options. The Dynatrace University Team.

article thumbnail

How to Assess MySQL Performance

HammerDB

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. DISK METRICS sysstat_io_nvme0n1_avg_wait_ms 8.32

article thumbnail

Percona Monitoring and Management 2 Scaling and Capacity Planning

Percona

PMM2 uses VictoriaMetrics (VM) as its metrics storage engine. 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.

article thumbnail

HammerDB v4.7 New Features Pt 3: Lightweight Docker Images for rapid testing

HammerDB

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. How to deploy HammerDB CLI fast with Docker HammerDB v4.7 scripts/tcl/postgres/tprocc/pg_tprocc.sh