dbTalk Databases Forums  

How to test/verify cluster functionality

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss How to test/verify cluster functionality in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DetRich
 
Posts: n/a

Default How to test/verify cluster functionality - 04-17-2009 , 09:56 AM






Hello,

I am still pretty new to clustering. I will be creating clusters on SQL2005
with BizTalk 2006 R2 as follows:

1. SQLCluster
2. MSDTCCluster
3. ENTSSOCluster
4. SSASCluster
5. SQLNodeA
6. SQLNodeB

Can anyone tell me how to test / verify cluster functionality or point me to
a resource that explains it?

TIA,
Rich


Reply With Quote
  #2  
Old   
bass_player
 
Posts: n/a

Default Re: How to test/verify cluster functionality - 04-21-2009 , 05:46 PM






I usually start with the OS-level cluster and see if it works. A simple
continuous ping test on the virtual IP/hostname of the cluster should do the
trick
PING virtualIP -t

Then, I'd reboot the active node and see if it fails over to the passive
node. If it does, you can then run a simple connectivity test to SQL Server
using either Management Studio or sqlcmd and connect to the SQL Server
virtual instance name

"DetRich" <DetRich (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello,

I am still pretty new to clustering. I will be creating clusters on
SQL2005
with BizTalk 2006 R2 as follows:

1. SQLCluster
2. MSDTCCluster
3. ENTSSOCluster
4. SSASCluster
5. SQLNodeA
6. SQLNodeB

Can anyone tell me how to test / verify cluster functionality or point me
to
a resource that explains it?

TIA,
Rich




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.