We recently did an in-place upgrade of our cluster from SQL 2000 Enterprise to 2005 Enterprise.ÃÂ We are seeing memory utilization on the server that is not expected and wanted to get an idea from others if this is normal.ÃÂ Here is our setup:
32-bit Windows Server 2003 SP1
SQL 2005 SP2, 2-node cluster
16 GB memory on each node
/3GB /PAE switches in the boot.ini file
AWE Enabled, min memory=0, max memory=14000
The strange bit is that in the Task Manager the SQL service is showing as only using 205 MB of memory and the pagefile usage is at 13 GB.ÃÂ This is troublesome since it looks like SQL is using virtual memory instead of physical memory.ÃÂ We recently upgraded the memory from 4 GB to 16 GB, the sql cluster service account was added to the Lock Pages in Memory policy, the boot.ini switches were set and the AWE enabled/max_server_memory script was run before upgrading to 2005.ÃÂ Can anyone confirm either 1) this is normal or 2) how to correct the memory usage?
I have also questioned using the /3GB switch; would it be better to remove that and set the max memory for SQL to 12000?
Any help would be greatly appreciated.ÃÂ If I left off any information that would be helpful, please let me know.
View Complete Post