Number of Processor Licenses in cluster with multiple passive node

#31

Well you will need OS license still I belive; I am just speaking from SQL
Server point. Long as other servers are passive you will not need to take
into account the Maxmim number of CPUs that anyone server has and buy those
licenses.

Example: 3-Node cluster
Node 1: 2 CPU Active
Node 2: 2 CPU Passive
Node 3: 3 CPU Passive

You will need 3 CPU License, 2 to cover the Node1/2 and +1 more to cover
Node3.

SQL Server comes with 3 License Models:

Type 1. Process License
Type 2. Server-User CAL License (If you can't control the devices conecting
to SQL Server like web application)
Type 3. Server-Device CAL License (If you can't control the users, like in a
organization where many users use same computer).

In a Clustering Active/Passive configuration you cannot use passive nodes to
do anything against SQL Server. SQL Server works in no-share model, i.e.
when active server owns the resources to the SQL Server NO other node can
access these resources without taking over the ownership. Once the node
takes ownership it will become the primary then.

This is my two cents ;-), just as I understand it. One of the MVPs here
probably will have better grasp of this then me

.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

"Donald" wrote:

Quote:

Thank you for your answer Mr. Gupta.

I understand your answer like this.

"It dosen't matter how many passive servers are, only if they are NOT used.
I can prepare as many passive servers as I want whitout processor license."

And then what kind of license type do I need when in passive server I do
some queries for internal use(like statistic or lookup some data)?

I Know there are two type of lic. for SQL server.

Type 1. Processor License
Type 2. Server-CAL License

Because an active server related to that passive server has PL(for external
service),
dose the passive server also need to have PL even though it is used for
internal use only?

License Policy is too vague for some specifice case. :{

Thanks.

What if I use the passive server for batch job and internal use only, do I
need

"Mohit K. Gupta" wrote:

I belive you don't need additional licenses.

The statement there implying that take all the nodes in the cluster and the
maximum number of processes that is the number of PL you need. Only reason
you will need to buy more PL is if you decide to set up another instance on
the 3-node cluster.

In the ref document it lays it that sentence out a bit more clearly "A
passive server does not need a license if the number of processors in the
passive server is equal to or less than the number of processors in the
active server. The passive server can take the duties of the active server
for 30 days. Afterwards, it must be licensed accordingly.".

I think explains it best , "The passive server does not require a license
because no queries are being executed against it."

. Thanks.

Ref Doc:
http://www.microsoft.com/sqlserver/2...derations.aspx
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

"Donald" wrote:

Hello.
I have some questions...I'm looking for the right answer.
Here it is.
If a cluster has three nodes with 4 processors in each, what is the number
of the processor license do I need? Among three nodes in a cluster, only 1
node can run actively, and two or more cannot run activly at a same time.

From the MS's license doc., they say
"...
A passive server does not need a license if the number of processors in the
passive server is equal to or less than the number of processors in the
active server.
...".
So, do I have to purchase the redundant passive node's 4 processors' license?

In other words,
alreay I have 4 PLs for active node, but because the number of two passive
nodes' total processors is 8, so I need more 4 PLs ( 8 PL passvie - 4 PL
active = 4 PL more)? Is this true?

I'm so confused. Need your right answer.
Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Number of Processor Licenses in cluster with multiple passive node

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

RE: Number of Processor Licenses in cluster with multiple passive - 11-27-2008 , 01:16 AM