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. ./ -I/opt/postgresql-14.1/include/server include/server -I/opt/postgresql-14.1/include/internal

Metrics 62
article thumbnail

A thorough introduction to bpftrace

Brendan Gregg

bpftrace is a new open source tracer for Linux for analyzing production performance problems and troubleshooting software. software Kernel software-based events. hardware Hardware counter-based instrumentation. Originally posted at https:/opensource.com/article/19/8/introduction-bpftrace.

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