SCSI
15K rpm
fiber attached, direct or SAN attached
RAID 0+1
Cache on the computer
How do any of these questions matter relative to understanding the I/O
requirements of the application? All of your questions pertain to
understanding the I/O performance of specific solutions, but I wasn't going
that far in my question. If an application needs 3000 physical I/Os per
second, it needs it whether or not you supply enough physical disks, of high
enough speed, to satisfy the requirement.
--
Will
westes AT earthbroadcast.com
"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
news:Xns9541B6460D9FFSunnySD_at_68.6.19.6...
> "CHANGE USERNAME TO westes" <DELETE_westes_at_earthbroadcast.com> wrote in
> news:Y7WdnTigdqiru4TcRVn-pg_at_giganews.com:
>
> > I need to size a storage system. I know that I will have two tables,
> > each with eight million records. I will have 10 users, each of whom
> > will be doing complex reports simultaneously, each of which does joins
> > against those eight million record tables.
> >
> > What are some guidelines for best and and worst case, about the number
> > of IOs per second that this system will generate? I need to make
> > sure my RAID arrays have enough physical disks to satisfy this number
> > of IOs.
> >
>
> It depends.
>
> What flavor of disks; IDE, SATA, SCSI, iSCSI?
>
> What the speed of the disks; 7200, 10000, 12000, 15000?
>
> How are the disks "attached" to the CPU; fiber, direct, NAS, SAN?
>
> What type of RAID; 0, 1, 4, 5, 10, 0+1?
>
>
> > If the database is 2 TB in size, what is the desired amount of cache
> > memory?
> >
>
> Cache where; on the disk, on the controller, in the CPU?
>
> more
Received on Wed Aug 11 2004 - 11:36:35 CDT
