error on sql server 2003 32 bit

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

Database Design and Application Architecture

error on sql server 2003 32 bit

Author

Topic

scottcwilson1
Starting Member

5 Posts

Posted - 2010-10-04 : 16:32:11

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

Scott Wilson

robvolk
Most Valuable Yak

15732 Posts

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

Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151053

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources