To test the failover - the easiest thing to do once you have it all set
up is to turn off the active node and try connecting to the databases
that reside on the cluster...if you can connect that's about it.
Performance tuning and monitoring is the same on a cluster as it is on a
stand alone box...same rules apply.

Matt
>>> "Rajendra Mohanty "
<mssqldba-ezmlmshield-x88550050.[Email address protected] 9/28/2007 9:15
AM >>>

Dear Expert,

I am very new to SQL Server Cluster, I have installed clustered with
Active/Pasive mode.

Requesting you all please help me with some stpes to test cluster
fail-over
and also some sort of performance tips.

Thanks in advance,
-Raj


-----Original Message-----
From: Matt Bingham
[mailto:mssqldba-ezmlmshield-x1973543.[Email address protected]
Sent: Friday, September 28, 2007 7:28 PM
To: LazyDBA Discussion
Subject: Re: Is SAN mandatory for clustering?

Well - some sort of shared storage is mandatory. You need both nodes
to
share the disks and they both need to look at the same quorum drive.

>>> "Pardeep_Dhull "
<mssqldba-ezmlmshield-x43543119.[Email address protected] 9/28/2007
8:51 AM
>>> Adding SAN will help a great way but is it mandatory in clustering
environment?

Thanks and regards,

Pardeep dhull
Sql dba
Hcu Eabis (eso)
Satyam cyber space satyam computers services
ltd.
hyderabad.




DISCLAIMER:
This email (including any attachments) is intended for the sole use of
the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or
distribution or forwarding of any or all of the contents in this
message is
STRICTLY PROHIBITED. If you are not the intended recipient, please
contact
the sender by email and delete all copies; your cooperation in this
regard
is appreciated.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
a dba
job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
a dba
job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page