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)
 /3GB switch

Author  Topic 

Kristen
Test

22859 Posts

Posted - 2004-12-03 : 13:15:40
Am I right in thinking that [out of the box] with 4GB RAM installed the O/S will get 2GB and SQL will get 2GB (rather than them both fighting over a single 2GB area)?

And /3GB makes NO difference UNLESS running SQL Enterprise Edition?

And if running Windows with /3GB in boot.ini AND SQL Enterprise Edition then SQL gets 3GB and Windows restricts itself to 1GB?

(The specific platform I'm interested in is Windows 2003 Server and SQL Standard, but my question is more for General Knowledge)

Thanks

Kristen

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-12-03 : 14:31:54
I believe you are correct on all accounts.
With Windows 2003, you have PAE for greater than 4GB's of RAM.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-12-12 : 16:49:11
Inside SQL Server 2000's Memory Management Facilities
How to configure memory for more than 2 GB in SQL Server:
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750

rockmoose
Go to Top of Page
   

- Advertisement -