Author Topic: What are LooksAlive” and IsAlive” checks?  (Read 175 times)

Offline Nicholas

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
What are LooksAlive” and IsAlive” checks?
« on: October 24, 2014, 11:45:57 AM »
Hi, I would like to ask you a big question about my situation, what are “looksalive” and “isalive” checks? Thank you please help me quickly because I'm stressed.



Offline Ciaran

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: Looksalive and IsAlive checks?
« Reply #1 on: February 19, 2018, 08:45:29 PM »
When an instance of SQL Server is running in a Clustered Environment, Microsoft Cluster Service performs two checks to confirm if the SQL Server resource is still available. One is LooksAlive and the other one is IsAlive check.

LooksAlive is a basic check in which the Cluster service queries the Windows Service Control Manager to check if the SQL Server service is still running. By default this check happens every 5 seconds. During IsAlive check the Cluster Service connects to the SQL Server instance with the help of c:\windows\system32\sqsrvres.dll and runs SELECT @@SERVERNAME against the instance. This check does not check if the user databases are online or not. It just checks the SQL Server instance availability. This check happens every 60 seconds by default.


 

Sitemap 1 2 3 4 5 6 7 8 9