Home » RDBMS Server » Server Administration » Storage IOPS and transport speed (Oracle 10.2.0.5 Linux)
Storage IOPS and transport speed [message #544179] Mon, 20 February 2012 09:28 Go to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
I have seen at many places even for small database when it comes to choosing the HBA for storage everyone goes for 4G FC,6GB SAS and 10GB FCoE.
If we go with a storage with 50 disks each 15k speed and Oracle block size 8K and calculate the IOPS it works well with a 1GB transport link between the host and storage.
Does one really need this high capacity HBA's?
Re: Storage IOPS and transport speed [message #544195 is a reply to message #544179] Mon, 20 February 2012 10:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't understand a single word of what you say.
We are mostly database administrators, please post some definitions: what are
- HBA
- 4G FC
- 6GB SAS
- 10GB FCoE
- 15k speed
- IOPS

Regards
Michel

[Updated on: Mon, 20 February 2012 10:17]

Report message to a moderator

Re: Storage IOPS and transport speed [message #544201 is a reply to message #544195] Mon, 20 February 2012 10:46 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
Sorry to say this but its like a Software Engineer asking what is a CPU,CDROM,RAM.
A good DBA should be aware about the hardware on which he runs the database like Storage,RAID,transport medium etc.

HBA: Host bus Adapter
4Gb FC or 6GB SAS or 10GB FCoE are the transmission medium for connecting the storage to the host
15k is the rpm speed of the Harddisk
IOPS is Input Output per second.
Re: Storage IOPS and transport speed [message #544209 is a reply to message #544201] Mon, 20 February 2012 11:54 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
A good DBA should be aware about the hardware on which he runs the database like Storage,RAID,transport medium etc.


So I am a bad DBA since more than 20 years.

Regards
Michel
Previous Topic: Reorg the tables and Indexes
Next Topic: some sys view can not found
Goto Forum:
  


Current Time: Thu Mar 28 12:57:46 CDT 2024