memory error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » memory error

memory error

Rate Topic

Display Mode

Topic Options

Author

Message

mgraulich

Posted Thursday, March 20, 2008 10:15 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, October 04, 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

Mohan Kumar

Posted Thursday, March 20, 2008 10:26 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 03, 2013 4:44 PM
Points: 1,336, Visits: 595

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

mgraulich

Posted Thursday, March 20, 2008 10:43 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, October 04, 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

Adam Bean

Posted Thursday, March 20, 2008 12:20 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 12:18 PM
Points: 1,103, Visits: 1,781

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?

--

Post #472480

mgraulich

Posted Thursday, March 20, 2008 12:29 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, October 04, 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

Adam Bean

Posted Thursday, March 20, 2008 12:36 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 12:18 PM
Points: 1,103, Visits: 1,781

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

--

Post #472485

« Prev Topic | Next Topic »

Permissions