Memory issues in SQL on server 2003 32bit

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Memory issues in SQL on server 2003 32bit

Author

Topic

scottcwilson1
Starting Member

5 Posts

Posted - 2010-10-04 : 16:31:03

Our client uses a server as their PDC as well as their SQL server for a few different instances. They receive an error at random which only refers to one instance of SQL. This error is the result of the server freezing for around 30 seconds at random. During this freeze they cannot use any database programs or access shared drives. The error reads as follows:

Event Type: Information
Event Source: MSSQL$RFMSSQL
Event Category: Server
Event ID: 17890
Date: 8/6/2010
Time: 4:07:31 PM
User: N/A
Computer: HPSERVER
Description:
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): 2080, committed (KB): 1458256, memory utilization: 0%%.

Server is an HP ML370 G5 running Server 2003 Enterprise Edition SP2 (32bit). Server runs SQL 2005 and SQL 2008 (both 32 bit). All programs running on the SQL 2005 platform seem to be operating normally. The only software running on the SQL 2008 platform seems to be the one generating the errors. I have read some things online regarding this error but everything I have found refers to 64 bit systems. The suggestions I have found say that memory limits in the registry need to be configured differently. This was corrected using this command as well:

sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure

sp_configure 'max server memory (MB)', 10000;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure
GO

sp_configure 'awe enabled', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure
GO

I am not very good at SQL but i am trying to stop this issue. I am not using PAE or Trimming as i don't know what they are.

Any advice would be great just send me a email as i am on the road 4 out of 5 days.

Thank You very Much

Scott

Scott Wilson

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-04 : 17:28:01

Has the "lock pages in memory" privilege been granted to the SQL Server service account?

How much memory do you have on the server?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

scottcwilson1
Starting Member

5 Posts

Posted - 2010-10-04 : 19:43:26

you know what i just saw the issue and i think i can use the PAE switch remove the other items they tried so far and it will work.

The server has 6 GB in it. I know the 32 bit would have been a issue if it was standard but i just saw what my other worker put in this post. With stadard you can not use anything to make it see over 4 GB. But since it is enterprise we can remove the AWE and the /3GB switches and just put PAE switch in the place and this should work i hope! Yes they did put the privilege in the SQL account.

Scott Wilson

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-04 : 19:50:53

You'll want to adjust 'max server memory' down to 4GB or lower then.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

scottcwilson1
Starting Member

5 Posts

Posted - 2010-10-05 : 11:15:03

thanks. we will try this on the weekend as we can niot get into that ,machine often

Scott Wilson

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources