Post reply

memory setting in sql server

  • 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

  • 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

  • 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

  • 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 😀

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

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