• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1915
  • Last Modified:

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

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
bon733
Asked:
bon733
1 Solution
 
nakul_vachhrajaniCommented:
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
 
the3rdmanCommented:
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now