Post reply

Sql Server Mamory Management

  • April 24, 2015 at 7:42 am

    #317642

    Hi,

    I was working on a client site and I observed that their RAM utilization was on 100% . This caused paging and overall server performance degraded.

    They told me that if they restart mssql service, it will reduce to 2-3 GB (current utilization is 31GB).But in task manager , I was not able to see this much amount allocated to any process.

    So it seems that MSSQL is consuming the memory. I want your expert opinion .

    Should I reduce MaxServerMemory under database properties ? it is currently set to 30GB and 32GB is max RAM installed 🙁

    If I do so , what could be its impact ? like do I have to consider something before making this decision ?

    What other option I could explore ?

    Thanks

  • April 24, 2015 at 8:22 am

    #1793285

    Please take a read through Chapter 4: http://www.red-gate.com/community/books/accidental-dba

    Yes, you probably should reduce Max Server memory. Leaving only 2GB for the OS on a 32 GB server is tight.

    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

  • April 24, 2015 at 9:01 am

    #1793301

    Thank You.

    Do I have to consider any thing before executing following ?

    Will it take more time to reconfigure?

    will database be available to connect during this activity ?

    Do I have to restart sql service after that ?

    sp_configure 'max server memory', 20480;

  • April 24, 2015 at 9:09 am

    #1793305

    thbaig (4/24/2015)

    Will it take more time to reconfigure?

    No, it's instant

    will database be available to connect during this activity ?

    Yes

    Do I have to restart sql service after that ?

    No

    sp_configure 'max server memory', 20480;

    And that's probably far too low. Please read the chapter I recommended, it discusses the guidelines and reasons for the max server memory setting, as well as how SQL manages memory in general

    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

  • April 24, 2015 at 9:28 am

    #1793313

    Done with book download

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

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