Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
j0nx
Starting Member
4 Posts |
 Posted - 2007-04-07 : 15:04:04
|
| First of all, here is the setup.Hardware:Dell Quad Xeon 2.7ghz8 GB ramSoftware:Windows 2003 Server EnterpriseSql 2000 Enterprise Sp3Boot.ini Settings:/PAE /3GBSql Settings:AWE = 1Max server memory = 7000 (fixed)Database sizes:150GB220GBWith 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?? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
SQL won't use over 2.7GB on 8GB server