Re: Does rolling a cluster create down time?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rodney R. Fournier [MVP] (rod_at_die.spam.die.nw-america.com)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 09:36:52 -0500

On the roll all client connections are lost and must be restarted. As for
what exactly happens, well that depends on the application. If the rows are
returned locally or if they are stored on the web server. And at what stage
in the process each client was in.

Bottom line, in most cases they either hit F5 (refresh) or never notice.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Mike B." <Autobahn97@hotmail.com> wrote in message
news:eS8jOB3XEHA.3596@tk2msftngp13.phx.gbl...
> We have about 40 DB's blackening 40 web sites running on a single
> SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to
the
> next I'm wondering exactly what sort of outage our clients would see.
Since
> the entire cluster rolls in under a minute would there just be a delay on
> the web sites with data requests in response from the web/ODBC side or
would
> there be an ODBC failure. Also, with regards to active web sessions,
would
> clients mid transaction on the web pages need to restart their transaction
> or would there be a short wait during the SQL roll and then they could
> proceed with the transaction (or would they need to start all over again).
> I guess I'm wondering if I need to add the 1 minute of roll time into our
> annual downtime calculation if the clients see an application
> failure/unavailability.
>
>

Relevant Pages

  • Re: Does rolling a cluster create down time?
    ... What the clients see or how it affects their transactions depends solely on ... It must be cluster aware. ... be able to resubmit the current transaction as it will be rolled back on the ... When I roll the cluster from one node to ...
    (microsoft.public.sqlserver.clustering)
  • Roll Out SP2 with GPO
    ... Roll out SP2 on all XP clients with Firewall Disabled. ... I want negtaive user input and the user should logon right away and work. ...
    (microsoft.public.windows.group_policy)
  • Re: Problem with Preoject Server 2003 SP1
    ... you have clients with hundreds of desktops, then your clients are likely to ... "Dries" wrote in message ... > hundreds of desktops aftewards and do brain surgery on each desktop. ... >> You can roll back the alarm now. ...
    (microsoft.public.project.pro_and_server)
  • Re: WPA and GPO?
    ... Is there a GPO to roll out 802.1x settings to *wired* clients? ... Or can I use some type of script? ...
    (microsoft.public.internet.radius)
  • Re: Nexus Vs Flashfiler Vs TdBF
    ... > interested in something that I can use to roll out a conversion ... > program for clients to convert their data. ... Pierre ...
    (borland.public.delphi.thirdpartytools.general)