We have a server with 48 GB RAM on it. We're running some pretty heavy processes on SQL Server 2008 64 bit, but it tops out at 3 GB and won't use any more. It only uses about 15% of the CPU. The max is set to 2147483647 MB. We also have SQL 2005 (32 bit) and SQL 2008 R2 (64 bit) on the same server. I also moved the database to the R2 version and nothing changed.
Would the 2005 instance limit the memory for everything else?
Is there any way to get it to use more of the RAM?
Any other ideas?