Re: Number of IOs Per Second

From: Antoine BRUNEL <antoinebrunel.yahoo.fr_at_nospam.fr>
Date: Wed, 11 Aug 2004 22:15:18 +0200
Message-ID: <411a7e56$0$10051$79c14f64@nan-newsreader-06.noos.net>

Hi from Paris

have a look at STATSPACK package, which will help to size IO need for one user, then you will be able to estimate needs for n users.....

Cdlt

"CHANGE USERNAME TO westes" <DELETE_westes_at_earthbroadcast.com> a écrit dans le message de 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.
>
> If the database is 2 TB in size, what is the desired amount of cache
memory?
>
> --
> Will
> westes AT earthbroadcast.com
>
>
Received on Wed Aug 11 2004 - 15:15:18 CDT