• Check the below articles to resolve the below messages in sql error log.. Basically add -T845 flag in sql server startup parameter and sql service account should have lock pages in memory permission.

    -------------------------

    A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 395696, committed (KB): 11644184, memory utilization: 3%.

    ---------------------

    http://support.microsoft.com/kb/970070

    http://support.microsoft.com/kb/918483