Maxmemory setting in active-pasive cluster.

• mig28mx

  Ten Centuries

  Points: 1090

  More actions

  October 18, 2018 at 6:26 pm

  #371726

  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: 1004504

  More actions

  October 18, 2018 at 10:26 pm

  #2010358

  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