|
malraff
Starting Member
10 Posts |
 Posted - 2010-04-14 : 07:46:49
|
| hi i have ran sqliosim on a new server, and gathered some results and would appreciate a 2nd opinion on them the C drive is the os and is a virtual machine on another system, so its E,F and G i am more interested as they are on a new SANall the drives are 300GB 15k rpmE and G are both raid 1 and 2 discs eachF is 6 discs in raid 10 ********** Final Summary for file C:\sqliosim.mdx ********** Target IO Duration (ms) = 100, Running Average IO Duration (ms) = 70, Number of times IO throttled = 663, IO request blocks = 16, Reads = 15886, Scatter Reads = 31677, Writes = 539, Gather Writes = 25479, Total IO Time (ms) = 8998320 ********** Final Summary for file E:\sqliosim.mdx ********** Target IO Duration (ms) = 100, Running Average IO Duration (ms) = 15, Number of times IO throttled = 1672, IO request blocks = 39, Reads = 11935, Scatter Reads = 29518, Writes = 645, Gather Writes = 25870, Total IO Time (ms) = 17795599 ********** Final Summary for file F:\sqliosim.mdx ********** Target IO Duration (ms) = 100, Running Average IO Duration (ms) = 15, Number of times IO throttled = 1412, IO request blocks = 41 , Reads = 10919, Scatter Reads = 28833, Writes = 451, Gather Writes = 25457, Total IO Time (ms) = 8311949 ********** Final Summary for file G:\sqliosim.mdx ********** Target IO Duration (ms) = 100, Running Average IO Duration (ms) = 14, Number of times IO throttled = 1079, IO request blocks = 153, Reads = 12575, Scatter Reads = 29844, Writes = 981, Gather Writes = 26168, Total IO Time (ms) = 8284344 ********** Final Summary for file G:\sqliosim.ldx ********** Target IO Duration (ms) = 100, Running Average IO Duration (ms) = 0, Number of times IO throttled = 0, IO request blocks = 8, Reads = 0, Scatter Reads = 0, Writes = 11031, Gather Writes = 0, Total IO Time (ms) = 199786 ********** Final Summary for file F:\sqliosim.ldx ********** Target IO Duration (ms) = 100, Running Average IO Duration (ms) = 1, Number of times IO throttled = 0, IO request blocks = 8 Reads = 0, Scatter Reads = 0, Writes = 10826, Gather Writes = 0, Total IO Time (ms) = 170139 ********** Final Summary for file E:\sqliosim.ldx ********** Target IO Duration (ms) = 100, Running Average IO Duration (ms) = 1, Number of times IO throttled = 14, IO request blocks = 8 , Reads = 0, Scatter Reads = 0, Writes = 10174, Gather Writes = 0, Total IO Time (ms) = 195850 |
|
SQLIOSIM results on a SAN to be used for SQL