SQL Server Thoughts from the Field

Rob's SQL Server & BI Blog

Browse by Tags

Related Posts
  • Blog Post: Windows Failover Clustering Overview

    The host node in the failover cluster performs a "looks alive" check every 5 seconds. An IsAlive check is performed every 60 seconds using SELECT @@SERVERNAME. If this fails the IsAlive retries 5 times and then attempts to reconnect to the instance of SQL. If all fail, then the SQL Server resource fails...
  • Blog Post: SQL Server 2005 Multi-Site Clustering with Windows Server 2008

    I was working recently with a customer who was looking to deploy a SQL Server 2005 cluster across 2 geographically dispersed sites using Windows Server 2008. They were looking to utilise the new clustering improvements in Windows Server 2008 to build a highly available SQL Server solution. The customer...