Our max server memory was unlimited. Consultant said he limited max server memory for another client with a similar issue.

After this discussion, I set max server memory to 1.5 gb. But the problem reoccurred today.

I may need to keep tweaking this setting. it confuses me why windows would page out the memory when 4gb is free. 6 gb total memory in the server.

i'll look into if we can set lock pages for this server. I'll need to confirm capatibility with the software vendor.

We may consider upgrading the server. We were trying to hold off until we upgraded the vendor software too.