locked
Memory Usage For SQL RRS feed

  • Question

  • Dear All,

    SQL installed in the SharePoint server (Windows server 2008 / SQL 2008 R2) sometimes use the complete 31 out of 32 GB memory installed.

    This results in few services to stop and application to malfunction.

    After a restart, it becomes fine and in a weeks time, it goes back to full usage.

    I am planning to limit the memory usage to 25 GB, or can u suggest me a recommended size to limit for better server/application performance.

    Also would like to know if by doing the above steps will affect the application in any means.

    Kindly advice.

    Kind Regards,

    Alex.

    Thursday, November 24, 2016 5:44 AM

Answers

  • https://mssqlwiki.com/2013/04/22/max-server-memory-do-i-need-to-configure/

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Thursday, November 24, 2016 6:54 AM
    Answerer
  • I am planning to limit the memory usage to 25 GB, or can u suggest me a recommended size to limit for better server/application performance.

    Alex,

    Limiting max server memory to 25 G on windows machine having 32 G of memory is good. You can also try 26 G leaving 6 G for OS. But your work is not done here you need to monitor memory usage from perfmon counters.

    What you are seeing is NORMAL SQL Server behavior which uses as much memory as it can see and in that case fixing appropriate value for max server memory is good idea.

    Since you have SQL Server version <2012 its quite likely SQL Server can consume memory >25/26 G because some direct memory allocation are done by windows which also comes under SQL memory utilization.


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Thursday, November 24, 2016 2:25 PM

All replies

  • hi,

    you need calculate memory required by sql server,if require more then increase memory.

    https://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/

    https://www.sqlskills.com/blogs/jonathan/wow-an-online-calculator-to-misconfigure-your-sql-server-memory/

    if you cap memeory,application will slow or time out.


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.


    • Edited by AV111 Thursday, November 24, 2016 6:15 AM link
    Thursday, November 24, 2016 5:58 AM
  • https://mssqlwiki.com/2013/04/22/max-server-memory-do-i-need-to-configure/

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Thursday, November 24, 2016 6:54 AM
    Answerer
  • I am planning to limit the memory usage to 25 GB, or can u suggest me a recommended size to limit for better server/application performance.

    Alex,

    Limiting max server memory to 25 G on windows machine having 32 G of memory is good. You can also try 26 G leaving 6 G for OS. But your work is not done here you need to monitor memory usage from perfmon counters.

    What you are seeing is NORMAL SQL Server behavior which uses as much memory as it can see and in that case fixing appropriate value for max server memory is good idea.

    Since you have SQL Server version <2012 its quite likely SQL Server can consume memory >25/26 G because some direct memory allocation are done by windows which also comes under SQL memory utilization.


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Thursday, November 24, 2016 2:25 PM