April 30, 2009 at 4:03 pm
So a question that probably is quite obvious for those already involved in SQL 2008.
To allow for further growth of standalone SQL 2008 servers running Win2003 OS, does setting them up as a single node cluster, or running them on Datacenter OS make more sense?
These will never be part of a consolidated environment (kind of why i'm leaning away from the DC OS), but setting up a 1 node cluster seems like a bad idea.
Just curious if anyone has had exp with this and some of the pro's and con's of either way.
We're looking at future growth, cost, ease of adding hardware to the environment, setup time, etc....
Thanks,
MMW
April 30, 2009 at 11:22 pm
Hi SQLMonkey,
From a scalability point of view, single node clusters are very helpful. We deploy a number of our SQL systems on single node clusters so that we can scale out later.
If you haven't built your SQL instance in a cluster first up, to convert you need to blow away and start again - messy. Single Node cluster is a small management and resource (IP, etc..) overhead that its negligible.
Adding subsequent nodes is a walk in the park.
A Windows Server Data Center license only makes sense when you are running on really big iron or consolidating. For example, on our virtualisation farm we run Windows Server Data Center licenses with a SQL Enterprise Server license for as many Windows and SQL installations as we require. You really only get the benefit of Data Center with 4 or more Windows installations
--
Andrew Hatfield
May 6, 2009 at 9:18 am
I hadn't heard this before. I'd love to see someone write an article the shares more about this.
It sounds like a good idea, though.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply