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"
