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

Question

My MSSQL Server has the following problem

 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): ????, committed (KB): ???????, memory utilization: 50%.

My OS is Windows 2003 SP1 with 2GB Ram, SQL server is 2005 standard SP1,

- No min/max memory is set.

1. Why is this happen ?

2. will this problem elimilate when I set min/max memory for SQL server? Actually the SQL Server has Total memory nearly equal to Target memory all day long.

3. what's working set? what's commited(KB) are what are their relationship ?How can I find the among of pages are out? and which other processes request  SQL to page out ?

Thanks

Answer 1

I am not sure that this is the right forum for this message, you may want to try the "SQL Server Database Engine" forum.

However, I assume this is from the SQL error log, are the memory values really set to "????" or do you have the actual values?

Also, 2GB is not really a lot of memory and setting the min/max memory limits may not be the best option (without more information). The problem could be with other processes running on the server, so you may want to see if SQL is competing with some other process for memory. I would look at the "Private bytes" counter to see how much total physical memory SQL is using.

---

William F. Kinsley

Answer 2

---Why is this happen ?

1) Increase memory of the server

2) Install latest SP for SQL Server

3) Make sure that account SQL Server runs under is added to Locked Pages in Memory  local group policy

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 3

See
http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/67361952-4c4f-493a-9788-6bc6e8b6e937
for a discussion on this same issue.

---

Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Answer 4

Refer below article for answers to your question and solution

http://mssqlwiki.com/2012/06/27/a-significant-part-of-sql-server-process-memory-has-been-paged-out/

Thanks

Karthick P.K

Blog:http://mssqlwiki.com/