Post reply

Is it possible to run two instance in Cluster

  • January 6, 2012 at 6:42 am

    #254297

    HI,

    I am getting performanence issue on two instances runnning in cluster server ?

    Please advice me,

    Thanks

    jerry

  • January 6, 2012 at 7:03 am

    #1429608

    Thats pretty vague.

    What performance issues are you getting?

    Are both instances runnning on the same node? If so, have you tried running them in an active/active setup by having an instance on each node?

    Is max memory configured to allow for both instances and the OS?

  • January 6, 2012 at 7:14 am

    #1429612

    both instances running on active node..

  • January 6, 2012 at 7:23 am

    #1429617

    MysteryJimbo (1/6/2012)

    What performance issues are you getting?

    If so, have you tried running them in an active/active setup by having an instance on each node?

    Is max memory configured to allow for both instances and the OS?

  • January 6, 2012 at 10:36 am

    #1429750

    MysteryJimbo (1/6/2012)

    MysteryJimbo (1/6/2012)

    What performance issues are you getting?

    If so, have you tried running them in an active/active setup by having an instance on each node?

    Is max memory configured to allow for both instances and the OS?

    I just wanted to re-iterate the questions

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 9, 2012 at 9:38 am

    #1430610

    My advice is collect performance metrics on both instances, and put together a plan based on those that will handle any meaningful performance bottlenecks or resource-depletion issues.

    Start with gathering actual metrics on both.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • January 31, 2012 at 10:19 am

    #1440796

    We had similar issues in our environment when two instances shared a node. Currently, on sql startup (like after failover), we have a procedure that runs and checks how many instances are on the current node, adjusting max server memory accordingly. It helps, but we still try to keep the instances on their own nodes as much as possible due to other performance bottlenecks that slowly creep in.

Viewing 7 posts - 1 through 6 (of 6 total)

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