Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

memory error Expand / Collapse
Author
Message
Posted Thursday, March 20, 2008 10:15 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, October 4, 2009 7:33 AM
Points: 84, Visits: 43
I receive the following two error messages in my sql logs and I have a feeling its affecting my application batch processing. I can't find much out about it on the internet. This is SQL 2005 SP2 X64 machine with 24 GBs of RAM running Windows 2003 SP2. Not many users at all on the server at all.

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): 130168, committed (KB):
17139648, memory utilization: 0%

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



Post #472380
Posted Thursday, March 20, 2008 10:26 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 5:36 PM
Points: 1,339, Visits: 596
Although there is hotfix available for this issue that brings 9.00.3186.00. But My experience says it does not resolve issue completely. Hence, to resolve this issue you have to clear cache. You may do this using clearcache.exe file with -1 value.

How much memory your server has? What is Max Memory setting? If possible please let me know your sp_configure output.



--www.sqlvillage.com
Post #472391
Posted Thursday, March 20, 2008 10:43 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, October 4, 2009 7:33 AM
Points: 84, Visits: 43
24 GBs total. Do you have the KB article number for the hotfix?


max server memory (MB) 16 2147483647 2147483647 2147483647



Post #472410
Posted Thursday, March 20, 2008 12:20 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:12 AM
Points: 1,166, Visits: 1,973
Do you have lock pages in memory enabled?
Are there other applications running on this server?
Is SSIS utilized on this server?
Is CLR in use on this server?
How many instances of SQL are running?
Are you min and max server memory options set?


---
SQLSlayer
Making SQL do what we want it to do.

Post #472480
Posted Thursday, March 20, 2008 12:29 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, October 4, 2009 7:33 AM
Points: 84, Visits: 43
Do you have lock pages in memory enabled? No
Are there other applications running on this server? Just 2005
Is SSIS utilized on this server? No
Is CLR in use on this server? No
How many instances of SQL are running? 1
Are you min and max server memory options set? the sp_configure output is listed above in the thread.



Post #472482
Posted Thursday, March 20, 2008 12:36 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:12 AM
Points: 1,166, Visits: 1,973
Hmm, with your responses I wouldn't be to alarmed about enabling lock pages in memory then, but it is still good practice to have it enabled.

You may want to read up on these articles: http://blogs.msdn.com/psssql/archive/2007/05/31/the-sql-server-working-set-message.aspx
http://blogs.technet.com/askperf/archive/2007/05/18/sql-and-the-working-set.aspx
http://support.microsoft.com/kb/918483
http://weblogs.asp.net/omarzabir/archive/2007/10/19/a-significant-part-of-sql-server-process-memory-has-been-paged-out-this-may-result-in-performance-degradation.aspx


---
SQLSlayer
Making SQL do what we want it to do.

Post #472485
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse