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
1,892 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
2 Comments
 
LVL 5

Accepted Solution

by:
nakul_vachhrajani earned 500 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
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 extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now