> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--MS_Mac_OE_3055254045_902990_MIME_Part
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
Just to add too the saga....a note on clustering and licensing of SQL 7
If you are using SQL Enterprise and MS Cluster server there are two ways in
which you can install SQL 7
Active/Passive
Active/Passive is some what for giving with its licensing requirements. You
only need to buy licences per processor and for the ONE machine that is
currently active in the cluster (assuming that all your servers in the
cluster have the same amount of processors). Active/Passive failover is
slower than Active/Active, as the name suggests all other SQL services in
the cluster are passive until invoked and control passes to another server
(only one active server at anytime).
Active/Active
Any SQL Server in the cluster can service requests at anyone time, so a
licence must be purchased for EVERY processor in the cluster. Yep,
expensive!
I have run Active/Passive SQL cluster, the failover time depends on your
hardware, but be prepared for anything from 30-60sec whilst services are
started and control is passed.
BTW, how to install SQL 7 on MS Cluster:
http://support.microsoft.com/support/SQL/Content/70Papers/70clstr.asp?LN=EN-
US&SD=gn&FR=0
m
--
Malcolm Barclay
Rocket Company
From: "Cameron Childress" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Mon, 23 Oct 2000 10:10:33 -0400
To: Fusebox <[EMAIL PROTECTED]>
Subject: RE: Want to be robbed blind by M$ ???
> Alan how many people are you going to have connecting to the SQL db
> directly (not through the web) I suspect that this number is relatively
> small. In that case you don't need the 28K unlimited license you
> just need a internet connecter license per processor at like 2k per
> and enough CAL license as people that need direct SQL access. So you
> are under 10k for you license.
This is actually not true "If the Users are exclusively company employees,
vendors and partners". If you are serving data to the internet public at
large, you can get away with an internet connector license. If your users
can be defined and counted, such as the list in the quote above, you have to
buy a CAL for each one.
It gets worse though... Say your users *were* all anonymous web users and
you are using an internet connector lic. Say you'd like a nice failover
solution on dual processor machines and plan on using MS SQL2K Ent Edition
(which you must use for failover). You know how much you are going to have
to pay? Try $80K! Yes... With MS SQL2K, it's $20K per processor for the
Enterprise Edition. This same setup in MS SQL7 Ent w/Internet Connectors
was around $23K.
Nice price change. Why still use MS SQL? I don't see a good reason
anymore, except that for existing apps the cost of re-writing stored procs
and other potentially SQL specific application layers could actually cost
more than that.
-Cameron
--------------------
Cameron Childress
ElliptIQ Inc.
p.770.460.7277.232
f.770.460.0963
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--MS_Mac_OE_3055254045_902990_MIME_Part
Content-type: text/html; charset="US-ASCII"
Content-transfer-encoding: quoted-printable
<HTML>
<HEAD>
<TITLE>Re: Want to be robbed blind by M$ ???</TITLE>
</HEAD>
<BODY>
Just to add too the saga....a note on clustering and licensing of SQL 7<BR>
<BR>
If you are using SQL Enterprise and MS Cluster server there are two ways in=
which you can install SQL 7<BR>
<BR>
Active/Passive<BR>
<BR>
Active/Passive is some what for giving with its licensing requirements. You=
only need to buy licences per processor and for the ONE machine that is cur=
rently active in the cluster (assuming that all your servers in the cluster =
have the same amount of processors). Active/Passive failover is slower than =
Active/Active, as the name suggests all other SQL services in the cluster ar=
e passive until invoked and control passes to another server (only one activ=
e server at anytime).<BR>
<BR>
<BR>
Active/Active<BR>
Any SQL Server in the cluster can service requests at anyone time, so a lic=
ence must be purchased for EVERY processor in the cluster. Yep, expensive!<B=
R>
<BR>
I have run Active/Passive SQL cluster, the failover time depends on your ha=
rdware, but be prepared for anything from 30-60sec whilst services are start=
ed and control is passed.<BR>
<BR>
BTW, how to install SQL 7 on MS Cluster:<BR>
http://support.microsoft.com/support/SQL/Content/70Papers/70clstr.asp?LN=3DEN=
-US&SD=3Dgn&FR=3D0<BR>
<BR>
m<BR>
<BR>
-- <BR>
Malcolm Barclay<BR>
Rocket Company<BR>
<BR>
<BLOCKQUOTE><BR>
<B>From: </B>"Cameron Childress" <[EMAIL PROTECTED]><=
BR>
<B>Reply-To: </B>[EMAIL PROTECTED]<BR>
<B>Date: </B>Mon, 23 Oct 2000 10:10:33 -0400<BR>
<B>To: </B>Fusebox <[EMAIL PROTECTED]><BR>
<B>Subject: </B>RE: Want to be robbed blind by M$ ???<BR>
<BR>
</BLOCKQUOTE><BR>
<BLOCKQUOTE><TT>> Alan how many people are you going to have=
connecting to the SQL db<BR>
> directly (not through the web) I suspect that this number is rel=
atively<BR>
> small. In that case you don't need the 28K unlimited license you=
<BR>
> just need a internet connecter license per processor at like 2k per<BR=
>
> and enough CAL license as people that need direct SQL access. So=
you<BR>
> are under 10k for you license.<BR>
<BR>
This is actually not true "If the Users are exclusively company employ=
ees,<BR>
vendors and partners". If you are serving data to the internet p=
ublic at<BR>
large, you can get away with an internet connector license. If your u=
sers<BR>
can be defined and counted, such as the list in the quote above, you have t=
o<BR>
buy a CAL for each one.<BR>
<BR>
It gets worse though... Say your users *were* all anonymous web users=
and<BR>
you are using an internet connector lic. Say you'd like a nice failov=
er<BR>
solution on dual processor machines and plan on using MS SQL2K Ent Edition<=
BR>
(which you must use for failover). You know how much you are going to=
have<BR>
to pay? Try $80K! Yes... With MS SQL2K, it's $20K per pro=
cessor for the<BR>
Enterprise Edition. This same setup in MS SQL7 Ent w/Internet Connect=
ors<BR>
was around $23K.<BR>
<BR>
Nice price change. Why still use MS SQL? I don't see a good rea=
son<BR>
anymore, except that for existing apps the cost of re-writing stored procs<=
BR>
and other potentially SQL specific application layers could actually cost<B=
R>
more than that.<BR>
<BR>
-Cameron<BR>
<BR>
--------------------<BR>
Cameron Childress<BR>
ElliptIQ Inc.<BR>
p.770.460.7277.232<BR>
f.770.460.0963<BR>
<BR>
---------------------------------------------------------------------------=
---<BR>
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&a=
mp;body=3Dlists/fusebox or send a message to [EMAIL PROTECTED]=
with 'unsubscribe' in the body.<BR>
</TT></BLOCKQUOTE><TT><BR>
</TT>
</BODY>
</HTML>
--MS_Mac_OE_3055254045_902990_MIME_Part--
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
