Jean-François ESPERET
asked on
IOPS performnce with HP SSD and Raid controler 440ar
We have server ML350G9 with SmartArray 440ar with 5 disk in RAID5 . We have add 2 HP SD WRITE INTENSIVE 480GO in RAID1. The benchmark IOPS test are slow. We have done test with Cache On/off and with SmatPath On/Off. We never reach more than 10000 IOPS !
Do you know what's happened ?
JF ESPERET
Do you know what's happened ?
JF ESPERET
What are you using for benchmarking and how many threads is it running?
ASKER
We have a logicial drive in RAID1 with the 2 SSD. There is only 1 RAID controler HP 440ar. We need more IOPS for MS SQL apllication performance.
I do my HDD test with AS SSD Benchmark.
I do my HDD test with AS SSD Benchmark.
If they are SATA you could re-run the test using the motherboard SATA ports, can't bypass the RAID controller chip if they are SAS (well you can but it's all or nothing so the 5 others would stop working).
What kind of application? When "optimizing" MSSQL applications by throwing hardware at the problem, the first thing is to check the installation and the actual bottleneck.
Here more RAM (read performance) and having the correct number of tembdb files (1 file per core and when contention is a problem add 4 files in each mitigation step).
For testing the RAID I would use DiskSpd.
And to see, how good or bad the numbers are: Test your SSD's not connected to the RAID and then in the RAID1. Post the numbers.
Here more RAM (read performance) and having the correct number of tembdb files (1 file per core and when contention is a problem add 4 files in each mitigation step).
For testing the RAID I would use DiskSpd.
And to see, how good or bad the numbers are: Test your SSD's not connected to the RAID and then in the RAID1. Post the numbers.
Whether it's intended for SQL or not they should be getting a far higher result, at least with 64 threads. The single thread results from AS SSD Benchmark are pretty meaningless especially for write since that's as much a test of the server's CPU, RAM and bus speed and completely irrelevant unless they intend to restrict SQL to one thread. I hadn't tried it before so I asked how many threads they were running not realising it did single thread plus 64 thread test each time it was run.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
The other thing: How many RAID controllers does your ML350G9 box have? Not that you share a single controller for both RAIDs.