Testing Server Write Performance

There is a widely accepted test of write performance for your database server. Commands courtesy of Tom Bascom. 

In a proenv session:

Linux:

#!/bin/sh

#

# Similar to:

#   dd if=sports.b1 of=foo oflag=dsync

#

# minimum acceptable result is 10MB/sec -- or 9 seconds

#   4 or 5 seconds is "good"

#   3 or less is excellent (probably SSD)

prodb sports sports

proutil sports -C truncate bi -bi 16384

ls -ltr sports.b1

time proutil sports -C bigrow 2 # -zextendSyncIO

ls -ltr sports.b1

# time dd if=sports.b1 of=sports.b1.dd oflag=dsync

In Windows:

prodb sports sports

proutil sports -C truncate bi -bi 16384

proutil sports -C bigrow 2 

Then check the timings of the bigrow in the db log file. 

Copyright © 2018 James Palmer
GS RU