SQL Server Performance

Question about failover

Discussion in 'SQL Server Clustering' started by jbrochu, Nov 10, 2003.

  1. jbrochu New Member

    Hey forum, I have a question. I am in the midst of getting a two node cluster into production. Its an active/passive configuration, running Windows2k Adv & MS SQL 2000. Both nodes are sharing a Dell storage system via SCSI bus. The shared storage is raid 10. Not sure if more information will be needed but my question is pretty basic.

    If I am in the middle of a sql query and the primary node fails, the secondary node picks up in about 6 seconds, but the query breaks as soon as failover begins, is this customary? Or do I have a mis-configuration problem.

    TIA,
    Joe
  2. Argyle New Member

    The query will break and it is expected behaviour. Doing a failover is the same thing as stopping and starting the SQL service on a stand alone server.

    /Argyle
  3. jbrochu New Member

    Hey Argyle your the man. Thanks for the quick response! I really appreciate it. Wish I could get quick answers like that to all my little troubles in life <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br /><br />Joe
  4. bradmcgehee New Member

    I might also add that it is important for applications to be cluster-aware, so that they can recover after a failover. As a bad example of how to write software, we run an ERP product that is so stupid that after a failover, the app is not able to reconnect to the database, and has to be restarted.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com

Share This Page