January 25, 2009 at 4:33 am
Hi, I have no idea about SQL Server 2005 EE clustering and want to get depth knowledge, hardware, software knowlege that is required to enable and maintain clustering. I would appreciate if someone expert with handson experience may suggest some articles, good links for study and help me.
Shamshad Ali.
January 25, 2009 at 10:16 am
I'd start with Books Online and get the basics from there. They have a good overview.
We have a lot of articles here: http://www.sqlservercentral.com/Articles/clustering, and there are some good videos here as well: http://www.jumpstarttv.com/Search.aspx?terms=clustering
January 25, 2009 at 10:39 am
cluttering is another branche 😉
Steve showed you some good refs for SQLServer clustering.
Another good ref is the SQL Server 2005 Failover Clustering White Paper http://www.microsoft.com/downloads/details.aspx?familyid=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en
It always pays of to have knowledge on how windows clustering works and is operated.
www.microsoft.com/windowsserver2003/enterprise/clustering.mspx
WP: Server Clusters: Cluster Configuration Best Practices for Windows Server 2003 http://www.microsoft.com/downloads/details.aspx?familyid=98BC4061-31A1-42FB-9730-4FAB59CF3BF5&displaylang=en
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 26, 2009 at 9:07 am
One more basic quetion. Can we implement clustering on VM environment?
we have VMware VI 3.5 OS over which we have windows server 2003 EE R2 installed.
Shamshad Ali.
January 27, 2009 at 12:05 am
I think you can, but you'll have to check your vm docs.
(We don't have vmware)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 27, 2009 at 12:19 am
Hi,
Yes you can implement clustering in virtual environment. But its not recommended for production environment. I recommend using Microsoft Virtual Server 2005 for implementing clustering. I implemented clustering on my personal pc (P IV with 3 GHz and 2 GB RAM). You can mail me at n.chandramohan@yahoo.com if you need any help on implementing clustering in your personal pc.
But you need to have a lot of patience as it takes a lot of time to implement on a pc instead of a server.
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
January 27, 2009 at 6:12 am
Thank you all for your replies, we have few testing servers over VM and we would like to have pilot testing (pre-prod) before going live, and need to differentiate performance and reliablitity. If this gives sufficient gain and beneficial then we may consider to move production. We are not going to implement clustering on local PCs. So please let me know if VM should be considered for production or not?
Either Microsoft or VMWare. if yes then which one to ?
Shamshad Ali.
January 28, 2009 at 9:21 am
Awaiting for response...
Shamshad Ali
January 29, 2009 at 6:37 am
You can use VMs for production machines but it needs to be configured well to give good performance and it is not good for production clusters. You can use VM in a test environment to try out clustering but it is not a good option for production. Clustering provides resilience primarily against hardware failures and therefore uses two or more separate machines with SQL Server moving between them automatically. VM machines in a cluster would run on the same underlying hardware so would not provide the same level of resilience.
February 2, 2009 at 1:49 pm
what version\edition of VMWare are we talking?
if its VMWare server forget it for a production system. The point of clustering is to remove the hardware failure factor (not load balancing). If both cluster nodes are on the same host and the host dies!!!!!! Ok for testing but nothing else.
check this link too
http://www.sqlservercentral.com/Forums/Topic647542-146-1.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply