RE: To do or not to do the /3GB
- From: "Steve Follett" <SteveFollett@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 27 Sep 2005 11:43:03 -0700
So along this same thread, I have a Windows 2003 standard edition server
running Standard edition SQL 2000, the server has 4GB of RAM installed.
After reading all the threads and tech articles I tried adding the /3GB
switch in the BOOT.INI to see the results. I expected to see the Target
Server Memory counter for the object SQL Server:Memory Manager be at around
2.7GB as I understood that there is around 300MB reserved. The results
seemed not to indicate that, so I removed the switch, now I see the memory
counter to be around 1.7GB which is inline with the 2GB for SQL minus the
300MB reserved.
With SQL standard and Windows 2003 standard am I chasing something that
cannot be done with 4GB of RAM on this OS?
"Harolds" wrote:
> Thank you very much, this is exactly what I was looking for.
> --
> Harolds
>
>
> "Sophie Guo [MSFT]" wrote:
>
> > Hello,
> >
> > Please refer to the following information in article 274750:
> >
> > 274750 How to configure memory for more than 2 GB in SQL Server
> > http://support.microsoft.com/?id=274750
> >
> > ------------------------------------
> >
> > Windows 2000 Server
> >
> > SQL Server 2000
> >
> > Normally, both the SQL Server 2000 Enterprise Edition and SQL Server 2000
> > Developer Edition can use up to 2 GB of physical memory. With the use of
> > the AWE enable option, SQL Server can use up to 4 GB of physical memory.
> >
> > NOTE: You cannot allocate more than 4 GB of physical memory to an
> > application on Windows 2000 Server because Physical Address Extension (PAE)
> > is not available on Microsoft Windows 2000 Server. Also, you cannot use the
> > 3 GB switch in the Boot.ini file with Windows 2000 Server; however, you can
> > use the 3 GB switch in the Boot.ini file with Microsoft Windows 2000
> > Advanced Server or Microsoft Windows Datacenter versions. For additional
> > information, click the following article number to view the article in the
> > Microsoft Knowledge Base:
> >
> > 291988 (http://support.microsoft.com/kb/291988/) A description of the 4 GB
> > RAM Tuning feature and the Physical Address Extension switch
> >
> > ------------------------------------
> >
> > You cannot use the 3 GB switch in the Boot.ini file with Windows 2000
> > Server. However, you can enable AWE to use more memory:
> >
> > sp_configure 'show advanced options', 1
> > RECONFIGURE
> > GO
> > sp_configure 'awe enabled', 1
> > RECONFIGURE
> > GO
> > sp_configure 'max server memory', 4000
> > RECONFIGURE
> > GO
> >
> > Note: you need to restart SQL server.
> >
> >
> > Please refer to the following topics in SQL server 2000 Books Online(BOL):
> >
> > Managing AWE Memory
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> > _1_server_1fnd.asp
> >
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> > _config_3stg.asp
> >
> > FIX: Not all memory is available when AWE is enabled on a computer that is
> > running a 32-bit version of SQL Server 2000 SP4
> > http://support.microsoft.com/kb/899761/
> >
> > I hope the information is helpful.
> >
> > Sophie Guo
> > Microsoft Online Partner Support
> >
> > Get Secure! - www.microsoft.com/security
> >
> > =====================================================
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> > =====================================================
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> >
.
- Follow-Ups:
- RE: To do or not to do the /3GB
- From: Harolds
- RE: To do or not to do the /3GB
- Prev by Date: Log shipping
- Next by Date: RE: To do or not to do the /3GB
- Previous by thread: Log shipping
- Next by thread: RE: To do or not to do the /3GB
- Index(es):
Relevant Pages
|
Loading
