Sign in with
Sign up | Sign in
Your question

Database benchmark pattern IOMeter

Tags:
  • Benchmark
  • Database
  • Storage
Last response: in Storage
Share
June 2, 2010 2:47:11 PM

Hi there,

I'm testing several servers and would like to compare the results with eachother and with results viewed on Toms Hardware.

I would like to know what configuration is used when testing with a "Database benchmark pattern".
I've been testing with: 8k 100% random 67% reads en q=32. Get results like 44.800 IOPS. Thats quite a lot comparing with results found on acticles op Tom's Hardware.

Thanks for your answers!

More about : database benchmark pattern iometer

a c 127 G Storage
June 2, 2010 3:18:14 PM

45k IOps is with an SSD? Quite high yes, especially for 8KiB. So what device are you benchmarking? Do you have a write-back mechanism?
June 2, 2010 3:39:48 PM

sub mesa said:
45k IOps is with an SSD? Quite high yes, especially for 8KiB. So what device are you benchmarking? Do you have a write-back mechanism?


I get it where I was wrong. On my PC 50.000 sectors are 9.1 GB.
On my servers 50.000 sectors are 25.000kb. So thats messing my results..

Om my PC (yes: SSD) I get 15.4k IOPS with 50.000 sector testing (9.1GB).

After setting server sectorcount to 18200000 (9.1GB), I get 'only' 1400 IOPS. :-)



Related resources
!