Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Clustering on SQL Standard Edition vs Enterprise Edition Expand / Collapse
Author
Message
Posted Sunday, October 21, 2012 11:40 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:27 PM
Points: 77, Visits: 306
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
Post #1375251
Posted Monday, October 22, 2012 12:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 6,162, Visits: 13,305
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"
Post #1375256
Posted Monday, October 22, 2012 12:28 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:27 PM
Points: 77, Visits: 306
thanks for the reply -- SQL 2008 -- therefore I was incorrect in suggesting the licensing has changed for this edition of SQL
Post #1375263
Posted Monday, October 22, 2012 1:50 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
[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.
Post #1375292
Posted Monday, October 22, 2012 3:35 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 6,162, Visits: 13,305
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"
Post #1375314
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse