Use /3GB? - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Use /3GB?

Author

Topic

beethoven
Starting Member

7 Posts

Posted - 2003-01-17 : 13:59:10

I have a SQL 2000 EE server running on Windows 2000 Advanced Server. With 6GB of memory in the server, should I be using the /3GB switch in the boot.ini or not? This machine is a dedicated SQL server.

Thanks!

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-01-17 : 14:21:12

You should add the /3GB and /PAE switches to boot.ini and enable AWE and set a maximum
amount of memory for SQL server e.g. 5 GB


use master
go
sp_configure 'show advanced options', 1
RECONFIGURE
go
exec sp_configure 'awe enabled',1
reconfigure with override
go
sp_configure 'max server memory',5120
reconfigure
go

Then restart the SQl service. Task Manager does not correctly report memory for processes
when AWE is enabled but you can use Performance Monitor to confirm SQL Server's Working Set.

HTH
Jasper Smith

beethoven
Starting Member

7 Posts

Posted - 2003-01-17 : 14:45:27

Thanks for the info.

The KB articles were real clear on exactly which switches should be set.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources