Clustering on SQL Standard Edition vs Enterprise Edition
-
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
-
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"
-
thanks for the reply -- SQL 2008 -- therefore I was incorrect in suggesting the licensing has changed for this edition of SQL
-
[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.
-
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 SQLLicensing 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