?
Solved

A significant part of sql server process memory has been paged out. This may result in a performance degradation

Posted on 2007-04-10
2
Medium Priority
?
1,904 Views
Last Modified: 2008-01-09
Windows 2003 Server SP1 running SQL Server 2005 (x86) SP2, all of a sudden we get "Source: spid1s Message 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): 10528, committed (KB): 1459260, memory utilization: 0%."

The only thing I have seen is for 64-bit SQL. Has anyone seen this error before?
0
Comment
Question by:bon733
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Accepted Solution

by:
nakul_vachhrajani earned 1500 total points
ID: 18887357
This is the result of:
1. Insufficient system configuration (although I doubt that is the case)
2. Your database is way too fragmented - try reducing the fragmentation on the database
0
 

Expert Comment

by:the3rdman
ID: 22220381
When you say the database is too fragmented, is that a file fragmentation (i.e. the MDF file) or of the data within the database?

We have exactly the same issue as above.  I have checked and the file fragmentation is 69% on the drive (which contains just the database files, not logs etc).  
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question