Chris
Oh I don't know, It really depends on what the 50 users are doing?
Mind you when was the last time you heard someone complain "The systems
running really fast today"
Hardware is cheap, customer satisfaction priceless
Neven
----- Original Message -----
From: Chris Reynolds <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Wednesday, 4 April 2001 17:43
Subject: RE: [DUG]: SQL2K Hardware Requirements.......
> of course, it's all slightly over engineered for 50 users.
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Neven MacEwan
> Sent: Wednesday, April 04, 2001 10:03 AM
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: SQL2K Hardware Requirements.......
>
>
> Chris
>
> Thats why I suggested leaping straight to Raid-10
> (I should have also insisted on a Hardware Raid Controller)
> Striping gives max IO, Duplexing Redundancy, The Ideal would be Raid 10
for
> Data, Raid 1
> for the transction Log, Striping over 3 drives gives you 8 drives in total
> and with 9Gb drives
> 27Gb Data, 9Gb Transaction Log
>
> Neven
>
> ----- Original Message -----
> From: Chris Reynolds <[EMAIL PROTECTED]>
> To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> Sent: Tuesday, 3 April 2001 20:07
> Subject: RE: [DUG]: SQL2K Hardware Requirements.......
>
>
> > Off topic but...
> > Put your transaction log on a separate independant spindle. if you raid
it
> > with the data, you will dramatically reduce your write speed.
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> > Behalf Of Neven MacEwan
> > Sent: Monday, April 02, 2001 11:03 PM
> > To: Multiple recipients of list delphi
> > Subject: Re: [DUG]: SQL2K Hardware Requirements.......
> >
> >
> > Donovan
> >
> > Lots of RAM! Several CPU's, only constructive advice I can give you is
to
> > suggest that you go staight to
> > duplexed drives, Raid 10 (over the usual Raid 5) with the current prices
> of
> > drives and the disk IO demands of
> > all SQL servers this would probably work the best
> >
> > Unless you want real performance then I'd suggest PostgreSQL on Linux
> >
> > HTH
> > Neven
> >
> > ----- Original Message -----
> > From: "Donovan J. Edye" <[EMAIL PROTECTED]>
> > To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
> > Sent: Monday, April 02, 2001 2:49 PM
> > Subject: [DUG]: SQL2K Hardware Requirements.......
> >
> >
> > > G'Day,
> > >
> > > I am looking for some opinions and suggestions of a hardware spec for
a
> > > MS-SQL2000 box that has to do support 3 databases with the following
> > > requirements. The users using each database are distinct so to get
total
> > > load you would add all of them together. Due to factors outside of my
> > > control all databases need to be run off the same machine.
> > >
> > > Database 1
> > >
> > > - 3 - 4 Concurrent Users
> > > - +/- 15 tables. Aside from lookup tables there are two "major" tables
> of
> > > ~5000, ~1500 records respectively
> > > - Main use is reporting queries of data contained in the database
> > > - No growth as the tables get populated with a new snapshot that
> replaces
> > > existing data
> > >
> > > Database 2
> > >
> > > - 40 - 50 Concurrent Users
> > > - +/- 10 tables. Has 2 major tables with ~100,000, ~80,000 records
> > > respectively and growing
> > > - Used in a _real time_ TV Production Environment. Access time here is
> > > crucial and has to be as quick as possible
> > > - Growth is expected to be roughly 1000 records to each of the major
> > tables
> > > a week
> > >
> > > Database 3
> > >
> > > - 10-20 Concurrent Users
> > > - +/- 50 tables. Has 10 major tables. The two tables that would bear
the
> > > brunt of it are 200,000, 180,000 records each
> > > - English Query, with "heavy" reporting queries to be run via English
> > Query
> > > and through "ordinary" SQL
> > > - Transactional Replication of all DB changes to 2 remote SQL 2K boxes
> > > - Growth is expected to be about 1000 records a day
> > >
> > > I realise that the above is rather vague, but I would still appreciate
> any
> > > comments, suggestions or factors to consider etc.
> > >
> > > TIA
> > >
> > > -- Donovan
> > > ----------------------------------------------------------------------
> > > Donovan J. Edye [www.edye.wattle.id.au]
> > > Namadgi Systems [www.namsys.com.au]
> > > Voice: +61 2 6285-3460
> > > Fax: +61 2 6285-3459
> > > TVisualBasic = Class(None);
> > > Heard just before the 'Big Bang': "...Uh Oh...."
> > > ----------------------------------------------------------------------
> > > GXExplorer [http://www.gxexplorer.org] Freeware Windows Explorer
> > > replacement. Also includes freeware delphi windows explorer
components.
> > > ----------------------------------------------------------------------
> > >
> > >
> >
>
> --------------------------------------------------------------------------
> > -
> > > New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
> > > Website: http://www.delphi.org.nz
> > > To UnSub, send email to: [EMAIL PROTECTED]
> > > with body of "unsubscribe delphi"
> > >
> >
>
> --------------------------------------------------------------------------
> -
> > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> > To UnSub, send email to: [EMAIL PROTECTED]
> > with body of "unsubscribe delphi"
> >
>
> --------------------------------------------------------------------------
> -
> > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> > To UnSub, send email to: [EMAIL PROTECTED]
> > with body of "unsubscribe delphi"
> >
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
