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 |
|
rav3n0u5
Yak Posting Veteran
88 Posts |
 Posted - 2006-01-19 : 03:31:53
|
| Windows 2k3 Server Edition - Enterprise, SQL 2k5 Enterprise Edition...The server was wiped clean, 16GB of RAM replaced the 8GB, and SQL 2k5 was installed. I have the /PAE switch in the boot.ini, and I have tried using the /3gb switch in conjunction with it. I enabled AWE memory, and checked to make sure the options accessed via sp_configure looked decent (min ram 0, max ram 214... whatever that number is). I also enabled page locking via the group policy interface.In the SQL Agent log, it says that SQL detected 4096 MB of RAM. Windows detects the 16GB of RAM just fine.Ideas? Thoughts? I kind of want to kick the server until it figures out that things are in fact ok... but I suspect that that won't help. |
|
|
rav3n0u5
Yak Posting Veteran
88 Posts |
Posted - 2006-01-19 : 13:44:16
|
| To add, the SQL Agent Log indicates that AWE was successfully enabled. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
|
|
rav3n0u5
Yak Posting Veteran
88 Posts |
Posted - 2006-01-19 : 14:25:31
|
| Michael - as you suspect, the configuration was off - although I am still kind of perplexed...I changed the max server memory from the default value of absolutely huge to 14000, restarted the service, and lo and behold, the problem was magically fixed. I don't understand why SQL wasn't dynamically allocating all the available ram? Thoughts? |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-01-19 : 14:48:20
|
| I'm not sure. I'd have to see what all of your settings were in sp_configure before the change.What may have happened is that you made the changes you needed, and didn't restart the SQL services. Without the restart, it will not "see" the sp_configure changes.I'm glad to see that your machine is using 14GB+ of memory now. That must SMOKE!!Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda> |
|
|
|
|
|
|
|
|
SQL 2k5 - not finding 12 GB of RAM!!