October 21, 2012 at 11:40 pm
Is their any difference in clustering -- performance, setup admin etc between having a 2 Node Cluster using SQL 2008 Std edition or SQL 2008 Enterprise edition.
I understand Enterprise has a lot of other features that may help with high availability etc but it is a very expensive product that requires a big monetary outlay for a small company.
The company wants high availability so I am seeing if it could be done on the cheaper STD licensing and run the same as Enterprise (2 node limit I know)?
I could be wrong but I think MS have changed the licensing for Enterprise from per processor to x amount for the first n cores in a processor and y amount for any cores over that??
thanks
October 22, 2012 at 12:01 am
uncle_boris (10/21/2012)
Is their any difference in clustering -- performance, setup admin etc between having a 2 Node Cluster using SQL 2008 Std edition or SQL 2008 Enterprise edition.
Not as such, you wont have all the enterprise features, so i suppose you could say mirroring performance could be hit as you're restricted to using full safety.
uncle_boris (10/21/2012)
I understand Enterprise has a lot of other features that may help with high availability etc but it is a very expensive product that requires a big monetary outlay for a small company.The company wants high availability so I am seeing if it could be done on the cheaper STD licensing and run the same as Enterprise (2 node limit I know)?
Should it be on the cheap though??
One option you could explore is a 3rd party cluster software which will enable you to reduce the Windows server licences to Standard edition and will also allow more than 2 nodes in the cluster. Veritas Cluster Server is an extremely good product, you do then of course have the cost of the VCS licences to consider.
uncle_boris (10/21/2012)
I could be wrong but I think MS have changed the licensing for Enterprise from per processor to x amount for the first n cores in a processor and y amount for any cores over that??thanks
The licensing you refer to is for SQL Server 2012, are you using 2008 or 2012?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2012 at 12:28 am
thanks for the reply -- SQL 2008 -- therefore I was incorrect in suggesting the licensing has changed for this edition of SQL
October 22, 2012 at 1:50 am
[Is their any difference in clustering -- performance, setup admin etc between having a 2 Node Cluster using SQL 2008 Std edition or SQL 2008 Enterprise edition.]
Yes."Fast Recovery" in Enterprise Edition.
October 22, 2012 at 3:35 am
uncle_boris (10/22/2012)
thanks for the reply -- SQL 2008 -- therefore I was incorrect in suggesting the licensing has changed for this edition of SQL
Licensing did change at 2008 and 2008 R2 but not for the reason you specified
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply