Monday, March 19, 2012

8GB memory installation

Situation:
OS: 2000 advanced server
SQL enterprise
We have just added an extra 6GB of memory to our database server which
brings the total to 8. The problem we are having is that the OS is only usin
g
3Gb of memory.
We have run the SP that is recommended for AWE and entered the /3GB /PAE in
the boot.ini file and restarted the machine.
The server still refuses to use more than 3GB. Any ideas?Did you re-configure SQL, the AWE and fixed memory?
e.g.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'min server memory', 6656 (make same as maximum)
RECONFIGURE
go
sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
RECONFIGURE
Regards
Mike
"lramsdale" wrote:

> Situation:
> OS: 2000 advanced server
> SQL enterprise
> We have just added an extra 6GB of memory to our database server which
> brings the total to 8. The problem we are having is that the OS is only us
ing
> 3Gb of memory.
> We have run the SP that is recommended for AWE and entered the /3GB /PAE i
n
> the boot.ini file and restarted the machine.
> The server still refuses to use more than 3GB. Any ideas?|||This is what we ran:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Did you re-configure SQL, the AWE and fixed memory?
> e.g.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 6656 (make same as maximum)
> RECONFIGURE
> go
> sp_configure 'max server memory', 6656 (leave at least 512 for the OS)
> RECONFIGURE
> Regards
> Mike
> "lramsdale" wrote:
>|||Ok we finally got to the bottom of this problem - it seems that we needed to
give the SQL server service account permissions to the lock pages in memory
privelege, even though it was in the domain admin account. This was hard to
find, why is there so much conflicting documentation on this AWE setting?
"lramsdale" wrote:
[vbcol=seagreen]
> This is what we ran:
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> "Mike Epprecht (SQL MVP)" wrote:
>

No comments:

Post a Comment