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"
