Re: Throughput of read operations

2011-08-12 Thread Jeremiah Peschka
If the numbers you reported are the average, that's interesting. Were you using an EBS volume or an ephemeral volume? You can definitely be seeing a noisy neighbor effect, although typically you'll see inconsistent results. --- Jeremiah Peschka - Founder, Brent Ozar PLF, LLC Microsoft SQL Server

Re: Throughput of read operations

2011-08-12 Thread Maria Neise
I ran it on one day (on a sunday) but each workload 4 or 5 times and my hard drive had 150GB. So it could be Amazons fault? :) Cheers, Maria On 12 August 2011 16:50, Jeremiah Peschka wrote: > One question that pops into my mind is are these numbers averages over 3 or 5 > runs or is this a singl

Re: Throughput of read operations

2011-08-12 Thread Jeremiah Peschka
One question that pops into my mind is are these numbers averages over 3 or 5 runs or is this a single run? In my experience with EC2, I've run into I/O inconsistencies when I'm using anything less than 1TB drives and a large instance. There's a lot of potential for a noisy neighbor to steal I/

Throughput of read operations

2011-08-12 Thread Maria Neise
Hey, I am doing some benchmarks with Riak and set up a cluster with 6 server using Amazon EC2. On each server I have GB of data. I am using Bitcask as backend and the Java-API for my client. I have some workloads with different proportion of operations, for example insert, read and update. I start