capacity issues

From: Andrey Bronfin <bronfin_at_VisualTop.com>
Date: Thu, 17 Aug 2000 23:40:40 +0200
Message-Id: <10592.114906@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_00A5_01C008A4.8D38E9F0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear list !

I have a very urgent question :
I have a mixed-type application here , it's both OLTP & DataWarehouse . I need to plan the machines for production . I have 3 options :

Create 2 databases - one for OLTP and one for the batch processing = - reports and put them on 2 different machines ( Sun E 220 with 1 CPU = each ) .
Create the same 2 DBs and put them on one Sun E 220 machine with 2 = CPUs .
Create 1 database to host all the tables of both the OLTP & = reports parts of the application .

Would U please give some guideness on the above , some pros & cons for = each approach .
Basically there are 2 decisions to take :=20 is it better to have one mixed database or 2 different DBs=20 and=20
in case U have 2 DBs , is better to put them on one machine or on 2 = different machines .

Thank U VERY much in advance .
Every tip is VERY appreciated .

Andrey Bronfin
VisualTop.com
+972-3-5275757.

------=_NextPart_000_00A5_01C008A4.8D38E9F0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#d4d0c8>
<DIV><FONT face=3DArial size=3D2>Dear list !</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I have a very urgent question =
:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have a mixed-type application here , =
it's both=20
OLTP & DataWarehouse .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I need to plan the machines for =
production=20
.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have 3 options :</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>   a) Create 2 databases - =
one for OLTP=20
and one for the batch processing - reports and put them on 2 = different=20
machines ( Sun E 220 with 1 CPU each ) .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>   b) Create the same 2 DBs =
and put them=20
on one Sun E 220 machine with 2 CPUs .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>   c) Create 1 database =
to host all=20
the tables of both the OLTP & reports parts of the application=20 .</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Would U please give some guideness on =
the above ,=20
some pros & cons for each approach .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Basically there are 2 decisions to take =
:=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>  is it better to have one mixed =
database or 2=20
different DBs </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>  in case U have 2 DBs , is better =
to put them=20
on one machine or on 2 different machines .</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thank U VERY much in advance =
.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Every tip is VERY appreciated =
.</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><BR>Andrey=20
Bronfin<BR>VisualTop.com<BR>+972-3-5275757.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><BR></FONT> </DIV></BODY></HTML>
Received on Thu Aug 17 2000 - 16:40:40 CDT