Re: Is Alive = Failing over
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Fri, 7 Jul 2006 10:19:50 -0700
If your server is so stressed that LooksAlive/IsAlive fails, then you have
more severe issues that 'should' be addressed.
Is the server CPU bound? Memory Bound?
Something needs attention -and it most likely is NOT the polling intervals.
--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"Tim" <tim@xxxxxxxxxx> wrote in message
news:lFvrg.199$Js2.156@xxxxxxxxxxxxxxxxxxx
This is what is happening:
Cluster service is running "Is Alive" check every 1 minute on SQL server
I validate this by profiling the SQL server and see that "select
@@servername" command being executed by cluster service every minute
There are times when the server is stressed, thus connections I believe
are gettiing refused/delayed, some are these connections might be the "Is
Alive" check.
Thus, the cluster service thinks there is something wrong with SQL and
either restarts or failovers SQL
Is there a threshold setting that can be set like, after 10 "Is Alive"
failed checks within 1 hour then failover or restart? Or what other
options do I have. We are in the process the trying to performance tune
the server but this might takes weeks to complete. In the mean time this
effects our production cluster.
.
- References:
- Is Alive = Failing over
- From: Tim
- Is Alive = Failing over
- Prev by Date: Re: HOW TO CONFIGURE WIN2003 & SQL2K IN ACTIVE/ACTIVE
- Next by Date: Re: SQL clustering problem
- Previous by thread: Re: Is Alive = Failing over
- Index(es):
Relevant Pages
|
Loading
