HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
ProLiant Servers (ML,DL,SL)
cancel
Showing results for 
Search instead for 
Did you mean: 

data transfer rate or sustainable transfer rate

 
bas_13
Occasional Visitor

data transfer rate or sustainable transfer rate

What's the data transfer rate (or upper/lower or average sustainable transfer rate) of a universal scsi U320 disk?
And is there a list with these numbers for different disks (sata, sas, U320, U160, Raid 1 with U320 etc.)
I need this info because we ran frequently into performance related issues with disks and do not know the data tranfer rates of the disks ....

e.g. a sql job on a new desktop machine (2005) runs faster than on a raid-1 dl380 G4 (2005) with the same OS (w2k3 sp1) and sql2ksp3a on it.
We have no idea why this is, we expect the opposite..

with kind regards,
Bas Hendriks.
2 REPLIES
Oleg Koroz
Honored Contributor

Re: data transfer rate or sustainable transfer rate

You can find dozen reasons for performance related issues
Hard drives speed, cache size, protocol speed, firmware updates
Array Controller Firmware updates, driver, cabling
Memory, size, type, CPU
Antivirus, All kind Performance Counters, Software
If use PCI Card Array controller, if any additional card on the same bus
Cache Accelerator, size of cache accelerator
Read Write Ratio if use BBWC
If all Hard Drive with identical speed: 10K or 15K?
Sector, strip size?
O/S 2003 or 2003, there is many reports when 2003 found slower than 2000

You just need to compare
http://h18004.www1.hp.com/products/servers/proliantstorage/drives-enclosures/hotplug-ultra3/index.html
http://h18004.www1.hp.com/products/servers/proliantstorage/serial/sata/index.html
http://h18004.www1.hp.com/products/servers/proliantstorage/serial/sas/index.html

From HP Update all firmwareâ s & drivers
From Microsoft Knowledge Base check for similar to:

http://support.microsoft.com/default.aspx?scid=kb;en-us;555041
http://support.microsoft.com/search/default.aspx?spid=global&query=2003+and+performance+&catalog=LCID%3D1033&pwt=false&title=false&kt=BOOLEAN&mdt=0&comm=1&ast=1&ast=2&ast=3&mode=a


bas_13
Occasional Visitor

Re: data transfer rate or sustainable transfer rate

Thankx for your respons.
You are right with your answer.
But this is not what i need to know.
Let me clarify my question more.

I have a problem with getting a kind of expected maximum transfer rate (Mbytes/s) of a U320 disk in a dl380. I saw on the internet a article which gave me some clue:

Enhancing performance of HP ProLiant servers containing Smart Array 6i controllers
http://h200005.www2.hp.com/bc/docs/support/SupportManual/c00366606/c00366606.pdf

The problem is that the data transfer rate i'm measuring ia approx 12-17 MByte/s.
But with a single SATA disk i get approx 6 times more Mbytes/s

The performance issue is on the local machine only, there is no network transfer involved. I'm copying files from disk1 to disk2.

This is not the first time i have problems sizing a system with raid sets of disks in it.
I therefore need to get a number for the data transfer rate and not only for read but also for write.
I'm using now a dl380G4 with a 2 disk raid10.
The sql application with which i'm having problems know is one which reads a 10 Mbyte file and writes to a 1.5 Gbyte database to the same logical disk.
The system is very busy writing the database and i'm waiting approx 48 hr (on sata 8 hr)

We installed the lastest drivers and firmware but this didn't help.

The question for me is more when do i get a limiting situation (by controller, disks etc.).

Because this sql job is the (approx)only job on the system i expect that SATA will be faster than SCSI (the link above gives me the same values i get now)
(IDE/ata/sata will be faster in a single file download, scsi in a multifile download)

And when i use a different raid set how can i get more write performance out of this configuration or do i need different disks, different raid controller

Copying a file from disk1 to disk2 gives me the same transfer rate (12-17 Mbyte/s) so that's why i expect the issue to be a hardware related issue with the disk/controller.


with king regards,

Bas Hendriks