SQL Server Performance

Affect the group and sql server agent

Discussion in 'SQL Server Clustering' started by matey, Mar 16, 2004.

  1. matey New Member

    does anyone know the best practices in terms of sql server agent affecting the group. should it be on or off?.
  2. satya Moderator

    Could you please elaborate '... sql server agent affecting the group...'?


    SQLAgent must be started to perform any jobs that are scheduled such as backups which are most important task for a database.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Argyle New Member

    It depends on what you want. I usually leave it as default affecting the group in case of failure. If you do not want this behaviour turn it off. It's not often that the agent service fail unless there are some other more serious issues with the cluster.
  4. satya Moderator

    Pardon me to cross the question, for a moment I forgot your query relates to clusters.
    Thanks Argyle.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page