I recently encountered this problem on SQL Server whereby the ram was maxing out for no apparent reason resulting in sluggish performance. I'm running 64 bit OS on 32 bit SQL Server Standard Edition.
Checking the error logs reveals this:
A significant part of sql server process memory has been paged out. This may result in performance degradation
Apparently the fix for this is to enable SQL Server to lock pages in memory. The workaround can read from here.
However! According to MSDN, enabling lock pages in memory option whilst not using AWE can significantly impair my system. My current set up does not have enough RAM (2 GIGS) to take advantage of this feature.
So what gives? If I don't implement the fix, SQL Server slows down. If I do, it slows down too.
Does anyone have any thoughts or experiences with this?