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

bpftrace uses BPF (Berkeley Packet Filter), an in-kernel execution engine that processes a virtual instruction set. hardware Hardware counter-based instrumentation. In this post I'll summarize the bpftrace language, variable types, probes, and tools. The currently supported types are (more will be added): Type Description.

Latency 68
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

ReadFile WriteFile ReadFileScatter WriteFileGather GetOverlappedResult ​​ For extended details on the 823 error, see ​​ Error message 823 may indicate hardware problems or system problems ​​ ( [link] i crosoft.com/default.aspx?scid=kb ​​ Contact your hardware manufacture for assistance.

Servers 40