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.