Post reply

Min Max settings in passive node

  • October 26, 2012 at 10:31 am

    #269107

    Quick one.

    How do I find the Min Max settings in a passive node of a cluster if SQL services isn't running on it.

    Do I have to failover then check.

    Or is there another option

  • October 26, 2012 at 11:24 am

    #1553319

    MIN MAX Memory settings, Just to make it clear.

  • October 26, 2012 at 11:36 am

    #1553322

    It'll be the same as the active instance. They're stored in master, the master DB is shared in a cluster, hence settings are identical.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 27, 2012 at 1:25 am

    #1553466

    Thanks

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

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