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

Evaluating the Evaluation: A Benchmarking Checklist

Brendan Gregg

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. These have inspired me to summarize another performance activity: evaluating benchmark accuracy. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec?

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

IT carbon footprint: Dynatrace Carbon Impact and Optimization app helps organizations measure cloud computing carbon footprint

Dynatrace

These metrics include CPU, memory, disk, and network I/O. This analysis provides us with a holistic view of our multicloud environment’s carbon emissions and identifies major emissions sources. Or open a Notebook for ad hoc analysis, giving us insights so we can safely scale down or retire underutilized instances.

Energy 239
article thumbnail

Container security: What it is, why it’s tricky, and how to do it right

Dynatrace

To function effectively, containers need to be able to communicate with each other and with network services. If containers are run with privileged flags, or if they receive details about host processes, they can easily become points of compromise for corporate networks. Network scanners. Why is container security tricky?

article thumbnail

Grafana Dashboards: A PoC Implementing the PostgreSQL Extension pg_stat_monitor

Percona

This allows for much better data accuracy, especially in the case of high-resolution or unreliable networks. This simplifies debugging and analysis processes by enabling users to execute the same query. A script executing a benchmarking run: #!/bin/bash This allows a user to drill down into the performance of queries.

article thumbnail

Evaluating the Evaluation: A Benchmarking Checklist

Brendan Gregg

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. These have inspired me to summarize another performance activity: evaluating benchmark accuracy. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec?

article thumbnail

Crucial Redis Monitoring Metrics You Must Watch

Scalegrid

These can help you ensure your system’s health and quickly perform root cause analysis of any performance-related issue you might be encountering. It’s important to note that recommended throughput levels may vary depending on factors such as operating system type, network bandwidth availability, and hardware quality.

Metrics 130