How to troubleshoot SQL Server error message 17890

Symptoms

You might encounter the following error message in the SQL Server error log or the Windows Application event log

2010-04-30 15:50:35.60 spid1s      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): 3383250, committed (KB): 9112480, memory utilization: 37%.


You might also notice a sudden performance degradation with query execution and all other operations on the SQL Server.

Cause

SQL Server monitors the various memory related information about the SQL Server process. In this case it has detected that the working set of the process is less than 50% of the committed proess memory. As a result this warning is printed. The normal causes of this warning are:

  1. The operating system pages out large portions of the the SQL Server committed memory to the paging file.
  2. This could be due to sudden increased demand for memory from other applications or operating system needs.
  3. This could also happen when certain device drivers request contiguous memory allocations for thier needs.

More Information

For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:

Rule softwareRule titleRule descriptionProduct versions against which the rule is evaluated 
SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA)





Significant Portion of SQL Server Memory Has Been Paged Out 






The SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) provides a rule to detect situations where the SQL Server memory was paged out. The SQL Server 2008 R2 BPA supports both SQL Server 2008 and SQL Server 2008 R2. 

If you run the BPA tool and encounter an Error with the title of DatabaseEngine - Significant Portion of SQL Server Memory Has Been Paged Out, then you need to follow the recommendations from the resolution section of this article. You might need to apply fixes for known issues as well as making certain configuration changes to avoid encountering this problem.
SQL Server 2008
SQL Server 2008 R2







SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA)





Significant Portion of SQL Server Memory Has Been Paged Out





The SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) provides a rule to detect situations where the SQL Server memory was paged out.  

If you run the BPA tool and encounter an Error with the title of Database Engine - Significant Portion of SQL Server Memory Has Been Paged Out, then you need to follow the recommendations from the resolution section of this article. You might need to apply fixes for known issues as well as making certain configuration changes to avoid encountering this problem.
SQL Server 2012










Proprietà

ID articolo: 2028324 - Ultima revisione: 02 apr 2012 - Revisione: 1

Feedback