Is Alive = Failing over

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.


.

Relevant Pages

  • RE: Starting SQL Server Resource Group failed
    ... like your not using the same account for clustering services on both nodes. ... IP and server name. ... But I didn´t remove the local Administrators group from the SQL Server. ... is what the cluster service account uses to logon and ensure that SQL is up ...
    (microsoft.public.sqlserver.clustering)
  • Re: Domain or Workgroup?
    ... They HAVE to be domain members. ... The cluster service requires a common ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: Is Alive = Failing over
    ... Is the server CPU bound? ... Cluster service is running "Is Alive" check every 1 minute on SQL server ...
    (microsoft.public.sqlserver.clustering)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
Loading