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" 😉