What is difference between Is Alive and Look Alive in SQL Server?

What is difference between Is Alive and Look Alive in SQL Server?

  • Look Alive: Look Alive is the basic resource health check, it verifies that SQL Server is running on the current node.
  • By default it will run by every 5 seconds.
  • Is Alive: Is Alive checks resources health for every 60 seconds by running the command “Select @@servername”.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s