locked
MSSQL/Sharepoint13 17890 message on windows application log RRS feed

  • Question

  • 
    

    I kept getting this message in the Windows Application log:  "A significant part of sql server process memory has been paged out. This may result in a performance degradation. duration 1517 seconds. Working set (KB): 84788, committed (KB): 188952, memory utilization: 44%."   This message doesn't come up all the time, nor does it have a pattern in it's appearance during the day.  Sometimes there are more in a day, other days tehre are fewer.  Does this slow down the SQL performace?  What shall I do to improve?  Thanks in advance. 

    Monday, August 21, 2017 3:13 PM

All replies

  • 
    

    I kept getting this message in the Windows Application log:  "A significant part of sql server process memory has been paged out. This may result in a performance degradation. duration 1517 seconds. Working set (KB): 84788, committed (KB): 188952, memory utilization: 44%."   This message doesn't come up all the time, nor does it have a pattern in it's appearance during the day.  Sometimes there are more in a day, other days tehre are fewer.  Does this slow down the SQL performace?  What shall I do to improve?  Thanks in advance. 

    The message says that windows is paging SQL Server process to disk because it "took" the memory which SQL Server process was using. Paging significantly slows down SQL Server process as it is thrown away from memory to disk.

    A common workaround is to grant SQL Server service account locked pages in memory privilege after that find out what is causing this. This would require SQ Server restart

    This Blog will help you more


    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


    • Edited by Shanky_621MVP Monday, August 21, 2017 4:19 PM
    • Proposed as answer by Teige Gao Monday, September 4, 2017 5:48 AM
    Monday, August 21, 2017 4:18 PM