I'm having a memory issue when running SQL Server queries.
I have a 64 bit Windows 7 operating system with 4G of Ram with SQL Server 2008 R1.
I'm running a SP on my machine that runs on production every night that has 8G of Ram with the same SQL Server version.
Within minutes of starting the SP on my machine, the memory goes from 1.98G to 3.92G (97% usage). I am not able to do anything else on my PC. The SP takes about 15-20 minutes on production and if I let it run it will take over 3 or 4 hours or I get the BSOD... which seems to create a dump with has to do with memory.
I've tested the memory cards and they seem to be fine.
Doesn't SQL Server swap out pages when the OS needs it for other processes?
Any suggestions on what I may try to do?
Could it be as simple as needing 8G of RAM? But why would my whole system come to a halt?