bon733
asked on
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?
The only thing I have seen is for 64-bit SQL. Has anyone seen this error before?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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).