article thumbnail

Crucial Redis Monitoring Metrics You Must Watch

Scalegrid

You will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health. Redis returns a big list of database metrics when you run the info command on the Redis shell. You can pick a smart selection of relevant metrics from these.

Metrics 130
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.

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

Benchmarking spreadsheet systems

The Morning Paper

Benchmarking spreadsheet systems Rahman et al., construct a set of benchmarks to try and understand what might be going on under the covers in Microsoft Excel, Google Sheets, and LibreOffice Calc. Finally a metric that penalises marketing departments for exaggeration! A recent TwThread drew my attention to this pre-print paper.

article thumbnail

Grafana Dashboards: A PoC Implementing the PostgreSQL Extension pg_stat_monitor

Percona

This PoC demonstrates how to install and configure pg_stat_monitor in order to extract useful and actionable metrics from a PostgreSQL database and display them on a Grafana dashboard. About the environment Grafana: version 10.0.0 Grafana database backend: Prometheus version 2.15.2+d

article thumbnail

What is application modernization? How to pick an application modernization strategy

Dynatrace

Document and benchmark existing applications, processes, and services. Or, the team might use specific serverless designs as part of the modernization efforts. It’s important to create a baseline of metrics in an application modernization strategy. Then, set realistic KPIs underlying application modernization efforts.

Strategy 219
article thumbnail

How To Scale a Single-Host PostgreSQL Database With Citus

Percona

Leveraging pgbench , which is a benchmarking utility that comes bundled with PostgreSQL, I will put the cluster through its paces by executing a series of DML operations. And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty.

Database 104
article thumbnail

The evolution of single-core bandwidth in multicore processors

John McCalpin

The primary metric for memory bandwidth in multicore processors is that maximum sustained performance when using many cores. This metric is interesting because we don’t always have the luxury of parallelizing every application we run, and our operating systems almost always process each call (e.g., Details in the next blog entry.)