locked
Ram 100% on SQL 2016 Standard RRS feed

  • Question

  • Hello,

    i have a problem with SQL 2016 standard when I miggrate from SQL 2008R2 Standard.

    Old Server:

    -Windows server 2008R2

    -SQL 2008R2 Standard

    -Database 64Gb

    -Server Ram 20Gb

    -Instance ram limit 16Gb

    New Server:

    -Windows Server 2016

    -SQL 2016 Standard

    -Database 64Gb

    - Server RAM 32Gb

    -Instance Ram Limit 26Gb

    The problem is on the new server. Ram all time is on 100% but I don't know why because the instance have set Maximum server memory.

    Tuesday, July 11, 2017 1:10 PM

Answers

All replies

  • Which program is consuming RAM in your new server ? since you have limited sql max to 26 GB , SQL buffer pool shouldn't use more than that 

    Thanks, Nithin

    Tuesday, July 11, 2017 5:10 PM
  • Hello,

    Apply Service Pack 1 for SQL Server 2016.

    https://www.microsoft.com/en-us/download/details.aspx?id=54276



    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, July 11, 2017 6:27 PM
  • Servis pack 1 resolved the problem!

    Thank you!

    Wednesday, July 12, 2017 6:23 AM
  • Hi Mr.Gruden,

    Glad to hear that the issue has been resolved, please mark Alberto’s reply as answer as it would benefit other community members when they are reading this thread.

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, July 12, 2017 6:59 AM
  • Hello,

    I glad to know it helped you troubleshoot this issue..



    Thank you for visiting MSDN forums..



    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, July 12, 2017 10:48 AM