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"
