Maxmemory setting in active-pasive cluster.

  • mig28mx

    Ten Centuries

    Points: 1002

    Hi,
    I have the following instalation:

    SQLCLUSTER is compound by SQLCLU1 and SQLCLU2. Both nodes have 128 GB of ram each. The current setting is maxmemory=256 gb. So I need to adjust that parmmeter.
    My questions are:

    Do I have to log in each node (SQLCLU1 and SQLCLU2) to adjust the parammeter?
    or
    I Just need to access to SQLCLUSTER and adjust the parammeter?

    Thank you in advance.

  • Gail Shaw

    SSC Guru

    Points: 1004424

    mig28mx - Thursday, October 18, 2018 6:26 PM

    I Just need to access to SQLCLUSTER and adjust the parammeter?

    Yes

    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

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

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