[ Comments below, in line ] On Friday 06 March 2009 at 1:33 pm, Peter Ondru?ka penned about "Re: [vbox-users] disk throughput only 25% of native"
> Hi Pablo,
> I'd be very interested.
Hi Peter,
The test below is using Windows 2003 Server SP 2 as the Guest O/S. I
have a SQL Server 2005 database with 90GB of data. Below is a query
against a large table:
select count(*) from honk_n
I have three SATA drives on my desktop machine. The data resides on
`sdb' (`dev8-16' and `dev8-17' below).
Attached is a snap of `gkrellm' during the run. You can see `sdb's
I/O as I ran the benchmark, stopped it and ran it for a longer period
of time.
Below is a sample of the `sar -d 3 xxx' output during the run.
In my experience, performance is throttled by CPU or Disk. This is
why I asked to see Brian's CPU metrics. :)
Cheers,
-pablo
::::::::::::::::::::::
::: sar -d 3 xxxxx :::
::::::::::::::::::::::
03:47:56 PM DEV tps rd_sec/s wr_sec/s avgrq-sz avgqu-sz
await svctm %util
03:47:59 PM dev8-0 66.56 3480.79 5.30 52.38 0.21
3.08 2.79 18.54
03:47:59 PM dev8-1 1.66 37.09 0.00 22.40 0.03
18.40 7.20 1.19
03:47:59 PM dev8-2 64.90 3443.71 5.30 53.14 0.17
2.69 2.67 17.35
03:47:59 PM dev8-16 460.60 117827.81 42.38 255.91 1.63
2.73 1.82 83.97
03:47:59 PM dev8-17 460.60 117827.81 42.38 255.91 1.63
2.73 1.82 83.97
03:47:59 PM dev11-0 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:47:59 PM dev8-32 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:47:59 PM dev8-33 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:47:59 PM DEV tps rd_sec/s wr_sec/s avgrq-sz avgqu-sz
await svctm %util
03:48:02 PM dev8-0 118.27 3795.35 430.56 35.73 14.79
125.09 3.63 42.92
03:48:02 PM dev8-1 1.33 26.58 0.00 20.00 0.02
18.00 9.00 1.20
03:48:02 PM dev8-2 116.94 3768.77 430.56 35.91 14.77
126.31 3.61 42.26
03:48:02 PM dev8-16 466.78 120348.17 13.29 257.86 1.58
4.18 1.77 82.39
03:48:02 PM dev8-17 466.78 120348.17 13.29 257.86 1.58
4.18 1.77 82.39
03:48:02 PM dev11-0 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:02 PM dev8-32 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:02 PM dev8-33 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:02 PM DEV tps rd_sec/s wr_sec/s avgrq-sz avgqu-sz
await svctm %util
03:48:05 PM dev8-0 12.37 315.72 10.70 26.38 0.18
14.70 8.32 10.30
03:48:05 PM dev8-1 0.67 42.81 0.00 64.00 0.03
40.00 40.00 2.68
03:48:05 PM dev8-2 11.71 272.91 10.70 24.23 0.16
13.26 8.00 9.36
03:48:05 PM dev8-16 454.18 115464.88 10.70 254.25 5.96
12.81 1.75 79.60
03:48:05 PM dev8-17 454.18 115464.88 10.70 254.25 5.96
12.81 1.75 79.60
03:48:05 PM dev11-0 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:05 PM dev8-32 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:05 PM dev8-33 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:05 PM DEV tps rd_sec/s wr_sec/s avgrq-sz avgqu-sz
await svctm %util
03:48:08 PM dev8-0 155.12 5557.76 203.30 37.14 17.14
110.49 2.94 45.68
03:48:08 PM dev8-1 0.33 5.28 0.00 16.00 0.01
24.00 24.00 0.79
03:48:08 PM dev8-2 154.79 5552.48 203.30 37.19 17.13
110.68 2.91 45.02
03:48:08 PM dev8-16 446.86 115163.04 10.56 257.74 2.32
4.32 2.22 99.01
03:48:08 PM dev8-17 446.86 115163.04 10.56 257.74 2.32
4.32 2.22 99.01
03:48:08 PM dev11-0 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:08 PM dev8-32 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:08 PM dev8-33 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:08 PM DEV tps rd_sec/s wr_sec/s avgrq-sz avgqu-sz
await svctm %util
03:48:11 PM dev8-0 69.67 2280.00 232.00 36.06 1.18
16.90 3.56 24.80
03:48:11 PM dev8-1 19.00 450.67 0.00 23.72 0.11
5.54 3.09 5.87
03:48:11 PM dev8-2 50.67 1829.33 232.00 40.68 1.07
21.16 3.95 20.00
03:48:11 PM dev8-16 369.00 92941.33 24.00 251.94 2.60
8.16 2.64 97.33
03:48:11 PM dev8-17 369.00 92941.33 24.00 251.94 2.60
8.16 2.64 97.33
03:48:11 PM dev11-0 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:11 PM dev8-32 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:11 PM dev8-33 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:11 PM DEV tps rd_sec/s wr_sec/s avgrq-sz avgqu-sz
await svctm %util
03:48:14 PM dev8-0 107.26 3493.07 5.28 32.62 1.17
10.92 6.08 65.21
03:48:14 PM dev8-1 32.67 871.29 0.00 26.67 0.51
15.60 10.71 34.98
03:48:14 PM dev8-2 74.59 2621.78 5.28 35.22 0.66
8.87 8.30 61.91
03:48:14 PM dev8-16 278.22 69359.74 63.37 249.53 3.00
11.29 3.31 92.01
03:48:14 PM dev8-17 278.22 69359.74 63.37 249.53 3.00
11.29 3.31 92.01
03:48:14 PM dev11-0 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:14 PM dev8-32 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:14 PM dev8-33 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:14 PM DEV tps rd_sec/s wr_sec/s avgrq-sz avgqu-sz
await svctm %util
03:48:17 PM dev8-0 79.00 1762.67 354.67 26.80 10.10
127.85 3.02 23.87
03:48:17 PM dev8-1 1.67 61.33 0.00 36.80 0.03
20.80 12.80 2.13
03:48:17 PM dev8-2 77.33 1701.33 354.67 26.59 10.07
130.16 2.84 22.00
03:48:17 PM dev8-16 370.33 95061.33 10.67 256.72 1.41
3.83 2.30 85.20
03:48:17 PM dev8-17 370.33 95061.33 10.67 256.72 1.41
3.83 2.30 85.20
03:48:17 PM dev11-0 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:17 PM dev8-32 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:17 PM dev8-33 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:17 PM DEV tps rd_sec/s wr_sec/s avgrq-sz avgqu-sz
await svctm %util
03:48:20 PM dev8-0 45.33 1146.67 5.33 25.41 0.29
6.47 5.38 24.40
03:48:20 PM dev8-1 3.00 50.67 0.00 16.89 0.05
17.78 8.44 2.53
03:48:20 PM dev8-2 42.33 1096.00 5.33 26.02 0.24
5.67 5.39 22.80
03:48:20 PM dev8-16 343.00 88576.00 10.67 258.27 1.32
3.85 2.36 80.80
03:48:20 PM dev8-17 343.00 88576.00 10.67 258.27 1.32
3.85 2.36 80.80
03:48:20 PM dev11-0 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:20 PM dev8-32 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
03:48:20 PM dev8-33 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
--
Pablo Sanchez - Blueoak Database Engineering, Inc
Ph: 819.459.1926 Fax: 760.860.5225 (US)
<<attachment: perf.png>>
_______________________________________________ vbox-users mailing list [email protected] http://vbox.innotek.de/mailman/listinfo/vbox-users
