On Janurary 5th 2010 I gave a short presentation on the FileBench workload modeling tool to the RTP OpenSolaris group. Click on the slide to advance. The “Slides” link will take you to an HTML version.
Slides
Read more »
Posts Tagged ‘ benchmark ’
10GbE
asm
bash
benchmark
binary
bss
compiler
core
corruption
cp
disks
enomem
exec
filer
flexvol
fork
ifconfig
linux
ndmp
netapp
network
nm
ontap
oracle
Performance
perl md5 scripts
pmap
reliability
rpm
Scripts
segv
SIGCLD
size
solaris
sort
sql
storage
strace
swap
sysstat
tpch
tradvol
truss
unix
unix commands
Presentation to RTP OpenSolaris group on Filebench.
Benchmarking Blunders and Things That Go Bump in the Night
A 2004 paper from Neil Gunther which essentially discusses the pitfalls of relying on observed date without applying the known performance laws (most notably little’s law) to the problem at hand.
PDF
The original link to arXiv.org (whatever that is)
Read more »
Sorting TPC-H lineitem table.
Sometimes it is useful to sort the lineitem table, in the order that Query-6 will read the data back.
Query-6 looks like so :-
set timing on;
select
sum(l_extendedprice * l_discount) as revenue
from
lineitem
where
l_shipdate >= to_date( '1995-01-01', 'YYYY-MM-DD')
and l_shipdate < add_months(to_date( '1995-01-01', 'YYYY-MM-DD'), 12)
and l_discount between 0.07 - 0.01 and 0.07 + 0.01
and l_quantity < 25;
exit;
and...
Read more »