Home > IT Answers > Microsoft Windows > Why does SQL server use no more than 500MB in RAM?
Rick Martinez
585 pts.
 Why does SQL server use no more than 500MB in RAM?
CPU, RAM, SQL, SQL Server, SQL Server 2005, SQL Server memory, Windows Server 2003 32-bit
Why does sql server use no more than 500mb in ram? We have sql server 2005 running on server 2003 32bit with 32GB of ram and in the task manager under processes, Mem Usage sqlservr.exe is only using 430, 268 K. SQL Server min memory is set to use 25GB and max is set to use 29GB. Our database is 500GB in size and our PAGEIOLATCH_SH is high. I dont understand what is going on here. Also we have been having HIGH CPU usage.

Software/Hardware used:
SQL SErver 2005
ASKED: October 15, 2010  5:50 PM
UPDATED: October 15, 2010  7:00 PM
RELATED QUESTIONS
Answer Wiki:
Do you have AWE enabled? If so it is normal for task manager to show the wrong amount. Verify using Perfmon to see how much RAM its actually using.
Last Wiki Answer Submitted:  October 15, 2010  6:50 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thank you Mr. Denny, I learned that you have to look inside SQL Server. I used this query.
SELECT
‘AWE allocated, MB’ = SUM(awe_allocated_kb) / 1024.0
,’AWE allocated, GB’ = SUM(awe_allocated_kb) / 1048576.0
FROM sys.dm_os_memory_clerks

Rick Martinez
 585 pts.