memory setting in sql server

• atulyan.aries

  SSCrazy

  Points: 2020

  More actions

  January 12, 2019 at 6:38 pm

  #373545

  from the GUI I changed the max memory setting clicked ok and restarted the SQL services, but it still does not reflect. any ideas

• Eddie Wuerch

  SSChampion

  Points: 12540

  More actions

  January 13, 2019 at 1:43 am

  #2018780

  atulyan.aries - Saturday, January 12, 2019 6:38 PM

  from the GUI I changed the max memory setting clicked ok and restarted the SQL services, but it still does not reflect. any ideas

  You do not need to restart SQL Server after changing the max memory setting.
  If you grew the amount, SQL Server will request the memory only when it needs it. Depending on the activity on your server, it may take some time before SQL Server claims all of the memory you granted it.
  If you reduced the max memory amount, the instance will begin releasing memory back to the O/S until it hits the target.

  Eddie Wuerch
  MCM: SQL

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 13, 2019 at 4:44 am

  #2018786

  What do you mean 'it doesn't reflect'?

  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

• sqlsurfing

  SSCarpal Tunnel

  Points: 4883

  More actions

  January 15, 2019 at 4:30 pm

  #2019020

  Have you confirmed with  sp_configure if it updated 

  https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-configuration-options-sql-server?view=sql-server-2017

  --------------------------------------------------
  ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully