I have a SQL 2000 Enterprise server on a Windows 2003 Standard Edition.
Seem I can only use 4GB max for SQL. How can I do the configuration for
enable above 2GB memeory from both windows and SQL server perspective.
/AWE, /3GB, /PAE for boot.ini '
sp_configure 'awe enable', 1
sp_configure 'max server memory' , 4096 ? ?How to configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/kb/274750/
AMB
"HG" wrote:
> I have a SQL 2000 Enterprise server on a Windows 2003 Standard Edition.
> Seem I can only use 4GB max for SQL. How can I do the configuration for
> enable above 2GB memeory from both windows and SQL server perspective.
> /AWE, /3GB, /PAE for boot.ini '
> sp_configure 'awe enable', 1
> sp_configure 'max server memory' , 4096 ? ?
>
No comments:
Post a Comment