 | |
Re: Cluster licensing
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Cluster licensing -
08-27-2008
, 03:16 AM
|
Oh, my understanding was that with active/active that it is load balancing the same database on shared storage and if one fails the other just keeps on trucking. That can't be done? |
cluster model, and therefore the SQL instance can only be online on 1 node
at the time. No loadbalancing
cross-posting to microsoft.public.sqlserver.clustering to get some more
responses.
Rgds
Edwin.
Quote:
|
"Tim Walsh" wrote: You'd need a license for each server since you would have 2 instances of SQL running at the same time. Keep in mind when you say Active/Active you are actually saying you have one instance of SQL running with it's databases and resources running on Node A and a second instance of SQL with different databases and resources running on Node B. In the event of a failure, the instance running on the node that failed moves over to the other node and now you have 2 instances of SQL running on the same server. Active/Active doesn't mean you are load balancing your SQL instances across both servers. So Active/Passive you have 1 instance running at a time, you need 1 license, Active/Active you have 2 instances running and therefore you need 2 licenses. If you have a 3rd node running an instance you need a 3rd license. "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:C33484BB-717D-41EC-A647-DC3AAE92FF0A (AT) microsoft (DOT) com... Thank you for your reply. What if I go with active/active clustering? Russ Sparks "Jeff Hughes [MSFT]" wrote: No, since SQL is only active on one node at a time, you only need one license per instance on a cluster. -- Jeff Hughes, MCSE Support Escalation Engineer Microsoft Enterprise Platforms Support (Server Core/Cluster) "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:9A7A7466-2B44-41F1-8305-D29380152C76 (AT) microsoft (DOT) com... This might not be the right place, but, when clustering SQL server 2005, do I need to have an additional SQL 2005 enterprise license for the failover node? |
#2
| |||
| |||
|
|
Oh, my understanding was that with active/active that it is load balancing the same database on shared storage and if one fails the other just keeps on trucking. That can't be done? |
cluster model, and therefore the SQL instance can only be online on 1 node
at the time. No loadbalancing
cross-posting to microsoft.public.sqlserver.clustering to get some more
responses.
Rgds
Edwin.
Quote:
|
"Tim Walsh" wrote: You'd need a license for each server since you would have 2 instances of SQL running at the same time. Keep in mind when you say Active/Active you are actually saying you have one instance of SQL running with it's databases and resources running on Node A and a second instance of SQL with different databases and resources running on Node B. In the event of a failure, the instance running on the node that failed moves over to the other node and now you have 2 instances of SQL running on the same server. Active/Active doesn't mean you are load balancing your SQL instances across both servers. So Active/Passive you have 1 instance running at a time, you need 1 license, Active/Active you have 2 instances running and therefore you need 2 licenses. If you have a 3rd node running an instance you need a 3rd license. "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:C33484BB-717D-41EC-A647-DC3AAE92FF0A (AT) microsoft (DOT) com... Thank you for your reply. What if I go with active/active clustering? Russ Sparks "Jeff Hughes [MSFT]" wrote: No, since SQL is only active on one node at a time, you only need one license per instance on a cluster. -- Jeff Hughes, MCSE Support Escalation Engineer Microsoft Enterprise Platforms Support (Server Core/Cluster) "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:9A7A7466-2B44-41F1-8305-D29380152C76 (AT) microsoft (DOT) com... This might not be the right place, but, when clustering SQL server 2005, do I need to have an additional SQL 2005 enterprise license for the failover node? |
#3
| |||
| |||
|
|
Oh, my understanding was that with active/active that it is load balancing the same database on shared storage and if one fails the other just keeps on trucking. That can't be done? |
cluster model, and therefore the SQL instance can only be online on 1 node
at the time. No loadbalancing
cross-posting to microsoft.public.sqlserver.clustering to get some more
responses.
Rgds
Edwin.
Quote:
|
"Tim Walsh" wrote: You'd need a license for each server since you would have 2 instances of SQL running at the same time. Keep in mind when you say Active/Active you are actually saying you have one instance of SQL running with it's databases and resources running on Node A and a second instance of SQL with different databases and resources running on Node B. In the event of a failure, the instance running on the node that failed moves over to the other node and now you have 2 instances of SQL running on the same server. Active/Active doesn't mean you are load balancing your SQL instances across both servers. So Active/Passive you have 1 instance running at a time, you need 1 license, Active/Active you have 2 instances running and therefore you need 2 licenses. If you have a 3rd node running an instance you need a 3rd license. "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:C33484BB-717D-41EC-A647-DC3AAE92FF0A (AT) microsoft (DOT) com... Thank you for your reply. What if I go with active/active clustering? Russ Sparks "Jeff Hughes [MSFT]" wrote: No, since SQL is only active on one node at a time, you only need one license per instance on a cluster. -- Jeff Hughes, MCSE Support Escalation Engineer Microsoft Enterprise Platforms Support (Server Core/Cluster) "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:9A7A7466-2B44-41F1-8305-D29380152C76 (AT) microsoft (DOT) com... This might not be the right place, but, when clustering SQL server 2005, do I need to have an additional SQL 2005 enterprise license for the failover node? |
#4
| |||
| |||
|
|
Oh, my understanding was that with active/active that it is load balancing the same database on shared storage and if one fails the other just keeps on trucking. That can't be done? |
cluster model, and therefore the SQL instance can only be online on 1 node
at the time. No loadbalancing
cross-posting to microsoft.public.sqlserver.clustering to get some more
responses.
Rgds
Edwin.
Quote:
|
"Tim Walsh" wrote: You'd need a license for each server since you would have 2 instances of SQL running at the same time. Keep in mind when you say Active/Active you are actually saying you have one instance of SQL running with it's databases and resources running on Node A and a second instance of SQL with different databases and resources running on Node B. In the event of a failure, the instance running on the node that failed moves over to the other node and now you have 2 instances of SQL running on the same server. Active/Active doesn't mean you are load balancing your SQL instances across both servers. So Active/Passive you have 1 instance running at a time, you need 1 license, Active/Active you have 2 instances running and therefore you need 2 licenses. If you have a 3rd node running an instance you need a 3rd license. "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:C33484BB-717D-41EC-A647-DC3AAE92FF0A (AT) microsoft (DOT) com... Thank you for your reply. What if I go with active/active clustering? Russ Sparks "Jeff Hughes [MSFT]" wrote: No, since SQL is only active on one node at a time, you only need one license per instance on a cluster. -- Jeff Hughes, MCSE Support Escalation Engineer Microsoft Enterprise Platforms Support (Server Core/Cluster) "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:9A7A7466-2B44-41F1-8305-D29380152C76 (AT) microsoft (DOT) com... This might not be the right place, but, when clustering SQL server 2005, do I need to have an additional SQL 2005 enterprise license for the failover node? |
#5
| |||
| |||
|
|
Oh, my understanding was that with active/active that it is load balancing the same database on shared storage and if one fails the other just keeps on trucking. That can't be done? |
cluster model, and therefore the SQL instance can only be online on 1 node
at the time. No loadbalancing
cross-posting to microsoft.public.sqlserver.clustering to get some more
responses.
Rgds
Edwin.
Quote:
|
"Tim Walsh" wrote: You'd need a license for each server since you would have 2 instances of SQL running at the same time. Keep in mind when you say Active/Active you are actually saying you have one instance of SQL running with it's databases and resources running on Node A and a second instance of SQL with different databases and resources running on Node B. In the event of a failure, the instance running on the node that failed moves over to the other node and now you have 2 instances of SQL running on the same server. Active/Active doesn't mean you are load balancing your SQL instances across both servers. So Active/Passive you have 1 instance running at a time, you need 1 license, Active/Active you have 2 instances running and therefore you need 2 licenses. If you have a 3rd node running an instance you need a 3rd license. "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:C33484BB-717D-41EC-A647-DC3AAE92FF0A (AT) microsoft (DOT) com... Thank you for your reply. What if I go with active/active clustering? Russ Sparks "Jeff Hughes [MSFT]" wrote: No, since SQL is only active on one node at a time, you only need one license per instance on a cluster. -- Jeff Hughes, MCSE Support Escalation Engineer Microsoft Enterprise Platforms Support (Server Core/Cluster) "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:9A7A7466-2B44-41F1-8305-D29380152C76 (AT) microsoft (DOT) com... This might not be the right place, but, when clustering SQL server 2005, do I need to have an additional SQL 2005 enterprise license for the failover node? |
#6
| |||
| |||
|
|
Oh, my understanding was that with active/active that it is load balancing the same database on shared storage and if one fails the other just keeps on trucking. That can't be done? |
cluster model, and therefore the SQL instance can only be online on 1 node
at the time. No loadbalancing
cross-posting to microsoft.public.sqlserver.clustering to get some more
responses.
Rgds
Edwin.
Quote:
|
"Tim Walsh" wrote: You'd need a license for each server since you would have 2 instances of SQL running at the same time. Keep in mind when you say Active/Active you are actually saying you have one instance of SQL running with it's databases and resources running on Node A and a second instance of SQL with different databases and resources running on Node B. In the event of a failure, the instance running on the node that failed moves over to the other node and now you have 2 instances of SQL running on the same server. Active/Active doesn't mean you are load balancing your SQL instances across both servers. So Active/Passive you have 1 instance running at a time, you need 1 license, Active/Active you have 2 instances running and therefore you need 2 licenses. If you have a 3rd node running an instance you need a 3rd license. "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:C33484BB-717D-41EC-A647-DC3AAE92FF0A (AT) microsoft (DOT) com... Thank you for your reply. What if I go with active/active clustering? Russ Sparks "Jeff Hughes [MSFT]" wrote: No, since SQL is only active on one node at a time, you only need one license per instance on a cluster. -- Jeff Hughes, MCSE Support Escalation Engineer Microsoft Enterprise Platforms Support (Server Core/Cluster) "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:9A7A7466-2B44-41F1-8305-D29380152C76 (AT) microsoft (DOT) com... This might not be the right place, but, when clustering SQL server 2005, do I need to have an additional SQL 2005 enterprise license for the failover node? |
#7
| |||
| |||
|
|
Oh, my understanding was that with active/active that it is load balancing the same database on shared storage and if one fails the other just keeps on trucking. That can't be done? |
cluster model, and therefore the SQL instance can only be online on 1 node
at the time. No loadbalancing
cross-posting to microsoft.public.sqlserver.clustering to get some more
responses.
Rgds
Edwin.
Quote:
|
"Tim Walsh" wrote: You'd need a license for each server since you would have 2 instances of SQL running at the same time. Keep in mind when you say Active/Active you are actually saying you have one instance of SQL running with it's databases and resources running on Node A and a second instance of SQL with different databases and resources running on Node B. In the event of a failure, the instance running on the node that failed moves over to the other node and now you have 2 instances of SQL running on the same server. Active/Active doesn't mean you are load balancing your SQL instances across both servers. So Active/Passive you have 1 instance running at a time, you need 1 license, Active/Active you have 2 instances running and therefore you need 2 licenses. If you have a 3rd node running an instance you need a 3rd license. "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:C33484BB-717D-41EC-A647-DC3AAE92FF0A (AT) microsoft (DOT) com... Thank you for your reply. What if I go with active/active clustering? Russ Sparks "Jeff Hughes [MSFT]" wrote: No, since SQL is only active on one node at a time, you only need one license per instance on a cluster. -- Jeff Hughes, MCSE Support Escalation Engineer Microsoft Enterprise Platforms Support (Server Core/Cluster) "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:9A7A7466-2B44-41F1-8305-D29380152C76 (AT) microsoft (DOT) com... This might not be the right place, but, when clustering SQL server 2005, do I need to have an additional SQL 2005 enterprise license for the failover node? |
#8
| |||
| |||
|
|
Oh, my understanding was that with active/active that it is load balancing the same database on shared storage and if one fails the other just keeps on trucking. That can't be done? |
cluster model, and therefore the SQL instance can only be online on 1 node
at the time. No loadbalancing
cross-posting to microsoft.public.sqlserver.clustering to get some more
responses.
Rgds
Edwin.
Quote:
|
"Tim Walsh" wrote: You'd need a license for each server since you would have 2 instances of SQL running at the same time. Keep in mind when you say Active/Active you are actually saying you have one instance of SQL running with it's databases and resources running on Node A and a second instance of SQL with different databases and resources running on Node B. In the event of a failure, the instance running on the node that failed moves over to the other node and now you have 2 instances of SQL running on the same server. Active/Active doesn't mean you are load balancing your SQL instances across both servers. So Active/Passive you have 1 instance running at a time, you need 1 license, Active/Active you have 2 instances running and therefore you need 2 licenses. If you have a 3rd node running an instance you need a 3rd license. "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:C33484BB-717D-41EC-A647-DC3AAE92FF0A (AT) microsoft (DOT) com... Thank you for your reply. What if I go with active/active clustering? Russ Sparks "Jeff Hughes [MSFT]" wrote: No, since SQL is only active on one node at a time, you only need one license per instance on a cluster. -- Jeff Hughes, MCSE Support Escalation Engineer Microsoft Enterprise Platforms Support (Server Core/Cluster) "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:9A7A7466-2B44-41F1-8305-D29380152C76 (AT) microsoft (DOT) com... This might not be the right place, but, when clustering SQL server 2005, do I need to have an additional SQL 2005 enterprise license for the failover node? |
#9
| |||
| |||
|
|
Oh, my understanding was that with active/active that it is load balancing the same database on shared storage and if one fails the other just keeps on trucking. That can't be done? |
cluster model, and therefore the SQL instance can only be online on 1 node
at the time. No loadbalancing
cross-posting to microsoft.public.sqlserver.clustering to get some more
responses.
Rgds
Edwin.
Quote:
|
"Tim Walsh" wrote: You'd need a license for each server since you would have 2 instances of SQL running at the same time. Keep in mind when you say Active/Active you are actually saying you have one instance of SQL running with it's databases and resources running on Node A and a second instance of SQL with different databases and resources running on Node B. In the event of a failure, the instance running on the node that failed moves over to the other node and now you have 2 instances of SQL running on the same server. Active/Active doesn't mean you are load balancing your SQL instances across both servers. So Active/Passive you have 1 instance running at a time, you need 1 license, Active/Active you have 2 instances running and therefore you need 2 licenses. If you have a 3rd node running an instance you need a 3rd license. "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:C33484BB-717D-41EC-A647-DC3AAE92FF0A (AT) microsoft (DOT) com... Thank you for your reply. What if I go with active/active clustering? Russ Sparks "Jeff Hughes [MSFT]" wrote: No, since SQL is only active on one node at a time, you only need one license per instance on a cluster. -- Jeff Hughes, MCSE Support Escalation Engineer Microsoft Enterprise Platforms Support (Server Core/Cluster) "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:9A7A7466-2B44-41F1-8305-D29380152C76 (AT) microsoft (DOT) com... This might not be the right place, but, when clustering SQL server 2005, do I need to have an additional SQL 2005 enterprise license for the failover node? |
#10
| |||
| |||
|
|
Oh, my understanding was that with active/active that it is load balancing the same database on shared storage and if one fails the other just keeps on trucking. That can't be done? |
cluster model, and therefore the SQL instance can only be online on 1 node
at the time. No loadbalancing
cross-posting to microsoft.public.sqlserver.clustering to get some more
responses.
Rgds
Edwin.
Quote:
|
"Tim Walsh" wrote: You'd need a license for each server since you would have 2 instances of SQL running at the same time. Keep in mind when you say Active/Active you are actually saying you have one instance of SQL running with it's databases and resources running on Node A and a second instance of SQL with different databases and resources running on Node B. In the event of a failure, the instance running on the node that failed moves over to the other node and now you have 2 instances of SQL running on the same server. Active/Active doesn't mean you are load balancing your SQL instances across both servers. So Active/Passive you have 1 instance running at a time, you need 1 license, Active/Active you have 2 instances running and therefore you need 2 licenses. If you have a 3rd node running an instance you need a 3rd license. "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:C33484BB-717D-41EC-A647-DC3AAE92FF0A (AT) microsoft (DOT) com... Thank you for your reply. What if I go with active/active clustering? Russ Sparks "Jeff Hughes [MSFT]" wrote: No, since SQL is only active on one node at a time, you only need one license per instance on a cluster. -- Jeff Hughes, MCSE Support Escalation Engineer Microsoft Enterprise Platforms Support (Server Core/Cluster) "Russ Sparks" <RussSparks (AT) discussions (DOT) microsoft.com> wrote in message news:9A7A7466-2B44-41F1-8305-D29380152C76 (AT) microsoft (DOT) com... This might not be the right place, but, when clustering SQL server 2005, do I need to have an additional SQL 2005 enterprise license for the failover node? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.