Post reply

Managing a clustered and non clustered SQL instance. What are the differences

  • May 26, 2010 at 8:01 am

    #139164

    Hi,

    I want to know what the differences are between managing a clustered and non clustered SQL instance.

    Any documentation/tips will be appreciated.

  • May 26, 2010 at 9:13 am

    #1172811

    Technically not a lot from the dataengine point of view. You have to remember that not all SQL is cluster aware (SSIS for example) so sometimes you have to be aware that you need to create duplicate info or amend config files.

    Other thing to keep in mind is the extra complication of the cluster software (doesn't have to be windows clustering), the SAN for sharing the drives etc.

  • May 26, 2010 at 10:51 am

    #1172891

    We also monitor when a failover occurs. We had a non-SQL Server issue that was causing the cluster to failover every morning at 3:30 AM. Prior to installing monitoring, we had no idea there was a problem with the cluster.

    Cindy

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply