dbTalk Databases Forums  

Minimize failover time

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Minimize failover time in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Pasquale
 
Posts: n/a

Default Minimize failover time - 09-01-2008 , 09:23 AM






I have a two node cluster (active/active).
When I try the failover with the cluster administrator tool I have seen that
it occurs 15-20 seconds to recover the SQL Server resource.
Is it possible to decrement the failover time for the SQL Server resource?
How?
Thanks

Reply With Quote
  #2  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Minimize failover time - 09-01-2008 , 06:01 PM






15 to 20 seconds is quite good for a cluster failover. I don't suspect you
will be able to do much more to it than that.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a two node cluster (active/active).
When I try the failover with the cluster administrator tool I have seen
that
it occurs 15-20 seconds to recover the SQL Server resource.
Is it possible to decrement the failover time for the SQL Server resource?
How?
Thanks


Reply With Quote
  #3  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Minimize failover time - 09-01-2008 , 06:01 PM



15 to 20 seconds is quite good for a cluster failover. I don't suspect you
will be able to do much more to it than that.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a two node cluster (active/active).
When I try the failover with the cluster administrator tool I have seen
that
it occurs 15-20 seconds to recover the SQL Server resource.
Is it possible to decrement the failover time for the SQL Server resource?
How?
Thanks


Reply With Quote
  #4  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Minimize failover time - 09-01-2008 , 06:01 PM



15 to 20 seconds is quite good for a cluster failover. I don't suspect you
will be able to do much more to it than that.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a two node cluster (active/active).
When I try the failover with the cluster administrator tool I have seen
that
it occurs 15-20 seconds to recover the SQL Server resource.
Is it possible to decrement the failover time for the SQL Server resource?
How?
Thanks


Reply With Quote
  #5  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Minimize failover time - 09-01-2008 , 06:01 PM



15 to 20 seconds is quite good for a cluster failover. I don't suspect you
will be able to do much more to it than that.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a two node cluster (active/active).
When I try the failover with the cluster administrator tool I have seen
that
it occurs 15-20 seconds to recover the SQL Server resource.
Is it possible to decrement the failover time for the SQL Server resource?
How?
Thanks


Reply With Quote
  #6  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Minimize failover time - 09-01-2008 , 06:01 PM



15 to 20 seconds is quite good for a cluster failover. I don't suspect you
will be able to do much more to it than that.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a two node cluster (active/active).
When I try the failover with the cluster administrator tool I have seen
that
it occurs 15-20 seconds to recover the SQL Server resource.
Is it possible to decrement the failover time for the SQL Server resource?
How?
Thanks


Reply With Quote
  #7  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Minimize failover time - 09-01-2008 , 06:01 PM



15 to 20 seconds is quite good for a cluster failover. I don't suspect you
will be able to do much more to it than that.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a two node cluster (active/active).
When I try the failover with the cluster administrator tool I have seen
that
it occurs 15-20 seconds to recover the SQL Server resource.
Is it possible to decrement the failover time for the SQL Server resource?
How?
Thanks


Reply With Quote
  #8  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Minimize failover time - 09-01-2008 , 06:01 PM



15 to 20 seconds is quite good for a cluster failover. I don't suspect you
will be able to do much more to it than that.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a two node cluster (active/active).
When I try the failover with the cluster administrator tool I have seen
that
it occurs 15-20 seconds to recover the SQL Server resource.
Is it possible to decrement the failover time for the SQL Server resource?
How?
Thanks


Reply With Quote
  #9  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Minimize failover time - 09-01-2008 , 06:01 PM



15 to 20 seconds is quite good for a cluster failover. I don't suspect you
will be able to do much more to it than that.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a two node cluster (active/active).
When I try the failover with the cluster administrator tool I have seen
that
it occurs 15-20 seconds to recover the SQL Server resource.
Is it possible to decrement the failover time for the SQL Server resource?
How?
Thanks


Reply With Quote
  #10  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Minimize failover time - 09-01-2008 , 06:01 PM



15 to 20 seconds is quite good for a cluster failover. I don't suspect you
will be able to do much more to it than that.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Pasquale" <Pasquale (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a two node cluster (active/active).
When I try the failover with the cluster administrator tool I have seen
that
it occurs 15-20 seconds to recover the SQL Server resource.
Is it possible to decrement the failover time for the SQL Server resource?
How?
Thanks


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.