SQL Server Performance

Clustering: Post Installation

Discussion in 'SQL Server 2005 Clustering' started by Fais, Feb 12, 2008.

  1. Fais New Member

    Hi All,
    After installing SQL Server 2005 in Clustering, what are the general post installation tasks that need to be done: http://www.microsoft.com/downloads/...dc-a17b-4f09-b282-c6830fead499&displaylang=en
    (1) For SQL Server service & SQL Agent service, should I change the property " Affect the group". What else need to be changed.
    (2) What should be the "Threshold" & "Period" which is there below "Affect the group" property. ( Goto Cluster Admin --> SQL Service --> Right click --> Advanced).
    Thanks.
  2. satya Moderator

    Make sure the SQL Server resource is set to affect the group. Often it’s best to leave Agent and FTS (Fulltext, if you are using) to not affect the group but that depends on your business needs.
    We set the threshold - 5 and period to 3 that brings SQL Services within 3 minutes, so better to check/test failover scenario at your side.

Share This Page