A significant part of sql server process memory has been paged out

Tuesday, 21 August 2012 13:19

Written by Prakash Palani

Print

 

We have recently encountered an incident with below error message in one of the most critical production system, upon analysis, it was found that considerable amount of memory reserved by SQL Memory was trimmed due to lack of physical memory. During the trimming operation, for about 5 minutes, overall SAP system performance was poor and all the end users were having very high response time.

Error Message

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

Below are the possible solutions for this situation:

 

 

 

 

 

 

A significant part of sql server process memory has been paged out