RE: Clustering Service not starting right away on One Node

From: Thomas (Thomas_at_discussions.microsoft.com)
Date: 01/25/05


Date: Tue, 25 Jan 2005 08:27:03 -0800

We haven't installed SQL server yet. I should've posted that first. But I
know from passed installs that SQL does take some time to come online. The
SAN doesn't have much activity on it right now

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
> If you do a fail-over using cluster admin, are there any resources (that SQL
> server depends on) take a long to come online?
> I have seen similar issues when the devices take long to come online due to
> high SAN activity.
>
> Does the SQL Server resource come online, but take a long time until it has
> done it's recovery steps?
> This can occur when the other node was de-porting it's devices and still had
> IO pending. This results in not all pages being fluished to SAN, so SQL
> Server has to do more recovery on the database start-up.
>
> The best guage of how quickly a resource comes online is to look at cluster
> admin during the failover.
>
> Regards
> Mike
> Regards
> Mike
>
> "Thomas" wrote:
>
> > I just set up a cluster attached to a SAN. I have had it where the cluster
> > service on one of the nodes doesn't start up right away. I have checked the
> > services to make sure that it is set to automatic which it is. Both nodes
> > are current with the latest patches and security updates. I'm a little
> > clueless as to why this is happening. Here is the real weird part after 1
> > minute the cluster service starts on the node that is giving me troubles.
> > The other node is perfectly fine.



Relevant Pages

  • Re: Create SQL cluster on 2003
    ... Since you are in a cluster configuration, ... Microsoft SQL Server MVP ... We only about about 20 databases - all ... Move Databases Between Computers That Are Running SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: A complicate cluster configuration...
    ... The SQL Server 2000 EE will be running just in one node, ... It is possible that an operator can manage the cluster from a terminal ... > and SFTPs them to a remote machine. ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... the first instance on the cluster. ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)