Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

Thanks!

share|improve this question
    
Did you also measure IO? What is the average busy time for the disks? –  Hennes Sep 10 '12 at 22:18
    
Which edition of SQL Server are you using? Sounds like you are not using a SQL Edition that supports more than 4GB. –  Brent Pabst Sep 10 '12 at 22:18
    
As I noted above, I'm using SQL 2008 64 bit. –  Erick Sep 10 '12 at 22:25
    
@Hennes how do I measure that? I'm a .NET dev and not a DBA, but I need to get this to work. :/ Thanks! –  Erick Sep 10 '12 at 22:27
    
ResourceMonitor has an option to check diskIO and queue depths. (there might be better programs, but this one is build into both win7 and server2012. No idea about server2008 since I do not use that). Easiest way to start it is via the task manager. –  Hennes Sep 10 '12 at 22:32
show 4 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.