Re: Number of IOs Per Second

"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 Tue Aug 10 2004 - 19:55:05 CDT