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 |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2006-08-17 : 14:36:57
|
| Hi,We have a system with following configurationRAM 8GBOS Windows 2003 Enterprise edition (can support upto 32GB)AWE enabled on machine with 6GB as max memory/3gb and /pae switch in boot.iniSQL Server 2000 Enterprise edition with sp4 But somehow SQL Server is not using >4GB even when we configured it to 6GB and we an see about >3GB as still not used.What can be the possible issue?Thanks--Harvinder |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2006-08-17 : 14:40:01
|
| If you haven't tried yet, you can go to the properties of the server, on the memory tab you can adjust how do you want your server to use the mem. Hope this helps.---Thanks!Igor. |
 |
|
|
rubs_65
Posting Yak Master
144 Posts |
Posted - 2006-08-17 : 14:57:34
|
| I checked that it is configured at 6GB |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-17 : 14:58:13
|
| How do you know that the database needs to use more memory?Tara Kizer |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-08-17 : 15:06:35
|
| There is a bug in SP4 that prevents SQL Server from using 50% of the available AWE memory. There is a hotfix for this (build 2040) you can get here:http://support.microsoft.com/kb/894905/ |
|
|
|
|
|
|
SQL Server not using >4GB memory