June 24, 2013 at 4:08 am
I had format the disk to 64KB and perform a test case using CrystalDiskMark. The result is under expectation. Why i cant get the 20% performance improvement if compare to the default disk format 4096 bytes?
June 24, 2013 at 4:25 am
Why were you expecting a 20% performance improvement?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2013 at 5:22 am
I was expecting at least 10-20% improvement. However the result is worst than the 4096bytes. It is degraded the performance. please see my test result using SQLIOSIm. What's wrong for my disk format 64kb? Do i need to set anything to improve SQL server performance?
FileName TargetIODuration_ms RunningAverageIODuration_ms (Low values are good) NumberOfTimesIOThrottled (Low numbers are better) "IORequestBlocks
(High numbers are good)" "Reads
(High numbers are good)" "ScatterReads
(High numbers are good)" "Writes
(High numbers are good)" "GatherWrites
(High numbers are good)" TotalIOTime_ms
D:\sqliosim.mdx 100 367 4933 10 14905 20209 984 21412 18676013
F:\sqliosim.mdx 100 475 3916 9 11969 18103 693 20642 45129383
F:\sqliosim.ldx 100 36 29 8 0 0 12832 0 320531
D:\sqliosim.ldx 100 3 20 8 0 0 12952 0 300425
June 24, 2013 at 5:30 am
SQLIOSim is not a performance testing tool. It's a stress tester designed to hammer an IO subsystem and see if it throws errors. Perhaps try an IO performance test tool?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2013 at 5:34 am
I also using SQLIO to test it, below is my result. Any other IO performance tool that i can use to test the disk 64KB?
D:\testfile.dat (4096 bytes) F:\testfile.dat (64 kilobytes)
File size : 20GB File size : 20GB
Test will last 120 seconds Test will last 120 seconds
Random Writes Test Random Writes Test
IOs/sec: 184.48 IOs/sec: 179.49
MBs/sec: 1.44 MBs/sec: 1.40
latency metrics: latency metrics:
Min_Latency(ms): 1 Min_Latency(ms): 1
Avg_Latency(ms): 346 Avg_Latency(ms): 355
Max_Latency(ms): 542 Max_Latency(ms): 528
Random Reads Test Random Reads Test
IOs/sec: 193.39 IOs/sec: 175.43
MBs/sec: 1.51 MBs/sec: 1.37
latency metrics: latency metrics:
Min_Latency(ms): 6 Min_Latency(ms): 25
Avg_Latency(ms): 329 Avg_Latency(ms): 363
Max_Latency(ms): 2274 Max_Latency(ms): 2614
Sequential Writes Test Sequential Writes Test
IOs/sec: 1409.14 IOs/sec: 1024.48
MBs/sec: 88.07 MBs/sec: 64.03
latency metrics: latency metrics:
Min_Latency(ms): 0 Min_Latency(ms): 1
Avg_Latency(ms): 45 Avg_Latency(ms): 61
Max_Latency(ms): 181 Max_Latency(ms): 221
Sequential Reads Test Sequential Reads Test
IOs/sec: 1445.88 IOs/sec: 1073.58
MBs/sec: 90.36 MBs/sec: 67.09
latency metrics: latency metrics:
Min_Latency(ms): 6 Min_Latency(ms): 13
Avg_Latency(ms): 43 Avg_Latency(ms): 59
Max_Latency(ms): 3198 Max_Latency(ms): 3100
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply