יום שלישי 06 מרץ 2012 16:12
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 ?
יום שלישי 06 מרץ 2012 18:15
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
יום רביעי 07 מרץ 2012 06:08משיב
---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/
יום רביעי 07 מרץ 2012 07:46
for a discussion on this same issue.
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
יום שישי 24 אוגוסט 2012 15:09
Refer below article for answers to your question and solution