Software: Windows 2003 Server Enterprise Sql 2000 Enterprise Sp3
Boot.ini Settings: /PAE /3GB
Sql Settings: AWE = 1 Max server memory = 7000 (fixed)
Database sizes: 150GB 220GB
With these settings, sqlserver.exe will use only 2.7GB of memory with over 4GB of memory left available to the server (the server properly reports 8GB total). Perfmon "sqlserver:total server memory" confirms this. If I take out the /3GB switch in boot.ini, sqlserver will only use 1.7GB. These are hard limits as SQL never scales past these amounts even under load for several days. What am I missing??
Does sql service account has following user rights on the server?
Act as part of the operating system Increase quotas Log on as a batch job Log on as a service Replace a process level token Bypass traverse checking (that is usually set for Everyone anyway) Lock pages in memory access this computer from the network backup files restore files increase scheduling priority load & unload device drivers
Does sql service account has following user rights on the server?
Act as part of the operating system Increase quotas Log on as a batch job Log on as a service Replace a process level token Bypass traverse checking (that is usually set for Everyone anyway) Lock pages in memory access this computer from the network backup files restore files increase scheduling priority load & unload device drivers
Awesome, that did it! (I'm assuming the lock pages in memory) The task manger is reporting the memory usage incorrectly, but the perfmon object is dead on.
SQL server only uses 2.7GB on 8GB server
Posted - 04/07/2007 : 15:07:11
