SAN read write speed test
hi all
we have a SAN configured and divided into 4 arrays for SQL.
is there any test i could do to simply test the read and write time between the discs to ensure i have no firmware/config issues etc etc ? eg when copying from one of the arrays to another what transfer speed is acceptable etc?
we have a SAN configured and divided into 4 arrays for SQL.
is there any test i could do to simply test the read and write time between the discs to ensure i have no firmware/config issues etc etc ? eg when copying from one of the arrays to another what transfer speed is acceptable etc?
ASKER
hi Soren
its a EMC Navisphere Express
Version 6.23.6.0.6
its a EMC Navisphere Express
Version 6.23.6.0.6
Dear malraff,
ok sorry to hear - I am thus not able to assist in this matter.
Best of luck obtaining answer from somebody else.
Kind regards,
Soren
ok sorry to hear - I am thus not able to assist in this matter.
Best of luck obtaining answer from somebody else.
Kind regards,
Soren
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi meyersd, i started another thread thinking they where different question but really they are the same .. regarding what performance i need - im not sure. i just want to know if someone with a trained eye can spot a potential hazard!
the following is what sqliosim has told me
--
all the drives are 300GB 15k rpm sata
E and G are both raid 1 and 2 discs each
F 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
the following is what sqliosim has told me
--
all the drives are 300GB 15k rpm sata
E and G are both raid 1 and 2 discs each
F 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
what SAN vendor do you have?
Kind regards,
Soren