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 |
|
¢ödêmån
Starting Member
32 Posts |
 Posted - 2002-07-16 : 04:55:00
|
8Gb of RAM and AWE is enabled /3Gb/PAE in the boot.ini, the service account that SQL runs under has 'lock pages in memory' as a rights.I've also 'Fixed' the memory to about 5.5Gb and the rest for the OS which is Win2K Adv Serv SP2, SQL2K Ent SP2.Now my question is does anyone know why the errorlog only shows :'Working Set size set to 1572864 kilobytes.' on startupand not the 5.5Gb which should be 5767168 instead.Also I've got another environment which has only 4Gb, and this one does not show AWE enabled in my errorlog, shouldn't it ?Any enlightment on the matter would be greatly appreciated.  Cheers!--¢ödêmån-- |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2002-07-16 : 17:20:07
|
| I'm not sure if this is really a problem:When you set the Max Server Memory, SQL Makes Working Set vary between Min Server and Max Server. Even if you enable AWE there is no need to fix the amount of meory SQL uses. The Best is to leave SQL use Dynamic Memory between a minimun and the max server, in your case 5.5GB or set Minimum equal to Maximum and set working set to 1.Sérgio Monteiro |
 |
|
|
¢ödêmån
Starting Member
32 Posts |
Posted - 2002-07-16 : 23:32:16
|
| Sérgio,Thanks for the post.Does anyone else know much about 'Fixed' memory ? Any KB articles that I'm not aware about. Basically I want to know the adv, disadv between dynamic and fixed memory. Cheers--¢ödêmån-- |
|
|
|
|
|
|
AWE Enabled