I run BPA on my pc and i received the following from my BPA report. "A
significant portion of SQL server process memory has been paged out". i have
read the KB provided but it seems to be the workaround for 64 bit machine. my
pc is having 1GB memory and running on Windows XP professional version 2002
SP3 32 bit machine. is there any solution for this?

Hi Yee Beng,

The following blog post from CSS provides a very detailed explanation of why
that can occur:
http://blogs.msdn.com/psssql/archive...t-message.aspx

On your 32-bit system with 1GB memory, depending on what other processes are
running together with SQL Server and how memory intensive your db application
is, all three kinds of trims can easily occur.

If possible, you should stop as many other processes besides SQL Server as
possible, and for those that you cannot stop, lower their running priority.
It might also be worthwhile to see if reducing your "max server memory"
setting under sp_configure would help.


"Yee Beng" wrote: