article thumbnail

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

HammerDB

shared_preload_libraries = 'pg_stat_statements,pgsentinel' track_activity_query_size=2048 pg_stat_statements.save=on pg_stat_statements.track=all pgsentinel_pgssh.enable = true pgsentinel_ash.pull_frequency = 1 pgsentinel_ash.max_entries = 1000000. The example shows a TPROC-C workload running with 4 Active Virtual Users. pgsentinel.c

Metrics 62
article thumbnail

A thorough introduction to bpftrace

Brendan Gregg

For example, iostat(1), or a monitoring agent, may tell you your average disk latency, but not the distribution of this latency. bpftrace uses BPF (Berkeley Packet Filter), an in-kernel execution engine that processes a virtual instruction set. In this post I'll summarize the bpftrace language, variable types, probes, and tools.

Latency 68
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

​​ The following table outlines the virtual protection states. Page State Virtual Protection State Dirty Read Write ​​ during the modification. Page State Virtual Protection State Dirty Read Write ​​ during the modification.

Servers 40