Re: Number of IOs Per Second?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 08/11/04 

Date: Wed, 11 Aug 2004 08:20:51 -0400

I also found a more recent article
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/rdbmspft.mspx 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"CHANGE USERNAME TO westes" <DELETE_westes@earthbroadcast.com> wrote in
message news:u0fS9ExfEHA.1656@TK2MSFTNGP10.phx.gbl...
> 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
>
>

Relevant Pages

  • Re: Allowing only certain clients access to SQL Server 2K
    ... I support the Professional Association for SQL Server and its user community ... "Raj Bhaskar" wrote in message ... it said "Must declare variable @spid". ...
    (microsoft.public.sqlserver.security)
  • Re: consolidating two data files into one.
    ... Wayne Snyder, MCDBA, SQL Server MVP ... >> I support the Professional Association of SQL Server and it's ...
    (microsoft.public.sqlserver.server)
  • Re: PEAP with Passwords problem
    ... I support the Professional Association for SQL Server ... > "Geoff N. Hiten" wrote in message ... >> Microsoft SQL Server MVP ... >> I support the Professional Association for SQL Server ...
    (microsoft.public.pocketpc.wireless)
  • Re: question about indexes
    ... Wayne Snyder, MCDBA, SQL Server MVP ... I support the Professional Association of SQL Server and it's ... > somewhere that if a column is used in a clustered index then it shouldn't ...
    (microsoft.public.sqlserver.server)
  • Re: CUBO LOCKED
    ... Wayne Snyder, MCDBA, SQL Server MVP ... I support the Professional Association of SQL Server and it's ... > sessione e non so dove trovare il riferimento all'utente. ...
    (microsoft.public.sqlserver.olap)