SELECT [Whims_and_Fancies] from [my_SQL_Server_Knowledge];
This is the question:
I am configuring a server with Windows Server 2003 Standard Edition and SQL Server 2000 Enterprise Edition. The server has 4GB memory. From what I have read the AWE/PAE switch only works with Advanced Server or Datacenter Editions, which are not an option for me. What is needed for SQL Server to use 3GB of the memory for 2003 SE?
Solution: Refer to the forum post - http://sql-server-performance.com/Community/forums/t/14372.aspx in this regard.
About satya
SQL Server MVP.
SQL Master, Speaker & SQL Server helper.
16+ years of IT experience in which as a Sr. DBA and Technical Design Lead in sectors of Banking, Stock markets & Investment Banking, Manufacturing & consulting.
Out of professional activities :
Moderator - SQL Server Performance forums & MSDN forums in addition to my homepage above.
Active member of most of the SQL Server community forums.