Home > Archive > MS SQL Server > January 2006 > Process license ?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Process license ?
Alex Anderson

2006-01-31, 11:23 am

Hello Everyone,

Our company is currently under the Enterprise agreement with Microsoft
and I was wondering when it came to clustering, how many processors do we
have to licenses if both boxes has four processors in each box? The way
we're running the cluster is Active/Passive. We are using SQL 2000 Standard
edition along with Enterprise edition of Microsoft Windows 2003 Server. If
someone could give me some insight I would highly appreciate it.

Thank you
Alex Anderson



Hal Berenson

2006-01-31, 11:23 am

SQL Server 2000 Standard Edition doesn't support clustering, so that is your
first problem. Now ignoring that, in an Active/Passive configuration you
need only license the maximum number of processors on any server in that
configuration. In your case that would mean 4. If you had a configuration
where the usually active system had 4 and the usually passive system had 8
then you'd need to license 8.

--
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com



"Alex Anderson" <AAnderson@Murrieta.org> wrote in message
news:usdeZCoJGHA.668@TK2MSFTNGP11.phx.gbl...
> Hello Everyone,
>
> Our company is currently under the Enterprise agreement with Microsoft
> and I was wondering when it came to clustering, how many processors do we
> have to licenses if both boxes has four processors in each box? The way
> we're running the cluster is Active/Passive. We are using SQL 2000
> Standard edition along with Enterprise edition of Microsoft Windows 2003
> Server. If someone could give me some insight I would highly appreciate
> it.
>
> Thank you
> Alex Anderson
>
>
>



David Portas

2006-01-31, 11:23 am

Alex Anderson wrote:

> Hello Everyone,
>
> Our company is currently under the Enterprise agreement with Microsoft
> and I was wondering when it came to clustering, how many processors do we
> have to licenses if both boxes has four processors in each box? The way
> we're running the cluster is Active/Passive. We are using SQL 2000 Standard
> edition along with Enterprise edition of Microsoft Windows 2003 Server. If
> someone could give me some insight I would highly appreciate it.
>
> Thank you
> Alex Anderson


SQL Server 2000 Standard Edition doesn't support failover clustering.
Your options are to upgrade to Enterprise Edition or to SQL Server 2005
Standard Edition, which do both support clustering.

"Under each of these editions, keeping a passive server for failover
purposes does not require a license as long as the passive server has
the same or fewer processors than the active server (under the per
processor scenario)."
http://www.microsoft.com/sql/howtobuy/faq.mspx

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Alex Anderson

2006-01-31, 8:23 pm

Thank you both. Understood!

Alex Anderson

"Alex Anderson" <AAnderson@Murrieta.org> wrote in message
news:usdeZCoJGHA.668@TK2MSFTNGP11.phx.gbl...
> Hello Everyone,
>
> Our company is currently under the Enterprise agreement with Microsoft
> and I was wondering when it came to clustering, how many processors do we
> have to licenses if both boxes has four processors in each box? The way
> we're running the cluster is Active/Passive. We are using SQL 2000
> Standard edition along with Enterprise edition of Microsoft Windows 2003
> Server. If someone could give me some insight I would highly appreciate
> it.
>
> Thank you
> Alex Anderson
>
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com